Skip to main content
Solved

Cash Flow Statement in ARM with a YTD column

jhouser
Captain II
Forum|alt.badge.img+3

Has anyone successfully written a Cash Flow Statement in ARM with a YTD column? Am stuck and would appreciate any help!

Best answer by jhouser

I figured out a solution that works. I set report definition to require beginning and end period. Then in column set I added a column for each period (1 - 12) with a visibility expression based on periods selected. Last column is the YTD. 

View original
Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
    Did this topic help you find an answer to your question?

    4 replies

    nhatnghetinh
    Captain II
    Forum|alt.badge.img+11

    Hi ​@jhouser 

    Please refer to the screenshots below.

     

     

     

     

    Best Regards,

    NNT

    I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/truongpham80
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    jhouser
    Captain II
    Forum|alt.badge.img+3
    • jhouser
    • Author
    • Captain II
    • 108 replies
    • March 5, 2025

    ​@nhatnghetinh Thanks for response. Is the report working though? It doesn’t balance at the bottom, and doesn’t seem right that Cash at Beginning would be the same PTD (beginning of March) as YTD (beginning of January)

    Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    jhouser
    Captain II
    Forum|alt.badge.img+3
    • jhouser
    • Author
    • Captain II
    • 108 replies
    • Answer
    • March 10, 2025

    I figured out a solution that works. I set report definition to require beginning and end period. Then in column set I added a column for each period (1 - 12) with a visibility expression based on periods selected. Last column is the YTD. 

    Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • 2809 replies
    • March 11, 2025

    Thank you for sharing your solution with the community ​@jhouser!

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie 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