Skip to Content
0
Former Member
Dec 20, 2010 at 09:45 AM

Report in Payment Wizard - Non Included Transaction Report

204 Views

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 ?