Skip to Content
0
Former Member
Dec 22, 2007 at 09:36 AM

Invoice key column shows different document

186 Views

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