cancel
Showing results for 
Search instead for 
Did you mean: 

Openings

Former Member
0 Kudos

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

View Entire Topic
Former Member
0 Kudos

You may check these threads:

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordon

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

Thanks

Former Member
0 Kudos

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
0 Kudos

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