How To create / Design Custom Date Financial Reports in Acumatica?
Solved
Custom Date Financial Reports
Best answer by Laura03
Hello
I think your report request is very difficult to produce accurately.
Acumatica would need to calculate 2/15 totals using 1/31 period ending balances for every account, plus or minus every transaction from 2/1 to 2/15 based on the account type.
How will the report handle a transaction that is dated 1/14 and posted to period 1 in your example? Will the transaction be included, or excluded? Excluding a transaction dated 1/14 will make the Balance Sheet for 1/15/2023 to 2/15/2023 incorrect. Excluding a transaction dated 1/14 will make the P & L for 1/15/2023 to 2/15/2023 correct.
One way to expand financial reporting is to consider using Weeks as Financial Periods as discussed in this prior post:
Did you vote for your idea here?
Thank you.
Laura
+20Hello
Are you asking how to create a P & L or Balance sheet “as of” a date that is not the end of a fiscal period?
It will help us to answer if you can give us more detail and a screen shot, example of what you need. Thank you!
Laura
Hello
Yes, The financial Report as of date for Eg.. P& L or Balance Sheet from 01/15/2023 to 02/15/2023(custom date) instead of Period , Kindly Advise
+20Hello
I think your report request is very difficult to produce accurately.
Acumatica would need to calculate 2/15 totals using 1/31 period ending balances for every account, plus or minus every transaction from 2/1 to 2/15 based on the account type.
How will the report handle a transaction that is dated 1/14 and posted to period 1 in your example? Will the transaction be included, or excluded? Excluding a transaction dated 1/14 will make the Balance Sheet for 1/15/2023 to 2/15/2023 incorrect. Excluding a transaction dated 1/14 will make the P & L for 1/15/2023 to 2/15/2023 correct.
One way to expand financial reporting is to consider using Weeks as Financial Periods as discussed in this prior post:
Did you vote for your idea here?
Thank you.
Laura
Is it Possible to generate a monthly P&L report in ARM that can span across multiple fiscal years based on user-selected Start Period and End Period.
Example:
- Start Period: 01-2025
- End Period: 05-2026
The expectation is to display month-by-month P&L columns dynamically for the selected range (17 months in this example).
Currently, it appears that ARM requires predefined columns for each month/period, meaning:
- 12-month report requires 12 predefined columns
- 17-month report requires 17 predefined columns
- 24-month report requires 24 predefined columns
Can anyone confirm:
- Whether ARM supports truly dynamic column generation based on Start/End Period?
- Is there any recommended approach to avoid maintaining multiple predefined column sets?
- Has anyone implemented a rolling multi-year monthly P&L report efficiently in Acumatica?
- Are there any best practices using column sets, row sets, variables, or Generic Inquiries for this scenario?
Appreciate any guidance or suggestions from the community.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.