What is the table which displays cumulative balance in SAP B1?.

[former_member183402]

Hi all,

How can I find table which displays cumulative balance of GL account according to posting date in SAP B1?

Please anyone can help me.

[jitin_chawla]

Hi,

For the opening balances you need to check the TransType as '-2' from the OJDT/JDT1 table.

Regards,

Jitin

[jitin_chawla]

Hi,

Cumulative balance of a G/L Account is calculative field and not a field which is available in table.

You can try by using the Debit and Credit field and its plus/minus based on the entry in the G/L Account before the Posting Date in the JDt1 table.

Regards,

Jitin

[former_member183402]

Hi Jitin,

Yes I have tried to use calculation, but how can I get opening balance? Because we need the opening balance in calculation in order to get cumulative balance.