Hello @jvarughese23 ,

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 @Laura02 

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

Hello @jvarughese23 ,

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