link between excise and purchase document

[Former Member]

how do you link the excise and GRPO or A/P Invoice in a select query?

[Former Member]

Hi Krishna,

IF you need the link for Excise and GRPO or A/P Invoice.

Try the below Links and Query.

Link the Excise and GRPO

SELECT * 
FROM OIEI T0  
INNER JOIN IEI1 T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN OPDN T2 ON T2.DocNum = T1.BaseRef

Link the Excise and A/P Invoice

SELECT * 
FROM OIEI T0  
INNER JOIN IEI1 T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN OPCH T2 ON T2.DocNum = T1.BaseRef

Try this Query, Link the Excise and GRPO in a Select Query

SELECT T0.[DocNum], T1.[BaseRef], T2.[DocNum], 
T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[LineTotal] 
FROM OIEI T0  
INNER JOIN IEI1 T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN OPDN T2 ON T2.DocNum = T1.BaseRef

Regards,

Madhan.