on 08-06-2014 12:15 AM
Hi Everyone,
I am wondering what the link is between a Goods Receipt Purchase Order and a Landed Cost. Here is a diagram of the link that I am trying to determine.
According to the Database Tables Reference there is a link between OPDN (Goods Receipt Purchase Order) and OIPF (Landed Costs) called 'ImportEnt', as shown below -
However I can't work out what 'ImportEnt' links to on the OPDN (Goods Receipt Purchase Order) side.
Any advice concerning how to link OPDN to OIPF will be greatly appreciated.
Kind Regards,
David
Hi,
Try this query:
SELECT T0.[DocNum], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity],T1.[BaseEntry],t2.docentry,T1.[LineNum],T2.[BaseLine], T1.[Reference] FROM OIPF T0 INNER JOIN IPF1 T1 ON T0.DocEntry = T1.DocEntry left join PDN1 T2 on T1.[BaseEntry] = t2.docentry and T1.[LineNum] = T2.[BaseLine] INNER JOIN OPDN T3 ON T2.DocEntry = T3.DocEntry
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.