Hello i have a particular category called bottled beers where a few beers appear in the items sales report whilst some miss in the report yet they were sold and the tickets settled.The work period report captures the category total.what could be cousing this?
Reports use the category you created under products. It’s actually Group Code. Can you check that?
Group code is ok but if u check my image my category is bottled beers and when i check each product its set to beers and drinks(bottled) group code.initialy the group code was beers and drinks bottled and went to menu group and changed it to bottled beers but it did not change on group code.
@MathiasMaghanga, did you remove them from the list and add them again?
Yes i tried that but did not work.
Could it be becouse i wrote the products with special characters such as balozi 0,5l
Yes absolutely that could affect it. Try something else and see.
1 Like
Ok will do so and revert
@MathiasMaghanga they are likely still in the database. I would recommend you to not use , | characters in anything. Reporting engine uses , to split data into new columns and sometimes it can even skip a row.
If you have SQL Server Management studio, you can run this query
USE [MyDatabase] -- Replace MyDatabase with the name of your database, keep the brackets [McDonalds]
UPDATE dbo.Orders
SET MenuItemName = REPLACE(MenuItemName, ',', '.')
UPDATE dbo.Orders
SET MenuItemName = REPLACE(MenuItemName, '|', ' ')
UPDATE dbo.MenuItems
SET Name = REPLACE(Name, ',', '.')
After that re-run your report, it should show the missing items
3 Likes
Thanks you soled my issue.be blessed.