on 06-05-2011 2:49 PM
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
Hi,
Try this;
SELECT T0.TRANSID, T0.Line_ID, T0.Debit
FROM JDT1 T0
LEFT JOIN ITR1 T1 ON T1.TRANSID=T0.TRANSID
WHERE T0.TRANSID LIKE '[%0]%' AND T0.Debit !=0 AND T1.TRANSID IS NULL
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.