Question

How to get the financial period name in an ARM Report

  • 10 November 2021
  • 3 replies
  • 15 views

Userlevel 1
Badge

A client was using the formula MonthName(@MonthStart,-1) in a column heading.  Obviously this use the current date and does not allow the specification of a starting period.  Using Report.FormatPeriod(@StartPeriod,-1) gets the period as 10-2021, 09-2021, etc.  Is there another formula that would return the description of the period as Oct 2021, Sep 2021 etc?


3 replies

 

Userlevel 1
Badge

Thanks, should have more examples like this is help, manuals, and training courses.

Userlevel 1
Badge

It does not support the shift option like =Report.FormatPeriod(@StartPeriod,-4)

Reply


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 — 2020  Acumatica, Inc. All rights reserved