I noticed today that some items are not showing up on some Order Details reports I was running. I was finally able to narrow it down to each item having a comma in the menu name. I put the commas in as descriptors, and not portions because I don’t have any plans for different portions.
On the 3rd report below, it only lists 1 of the 2 pickles sold. (The counts are correct for the first 2 reports.)
Here is my report:
[Group Sales by Amount:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent.desc,O.ExactTotal.Sum:(ODI=True)}
Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True)}
[Group Sales by Quantity:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.Percent.desc,O.Quantity.Sum:(ODI=True)}
Total||{REPORT ORDER DETAILS:O.Quantity.Sum:(ODI=True)}
[Sales:5, 2, 2]
Item Name|[N]Qty|[C]Total
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName=“$1”}
{REPORT ORDER DETAILS:’ '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName=“$1”:2}
I changed my products lists and menu names to not have any commas in them. It’s now working correctly for sales going forward, but not previous sales. Is there any way to change previous sales in the database?
On a side note, the menu automatically put a linebreak in the menu screen. Not an issue, just thought it was interesting that it did it on it’s own.
Bob