Hi All,
This following query made me confusing:
SELECT T0.DocNum, T0.DocDate, T0.CardCode, T1.InvoiceId, T1.DocEntry, T1.InvType, T1.ObjType FROM ORCT T0 INNER JOIN RCT2 T1 ON T0.DocNum = T1.DocNum
The result is as follows:
No. Document Number Posting Date Customer/Vendor Code Sequence No. Invoice Key Invoice Category ObjType
1 1 15.11.2004 C9999 9 13 24
2 2 22.12.2007 C1006 12 13 24
3 2 22.12.2007 C1006 1 13 13 24
4 2 22.12.2007 C1006 2 4 14 24
5 2 22.12.2007 C1006 3 14 13 24
When I click 'Invoice Key' of no. 4 row, it shows invoice instead of AR credit memo, do I have to reconcile the credit memo to one of invoice although I create credit memo without copied from invoice ?
Please help me to provide new query.
Balaj
Edited by: Balajhi Venkatesh on Dec 22, 2007 10:36 AM