Hello all,
I am writing a query to display the Landed Cost Number, Posting Date, Actual Customs, Shipping Amount, Inland Freight, Others.
SELECT
T0.[DocNum], T0.[DocDate], T0.[ActCustom]
FROM
OIPF T0 INNER JOIN IPF2 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OALC T2 ON T1.[AlcCode] = T2.[AlcCode]
WHERE
T2.[AlcCode] IN ('Shipping','Inland Freight', 'Others')
Please help me correct the above query.
The tables used are OIPF, IPF2, OALC in that order in query generator.
How can I disply the Shipping Amount, Inland Fright Cost, and Others Cost?