How To create / Design Custom Date Financial Reports in Acumatica?
Solved
Custom Date Financial Reports
Best answer by Laura02
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
1 person likes this
+19Hello
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
1 person likes this
+19Hello
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
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
1 person likes this
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.