Skip to main content
Solved

Cash Flow Statement in ARM with a YTD column

  • March 4, 2025
  • 6 replies
  • 210 views
jhouser
Captain II
Forum|alt.badge.img+7

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. 

Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/

    6 replies

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

    Hi ​@jhouser 

    Please refer to the screenshots below.

     

     

     

     

    Best Regards,

    NNT

    I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
      jhouser
      Captain II
      Forum|alt.badge.img+7
      • jhouser
      • Author
      • Captain II
      • 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/
        jhouser
        Captain II
        Forum|alt.badge.img+7
        • jhouser
        • Author
        • Captain II
        • 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
          Community Manager
          Forum|alt.badge.img
          • Chris Hackett
          • Acumatica Community Manager
          • 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*.
          H
          Semi-Pro III
          Forum|alt.badge.img
          • Harry
          • Semi-Pro III
          • May 1, 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. 

          Hey ​@jhouser , did u add all of the periods have the Amount Type = Ending Balance or Turnover? for YTD column?

          jhouser
          Captain II
          Forum|alt.badge.img+7
          • jhouser
          • Author
          • Captain II
          • May 1, 2025

          ​@Harry Turnover for the period columns, Ending Balance for YTD column. For this one, in the row set I had to specify Turnover for the Net Additions to Fixed Assets row. 

          Contract for hire: https://www.linkedin.com/in/jesse-houser-052817b6/
            Terms & ConditionsAccessibility 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