Balance Sheet/P+L Statement by date ranges using FinancStatementVersion

[eduardo_gironas]

The Accountant boss wants to see Balance Sheet/P+L Statement not by periods but selecting a "from posting date" and a "to posting date".The output should be based on a Financial Statemente Version which is yet created.

The problem here is that both "from posting date" and "to posting date" do not exist as part of a "selection screen" under, for example, transaction S_ALR_87012279 (Structured Account Balances) and other similars.

Technically I was thinking to download the accounting items into the range posting dates, then download the Financial Statement Version and after that, build the balance with an external program.

However, I ask for myself: Why doesn't SAP have this option as part of its standard? Is there any technical reason (I suspect that because of GLT0 table) or legal reason for not having this reports? How can I persuade to the Accountant Boss for not asking for this kind of reports?

Hope It was understood.

Best regards!!!

[former_member625419 · Accepted solution]

Dear

You can create Posting date wise Balance Sheet/P+L statement.

Use t-code FGI6 for the same and design the same report as per your requirement.

Regards,

Rup

[eduardo_gironas · Accepted solution]

Rup:

Thanks for the attention to this message.

Your answer looks promising (and my last hope), Since yesterday I am trying to accomplish the "You can create Posting date wise Balance Sheet/P+L statement". Let me ask you, how can I do that? may you please give me some guidelines?

Thanks for your help!!!

[Former Member]

I am also facing the same problem. i.e I am not getting Balance Sheet & Profit & Loss account on day wise. This will also help to trace the entries which are wrongly posted. Any things about it pls let me also know.

regards

[Former Member]

Hello All,

check this link: http://scn.sap.com/docs/DOC-33697

Thanks,

Sharif

[Former Member]

Did you try confuguring 'Day Ledger" and you must be able to acheive what you want with this.

Ravi Thothadri

[Former Member]

Hi Ravi,

Can you please elaborate further..

What would you mean by "Day Ledger", How and where is it configured?