By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
2
Posts
2
Users
2
Reactions
2,009
Views
February 16, 2022 9:33 am
Hello! I've searched old posts trying to combine ideas to get this accomplished, but I'm still struggling. I am trying to create a GI that has show the transaction for current year e. g. 2022. i tried using @Yearstart and it doesnt seem to work on my result grid formula.
Can anyone help?
Thanks in advance for any help.
1 Reply
February 22, 2022 10:45 pm
Just use MasterFinPeriod Table and find the period where StartDate >= Today() and FinDate <= Today().
You can then join to FinPeriodID in your Relations.
Which transactions are you trying to find? if GL then there's other things you need to consider.
Online Members
