Skip to Content
Former Member
Jul 29, 2009 at 07:09 AM

Purchase report


Hi Experts,

I written the query in query generator,

In selection criteria, Posting Date From and To Date and Profit center,

This is the query;

SELECT T0.[DocNum], T0.[DocDate], T0.[CardName], (T0.[DocTotal] -T0.[VatSum]) AS 'Document Value', T0.[VatSum], T0.[DocTotal] FROM OPCH T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[DocDate] >= [%0] AND T0.[DocDate] <= [%1] AND T1.[OcrCode] =[%2]


No data was found in the selection criteria.

wat can i do....

can u suggest me....

thanks in advance.