Items are missing in Item Sales Report

V5 Question
1

Hi,

In default item sales report some items are missing.

@{REPORT ORDER DETAILS:O.ItemGroup.asc,O.ExactTotal.Sum::{0}:,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
[$1 Sales:8, 4, 2]
{REPORT ORDER DETAILS:O.MenuItemName,O.PortionName,O.Quantity.Sum.asc:(ODI=True) and (MG=$1)}

Total $1||{REPORT ORDER DETAILS:O.Quantity.Sum:(ODI=True) and (MG=$1)}

This report showing all items, none is missing.

But, I need to seperate items by Ticket Types.

2

I have missing items once when I use a bad character in production t name or field, ir I had used comma and one of my report @ was a comma separated list for the comma in the product name made the @list incorrect

3

Thank you!!! This solutions is working for new orders. But yesterday’s orders are missing, is there any way to bring them back?

4

If it is related to bad use of comma change the seperator in your @list expressions to say ~ or some other less common charator.
If that is the case the products are there but the report is broken so fixing report will show them

5

Sorry, I couldn’t get what you mean. I need to change @ chars to ~ in report?

6

At the end of the @ lines you see a comma… that is the list separator… change comma to a different character like tilde ~

7

So…

I changed

@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}

to

@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:~}

Now it shows nothing :frowning:

8

Trying to remember what emre sugested when I had the issue, maybe it was pipe ( | )

9

@emre need your help :slight_smile:

10

Emre does not provide support.

Try other separators. Try semi-colon ; and try pipe |

1 Like
11

Thank you all dears!!! | solves problem.

1 Like
12

Hi All, just an idea, Is it possible to add the ability to show ALL items in this report even if they have no Sales?
Could be useful for people with large menus and lots of options when considering menu changes.

or maybe a separate report listing zero sold items to help make clean up of pos systems easier over time?