Skip to Content
0
Former Member
Jun 05, 2011 at 01:49 PM

Query for get unreconciled JDT1 Lines

974 Views

Hi

I need to get the fully or partially unreconciled Jouran entry lines for a G/L.

I had a query but this is only shows the fully unreconciled entries

Select * from dbo.OJDT T0 WHERE T0.transid NOT in (Select transid from itr1)

how to get the unreconcile JE lines which are are all not fully reconciled

Advance Thanks to sovers