Item Sales Report error

Hi All,

How can I solved my Item sales report error below please

Think that might be issue with the backslash…
Sure someone not so long ago had similar parsing issue when using a backslash in product name, someone else might be able to confirm.

Hi JTRTech,

Could i have your advise how can i soldve please JTRTech

Why this particular item have no space after backslash. If other doesn’t have problem then just add space.

Hi sukasem,

Could i have your advise how can i add more space please

Press the space bar ? :wink:

Hi markjw,

I have try to delete that from Menu List and Product List, and it’s still error, do i have to clear some thing more?

This is my report template

[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,1]
@{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}

so, you press space bar after \
Save and maybe restart pos

show screenshot again after you delete/change.

Hi sukasem

Why would you need to put \ anyway?

Hi sukasem,

Because we have 2 language in menu, i have fixed by remove from SQL database

Thank you all for your assist

I know but \ is special for most programming language to parse data.

use / then, it’s not a special character

1 Like

Think you will struggle doing it in samba and might need to run SQL script to update as order name is stored in the orders table historically…

That will work fine on next update