Table name of Opening Balances

[Former Member]

Hi all,

Can any one please let me know about the Back End Table name where in which the Opening Balances of G/L a/c, Business Partners and Opening Stock which i am updating in Initial Quantities, inventory tracking and Stock Posting window.

Thanks,

Narsing.

[Former Member]

All inventory related receipts and issues are recorded on 'OINM' table, you can query the OINM table to check the opening balance

SELECT *  FROM OINM T0 WHERE T0.[TransType] = -2

[Former Member]

Hi

Basically all transaction go thru jornal entry where u can collect each information that u hav pass as opening balance

SELECT *  FROM OJDT T0 WHERE T0.[TransType] = -2

Where -2 stand for Opening Balance.

for more detail u can also pass query as

SELECT *  FROM OJDT T0 WHERE T0.[TransType] = [%0]

Thanks

Kevin