SAP Business ByDesign - Finance - Account balance

[former_member596214]

Hello,

i have a question regarding Report Settings for accounts, Customer or supplier accounts: How can i manage to get a continuous account Balance. Not an account Balance per line>that is of no use. I Need an continuous account Balance->an actual Balance after each booking. Does anybody know if and how i can Change the Settings to get the result? Thanks in advance. best regards NH

[thomas_meder]

Hello Nik,

you've two options here:

1. Either use a report ending with "audit trail" (=Kontenschreibung). This report has, at least at some levels (in my example: G/L Account and Period) subtotals giving the balance.
   
2. Or, and this might fit your requirement better, create a new calculated key figure, that just uses the balance key figure in the formula (without any further calculation), and set the "cumulative keyfigure" flag to "on" in the last step. This should help you best.

Best regards,

Thomas

[former_member596214]

Hello Thomas,

thanks for your very quick Response. The "Audit Trail" (Kontenschreibung) Looks very good to me. That is what i was looking for, for a Long time.

My suggestion: Use the "Saldo" like in the Audit Trail Report for all the Reports. thats my opinion, knowing other Accounting programs and switching to SAP.

Thanks

BR

NH

[caroline_lost]

Dear Nikolaus,

Can you please let us know which report you are using to check supplier or customer account balances? Why exactly does it not suffice your requirements?
Could you give us have an example of two or three transactions and how they are displayed in the report?

Thanks an kind regards,

Caroline

[thomas_meder]

Hello,

I don't really understand how to solve the contradiction in "no balance per line" and "I want a balance per posting" 🙂

Perhaps try the reports that have "audit trail" in their name. Might solve your issue.

Best regards,

Thomas

[former_member596214]

Hallo Thomas,

meine Frage ist wie ich einen echten Saldo einstellen kann? Derzeit bekomme ich immer nur eine Saldo pro Zeile angezeigt also pro Buchung - siehe Screenshot.

Ich benötige einen fortlaufenden Saldo-siehe Screenshot.

Bitte um Hilfestellung, wie ich zu einem fortlaufenden Saldo komme.

Vielen Dank

NH