Hi Guys,
Within the Payment Wizard is a report called " Non Included Transaction Report", later in the wizard also referred to as "Error Log Report (System)".
I would like to recreate this report so that I can add some additional fields on the Purchase Invoice side only, to make the report more helpful.
I believe the tables I require are PWZ5 and OPOR, however when I run my query I get 96,000 plus entries returned which is not correct for just one month !
This is the query I have:
SELECT distinct T0.[InvID], T0.[CardCode], T0.[CardName], T1.[DocDate], T1.[DocDueDate], T1.[Ref2] AS [Supplier Invoice No], T0.[Amount], T0.[ErrDisc] FROM PWZ5 T0 , OPOR T1 WHERE T1.[DocDueDate] >=[%0] AND T1.[DocDueDate] <=[%1]
Am I on the right tracks or have I missed the mark by a country mile - could someone please point me in the right direction or has anyone else recreated this ?