Solved

How to FinPeriodID Parameter pass to YYYYMM format(202306) in Report Designer?

  • 15 June 2023
  • 3 replies
  • 48 views
P
Rank
Userlevel 1
Badge

 

icon

Best answer by npace29 15 June 2023, 08:53

View original

3 replies

N
Rank
Userlevel 2
Badge +1

Hello,

 

You may try using the following formula in the Joins / Relations or conditions of the report.

 

LEFT([ICViewFATranListReport.FinPeriodID],4) + '' + RIGHT([ICViewFATranListReport.FinPeriodID],2))

 

Nigel

N
Rank
Userlevel 2
Badge +1

If the above does not work, you may try the following instead:

 

RIGHT([ICViewFATranListReport.FinPeriodID],4) + '' + LEFT([ICViewFATranListReport.FinPeriodID],2))

P
Rank
Userlevel 1
Badge

Okay, Thank you. its working

Reply


Terms & ConditionsCookie settings
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 — 2024  Acumatica, Inc. All rights reserved