SOLD ITEMS Reports

This is something simple… but I use it a lot

####Template
[Items Vendidos:3, 1]
>Item|Cant
@@ItemsVendidos

[Items Bonificados:3, 1]
>Item|Cant
@@ItemsBonificados

[Items Cancelados:3, 1]
>Item|Cant
@@ItemsCancelados

####@@ItemsVendidos (SOLD ITEMS)
SELECT [MenuItemName],CONVERT(INT,SUM([Quantity])) as Cantidad

FROM [Orders]

WHERE [CreatedDateTime] > '{Start}' AND [CreatedDateTime] < '{End}' AND DecreaseInventory = 1 AND CalculatePrice <> 0

GROUP BY [MenuItemName]

ORDER BY Cantidad DESC

####@@ItemsBonificados (GIFTED ITEMS)
SELECT [MenuItemName],CONVERT(INT,SUM([Quantity])) as Cantidad

FROM [Orders]

WHERE [CreatedDateTime] > '{Start}' AND [CreatedDateTime] < '{End}' AND CalculatePrice = 0 AND DecreaseInventory <> 0

GROUP BY [MenuItemName]

ORDER BY Cantidad DESC

####@@ItemsCancelados (CANCELED ITEMS)
SELECT [MenuItemName],CONVERT(INT,SUM([Quantity])) as Cantidad

FROM [Orders]

WHERE [CreatedDateTime] > '{Start}' AND [CreatedDateTime] < '{End}' AND DecreaseInventory = 0

GROUP BY [MenuItemName]

ORDER BY Cantidad DESC
1 Like