cancel
Showing results for 
Search instead for 
Did you mean: 

Purchase Report

Former Member
0 Kudos

Hi Experts,

I need the simple query report on the following criteria.

Doc No. Doc Date Vendor Code Vendor Name Vendor Address Document Total

Which does not contain the AP Invoices against which AP Credit memo made.

Regards,

Datta Kharat

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Datta......

Try this.....

SELECT T0.[DocNum],  T0.[DocDate],  T0.[CardCode],  T0.[CardName],  
T0.[NumAtCard],  T0.[DocTotal],
 T0.[Address]
 FROM OPCH T0  INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry 
WHERE T1.[TargetType] !='19'

Regards,

Rahul

former_member206488
Active Contributor
0 Kudos

Hi,

Try this:

SELECT T0.docNum ,T0.DocDate,T0.CardCode,T0.CardName,T0.[Address] as [Bill To Address] ,T0.Address2 as [Ship to Address],DocTotal 
From OPCH T0

or

SELECT distinct T0.docNum ,T0.DocDate,T0.CardCode,T0.CardName,T0.[Address] as [Bill To Address] ,T0.Address2 as [Ship to Address],DocTotal 
From OPCH T0 Inner JOin PCH1 T1 on T0.DocEntry =T1.DocEntry 
WHERE t1.TargetType !='19'

Thanks,

Neetu