Skip to Content
Jan 21, 2015 at 10:42 AM

Sales Order Discount Summery Report


Hi Experts,

I wand to generate a 'Sales Order Discount Summery Report' to know discount report of outlets.

In my company (Separate Database) all outlets are adding Sales Order and they are giving discount based on total amount of invoice.

Now am using the following query to get this report.

SELECT T1.[DocNum] AS 'Order No:', T1.[DocDate] AS 'Posting Date', T1.[NumAtCard] AS 'Reference No.', T1.[CardCode] AS 'Customer Code', T1.[CardName] AS 'Customer Name', T0.[OpenSum] AS 'Invoice Amount', T1.[DiscPrcnt] AS 'Discount (%)', T1.[DiscSum] AS 'Discount Amount', T1.[VatSum] AS 'Tax Amount', T1.[DocTotal] AS 'Net Amount (After Discount)' FROM [dbo].[RDR1] T0 INNER JOIN [dbo].[ORDR] T1 ON T1.[DocEntry] = T0.[DocEntry] WHERE T1.[DocDate] >= (CONVERT(DATETIME, '[%0]', 112) ) AND T1.[DocDate] <= (CONVERT(DATETIME, '[%1]', 112) )

But in this query am not getting a summery report.

Please any one can help me to get a summery report of each order.

Thanks & Regards,

Abdul Rasheed