Hello
I have made the following query
SELECT T0.[DocNum], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[PriceFOB], T1.[Currency], T1.[PriceFOB]*T1.[Rate] as 'Prix Achat FCFA', T1.[Cost], T1.[PriceAtWH] FROM OIPF T0 INNER JOIN IPF1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[ItemCode] >= [%0] and T1.[ItemCode] <= [%1] AND T0.[DocDate] >=[%2] AND T0.[DocDate] <=[%3]
the problem is T1.[PriceFOB] is shown as an integer so instead of 0.69 it shows 1 how to change it to show the 2 digits...
Thank you