Balance Sheet in SAP Business One

[aarati_kollur2]

Dear All,

Done period end closing for the year 2018 as we all know that in utility for the date we have two fields viz Document date and due date here I put date 31.12.18.

After period end closing on 1-1-19 posting date, 31.12.18 Doc. Date, Automatic JE (Origin) posts between "Period End Closing" and "Retained earnings".

So when a user runs the Balance Sheet report as on 31.12.18 (Date "Posting Date) all values coming properly.

When a user runs the Balance Sheet report as on 1.1.19 (Date "Posting Date) opening balance of "Retained earnings" not appearing rather a value appearing against the "Period End Closing" account.

If the user runs the Balance Sheet as on 31.12.18 and 1.1.18 (Date "Document Date") values come properly.

So want to know why Balance Sheet report behaves like this. What is the difference between the balance sheet according to the posting date and document date in SAP Business One?

Regards

Aarati Kollur

[former_member419030 · Accepted solution]

Dear Aarati,

Have you tick the checkbox Add Closing Balance at the Balance sheet selection criteria?

[aarati_kollur2 · Accepted solution]

resolved thank you.

[Abdul]

I believe while doing period end closing user mentioned different dates like posting date is different and document date is different . Go to period end closing account details and check on entries if dates are same then its issue

[jitin_chawla]

Hi,

Please share some screenshot to check what the problem.

regards,

Jitin C