Custome Report include Void Product

Version 4
1

I use this script to report sales products, but it include void product, how to fix it?

[!Orders:1,2,1,1]
Item Group|Item|[N]Quantity|[C]Total
{REPORT ORDER DETAILS:O.ItemGroup,O.MenuItemName,O.Quantity,O.TotalPrice}

2

I not want to include void products…

3

You’ll want to add an expression to constrain the results.
Pretty sure you can’t do ISNOT so would need an alternative.

4

Thanks your reply, now i have another problem, i have two product group, food and drink, i want to report only sale food item, how to do? i use this script…

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

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

how to change? thanks…

5

Sure you would need to JOIN the menuitems table and add a and that menu item group Id
That’s going from memory as not at PC to check database.
If you don’t work it out or get another response before I get back to desk in a bit ill give you more info.

6

PS calculate price line would also ignore gift item.

7

4 posts were split to a new topic: Custom report for sales