Dear All.
I am trying to obtain a transaction listing that has the cost price and selling as well as Gp. If I use the INV1_BasePrice all I get in my query is the letter (E). Any indication of how I perform this. My query is as below
Select
T0.[DocDate], T0.[CardName], T0.[DocNum], T0.[SlpCode], T2.[SlpName], T1.[ItemCode], T1.[Dscription], T1.[Dscription], T1.[Quantity], T1.[Price]
From
[dbo].[OINV] T0 INNER JOIN [dbo].[INV1] T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OSLP T2 ON T0.SlpCode = T2.SlpCode
Where
T0.[DocDate] > [%0] and T0.[DocDate] <[%1]
Groupe by
T0.[DocDate], T0.[DocDueDate],T0.[DocNum], T0.[SlpCode],T2.[SlpName], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[Price]
Many thanks Martin