Skip to Content
0
Former Member
Jan 19, 2012 at 07:42 AM

Invoice report with BPChCODE and BPChName

44 Views

Hello Xperts

I want to produce a report that will show Invoices by country and their BPChCODE and BPCh NAME

In order to get the BPCh name, I have linked a second OCRD Table.

but now the query gives me only the Invoices that has BPChCODE, I want to see ALL of the Invoices, inclding ones that dont have a BPChCode.

SELECT
T1.DocNum,  T1.CardCode,  T1.CardName,
*T1.bpchcode,  T4.CARDNAME,*
T0.ItemCode

FROM INV1 T0  
INNER JOIN OINV T1 ON T0.DocEntry = T1.DocEntry 
INNER JOIN OCRD T2 ON T1.CardCode = T2.CardCode 
INNER JOIN OCRY T3 ON T2.Country = T3.Code 
*INNER JOIN OCRD T4 ON T1.bpchcode = T4.CardCode* 

WHERE   T3.Name = '[%0]'

Please Help ..... Thanks !

Medalion.