Dear Experts,
I have developed the query for weekly sales report for the alert management to send out the report on every Monday as follow :
SELECT T0.[CardCode], T0.[CardName], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[LineTotal] FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode WHERE T0.[DocDate] between GetDate()-8 and GetDate()-1
The weekly report received on every Monday through email is without column total for the "Line Total".
Can the Sum of column "Line Total" to be included in the query ?
Thus, the auto send report on every Monday by alert management will display the total.
Thanks in advance for all your kind assistance.
Regards,
Clara