I try to develop one query based report based on price list. In price list Primary currency & additional currency1 defined.
If i try to execute multi currency price list report, unable to include in additional currency in report. Additional currency shows as variable field.
Can you please guide me.
SELECT T0.[ItemCode], T0.[ItemName], T1.[ItmsGrpNam], T2.[Price],T3.[PrimCurr], T0.[validFor],T3.[AddCurr1] FROM OITM T0 INNER JOIN OITB T1 ON T0.[ItmsGrpCod] = T1.[ItmsGrpCod] INNER JOIN ITM1 T2 ON T0.[ItemCode] = T2.[ItemCode] INNER JOIN OPLN T3 ON T2.[PriceList] = T3.[ListNum] WHERE T3.[ListNum] ='3'