Skip to main content
Answer

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

  • June 15, 2023
  • 3 replies
  • 77 views
P
Freshman I
Forum|alt.badge.img

 

Best answer by npace29

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

    Laura03

    3 replies

    N
    Varsity I
    Forum|alt.badge.img+1
    • npace29
    • Varsity I
    • Answer
    • June 15, 2023

    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

    Chris Hackett
    N
    Varsity I
    Forum|alt.badge.img+1
    • npace29
    • Varsity I
    • June 15, 2023

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

     

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

    P
    Freshman I
    Forum|alt.badge.img
    • prabhu83
    • Author
    • Freshman I
    • June 15, 2023

    Okay, Thank you. its working

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    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