Skip to main content
Answer

Cash Flow Statement in ARM with a YTD column

  • March 4, 2025
  • 6 replies
  • 121 views

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

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. 

6 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • March 5, 2025

Hi ​@jhouser 

Please refer to the screenshots below.

 

 

 

 

Best Regards,

NNT


jhouser
Captain II
Forum|alt.badge.img+6
  • 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)


jhouser
Captain II
Forum|alt.badge.img+6
  • 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. 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • March 11, 2025

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


Forum|alt.badge.img
  • Semi-Pro II
  • 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+6
  • 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.