Financial Report Definition - column matter

  • 7 November 2021
  • 3 replies

Userlevel 2
  • Jr Varsity II
  • 100 replies

Hi All

Not sure if anyone know how to define the column C below in RED BOX details

Currently , i would like to create a Balance sheet Report comparative month to month

Example: Balance Sheet Report Comparative  Sept 2021 and Aug 2021

I manage to set for Sept 2021 in column B  , however i am not sure how to set for Aug 2021 in column C , Refer to below in RED BOX highlighted

I tried the formula in  = Format( '{0: MMMM d, yyyy}',Report.GetPeriodEndDate(@StartPeriod,-1)) is not workable.

May i know who can help in this formula?




Best answer by ChandrasekharM 8 November 2021, 08:22

View original

3 replies

Userlevel 6
Badge +6

Hi @erin Please use the formula as shown in the below screenshot.



Userlevel 6
Badge +6

Hi @erin  The formula to show the enddate for the next period is 

=Format( '{0: MMMM d, yyyy}', Report.GetPeriodEndDate(Report.FormatPeriod(@StartPeriod, 1)))

Userlevel 6
Badge +6

Hi @erin Please find the below screenshot showing the expected result with the above formula.




About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved