Skip to Content
0

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

Feb 20, 2017 at 11:13 AM

285

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jitin Chawla
Feb 20, 2017 at 11:28 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0
Jitin Chawla
Feb 21, 2017 at 03:16 AM
0

Hi,

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

Regards,

Jitin

Share
10 |10000 characters needed characters left characters exceeded