Report Format Help

#1

What do I need to change in this item sales report to only display quantities of 1 or more. Currently if the transaction is voided the report still show an item was “sold” but with zero quantity as shown below, how can I remove those Zero quantity items?

[Item Sales:4, 1, 1]
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.desc,O.ExactTotal.desc:(ODI=True)}

image

#2

This won’t show qty greater than 1 but it will show sold item with the status of “Submitted”.

[Item Sales:4, 1, 1]
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.desc,O.ExactTotal.desc:(ODI=True) && (OS.Status=Submitted)}

#3

It shouldn’t show those. How are you voiding?

#4

Its not really a void, its from the void transaction setup that you did ages ago

#5

Ah I think that’s breaking it lol.

#6

This doesnt work, it doesnt display any product sales now

#7

Do you know any way around it? I just need a list of the products and quantities sold

#8

Think i may have a way round im working on it now

#9

Fixed it, thanks for the help @Bob_be, your original expression with os.status=submitted didnt work for me because ive heavily modified my system and dont use submitted

I just added a new rule that when im using my void system orders states get updated to Voided and when a sale is processed order states get updated to Paid

So now i used OS.Status=Paid which works perfect, then i also added a void item report using the same expression but with OS.Status=Voided

Working perfect thanks for the help :slight_smile:

2 Likes
#10

Glad you got it working. I’m still learning the software. I was assuming you the default states.

2 Likes
#11

You set me on the right track I just needed a couple of amendments in my system to make it work :grinning:

2 Likes
#12

Anyone know why the same item is sometimes grouped and sometimes not? See below the highlighted drink is listed twice, once with qty x2 and once with qty x1, it should only be listed once with qty x3

[Item Sales:70, 10, 20]
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.desc,O.ExactTotal.desc:(ODI=True) && (OS.Status=Paid)}
>>
#13

I think what’s happening is it’s grouping the items by how the orders are placed. I’m guessing you had 1 order with a qty of 2, an another order with a qty of 1. If you had 2 more separate orders of 1 the report would change the qty of 1 to 3 (also adjust the price also, unless you change the price of one of them, then there would be new line).

Putting a .sum before the .desc of Quantity & ExactTotal should give you the results your looking for.
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.sum.desc,O.ExactTotal.sum.desc:(ODI=True) && (OS.Status=Paid)}

Out of curiosity, why are you using large numbers in the column format?

1 Like
#14

Because those numbers are percents for column width.

2 Likes
#15

Aah, that’s easier to understand when formatting column width’s than using 1,2, 3 etc.

1 Like