By using this website, you agree to our Terms of Use (click here)
Hello,
I have been trying to use the formula below to show a fiscal period by displaying the month with letters, for example "August", instead of for example the period 08-2020. I can get the below formula to show "August" etc in the balance sheet, but I can not get anything to work in journal transactions (GL633000).
=Report.GetPeriodDescription(@StartPeriod)
I have also tried using this formula for the same reason without result:
=Format( '{0: MMM yyyy}', Report.GetPeriodEndDate(@StartPeriod))
To sum it up: When I am running a journal transaction report if I select the starting period 01-2020 and end period 12-2020, I would like to have January and December show up in the journal transaction report in the top/header section.
Small disclaimer: I am using Visma.net, which is a product built on Acumatica for the Nordic market. I have found a lot of well built formulas on this forum that has helped me with other issues, but the above issue I can not solve. I apologize for any grammatical mistakes or unclear vocabolary due to me not working in English.
I think you're missing the first Parameter in the GetPeriodEndDate formula.
Here's a formula from the DPLP Column Set in the SalesDemo database:
='As of ' + IIf(@UseMasterCalendar OR Len(@Organization)=0, Format('{0: MMMM d, yyyy}', Report.GetPeriodEndDate(0, @StartPeriod) ), Format( '{0: MMMM d, yyyy}', Report.GetPeriodEndDate(@Organization, @StartPeriod) ) )
I appreciate you trying to help me. Like I mentioned in my other thread I believe due to me working in a very old version this formula is not working. For example @UseMasterCalendar does not work as a reference in this window.
The parameters I can find in the Visma.net report designer database in journal transactions (GL633000) is a very short list, and I find that existing reports use formulas and references that don't exist in the expression database in Visma.net report designer, which basically means that the list of formulas and references I can see is incomplete. This makes it hard to build more complicated formulas cause I have to test what works and what doesn't.