Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to obtain the balance of a ledger account

Hi,

I need to obtain the balance of a ledger account at a specific date, as does the report "General Ledger" of SAP Business One.

Currently, I obtain the balance at a specific date with the following calculation,

Select (Debit - Credit) SALDO

Where dRefDate < "Specific Date" and Account = "Specific Account"

FROM JDT1

But, the DataBase is very huge, has a lot of records.

I need to know if it's posibble to obtain this balance in a way more efficient.

Regards.

Tags:
Not what you were looking for? View more on this topic or Ask a question