Openings

[Former Member]

Hi

I entered opening balances before 01/04/2010. Now i want to see tose opening figures of Chart of Account,s Business Partner,Inventory . How can i see this

Thanks

[Former Member · Accepted solution]

You may check these threads:

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon

Thanks , but is it possible to get customer name , or chart of accounts description also.

Thanks

[Former Member · Accepted solution]

Try this to see what you may get:

SELECT Distinct T0.Account, T0.ShortName, T1.Memo FROM dbo.JDT1 T0

INNER JOIN dbo.OJDT T1 ON T0.TransID = T1.TransID

WHERE T0.TransType = -2

[Former Member · Accepted solution]

Hi

For BP & CoA

Run Trial Balance by seleting Opening balance

For Stocks

Run Invenoty Audit Report with from & To date same as the date you uploaded the O balance

Sandeep

[Former Member]

Closed.

[Former Member]

Hi Manish.....

From which documen you entered the opening?

Regards,

[Former Member]

Hi

Through Administration - system initialisation - opening balances

inventory - inventory transactions - initial quantities

Thanks