Applies to Product – Dynamics 365 Business Central
What’s happening?
Customers are seeking to set up a column definition in cash flow reports that displays the increase/decrease between the previous period and the current period for balance sheet accounts, while showing net change for income statement accounts, all within a single report.
Resolution:
To achieve the desired configuration in the cash flow report, follow these steps:
1. Define the Comparison Period Formula in the Column Definition:
- Set the current period formula to be blank.
- Set the previous period formula to -P
2. Ensure that the financial statement row definition uses Type Posting instead of Account Category for the Totaling Type.
3. Use a range of accounts for the Accounts Receivable, Prepaid Expenses, etc., in the financial statement row definition.
4. Verify that the budget entries are included in the first column of the spreadsheet for the column definition.
5. If challenges arise, note that the financial statement column definition overlays the financial statement row definition, which may impact the results.
If further assistance is needed, consider reaching out to support to clarify the setup.