Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 20, 2017 at 11:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21, 2017 at 03:16 AM

    Hi,

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

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded