Using an ARM report, is it possible to create a Cash Flow Statement with a column for the period and a column for YTD?
Answer
Cash Flow Statement Multiple Columns
Best answer by Laura03
Hello,
Your report will need to contain 12 columns of Turnover; or 13 depending on the number of fiscal periods in your year.
Your report will need to contain 12 TOTAL columns, or 13 depending on the number of fiscal periods in your year. Each total column is CalcType with Values like this:
Period 1 Total: =B
Period 2 Total = B+C
Period 3 Total = B+C+D
Etc.
Each column of figures needs a Visibility formula, to hide/show proper columns in response to the user’s Parameter selections.
Here are some formula examples that can be used to build a flexible report that will work great no matter what period or year is selected by the users:
The following example is from a Quarterly report where one or more quarters is shown based on the User’s choices:
I hope these examples help you.
Laura
+1Yes, you can add columns to the Cash Flow Statement.
+11Hi
You can create multiple columns for example 12 months as follows.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
@nhatnghetinh I understand how to do this for P&L and Balance Sheet formats. I just can’t figure it out for the Cash Flow. Basically, I want these two columns of data side by side.
Since the report uses Turnover, I need the Offset Start Period to change when the End Period changes.
+19Hello,
Your report will need to contain 12 columns of Turnover; or 13 depending on the number of fiscal periods in your year.
Your report will need to contain 12 TOTAL columns, or 13 depending on the number of fiscal periods in your year. Each total column is CalcType with Values like this:
Period 1 Total: =B
Period 2 Total = B+C
Period 3 Total = B+C+D
Etc.
Each column of figures needs a Visibility formula, to hide/show proper columns in response to the user’s Parameter selections.
Here are some formula examples that can be used to build a flexible report that will work great no matter what period or year is selected by the users:
The following example is from a Quarterly report where one or more quarters is shown based on the User’s choices:
I hope these examples help you.
Laura
~ Laura Barber, WM Synergy
+19Hello
To Show Net Income, add the Net Income account number or its Account Class into your Cash Flow Row Set.
Chart of Accounts:
If Net Income is set up as shown above and not printing:
- Is Net Income $0 for the Period that is being printed?
- If $0 rows are hidden, unhide them by un-checking suppress Empty/Hide $0.
- Check for Restriction Groups that could hide individual accounts from your User ID. If restriction groups are hiding Net Income, uncheck Apply Restriction Groups in the Report Definition on Cash Flow report:
Laura
Using the ARM report for the Balance Sheet - I am having trouble with the turnover formula. I have a consolidated column and a Prior Year column but my turnover Consolidated- Prior Year is not calculating correctly. Any insight would be appreciated.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.