Skip to Content
0
Former Member
Feb 17, 2009 at 08:14 AM

Transaction listing for sales

13 Views

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