Skip to Content
0
Former Member
Feb 22, 2016 at 09:02 AM

Additional currency price list report

41 Views

Hi Experts,

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'