When running the 12-Month P&L Rolling ARM report in Acumatica based on the Budget Ledger, the report still displays values from the Actual Ledger. The Column Set or Row Set in the report is not specific to any ledger.
Has anyone experienced this issue before? Could it be related to the report configuration or a missing setting in the ARM definition? Any insights or guidance on resolving this would be greatly appreciated!
Best answer by mclarke88
Check your row set and data source to see if there is the actual ledger specified at that level? Sometimes that overrides what’s in the column set.
+15
In Acumatica ERP, you can select a specific ledger in Report Definitions to filter or refine the financial data displayed in a report. This feature allows you to customize reports to show data from a particular ledger.
You can typically find the ledger selection:
Check your row set and data source to see if there is the actual ledger specified at that level? Sometimes that overrides what’s in the column set.
New column set wouldn’t fix it if the data source in the row set is directing to the wrong ledger. Open up your row set → go to the data source → and see what’s in the ledger field.
send me XML export of your report from report definitions?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
