Skip to Content
Oct 11, 2019 at 07:55 AM

AP Invoice BP Reference


Hi all

How to join this Query to AP Invoice OPCH and PCH1 to show AP Invoice BP Reference No? I tried this Query but no result.

SELECT T0.[TargetType], T0.[DocEntry], T1.[DocEntry], T0.[TrgetEntry], T1.[DocEntry], T1.[BaseRef], T2.[NumAtCard] FROM PDN1 T0 LEFT JOIN PCH1 T1 on T1.[BaseRef]=T0.[TrgetEntry] INNER JOIN OPCH T2 ON T1.[DocEntry] = T2.[DocEntry] WHERE T0.[DocEntry] =1