Can Sale Reports show menu name?

[madiha]

As a developer product name in number wont matter but if a non technical person would like to view a sale report he wont know what the product is representing.

so is there any way to put menu name in place of product group code as shown below to make it user friendly

[JohnS]

Why are you using numbers for product groups ?

Item sales report also shows product names.

[morshed1]

@JohnS, I belive numbers for product group was used for grouping menu categories. As per below

Grouping menu category items in Printer/receipt Templates

Since you need a specific order and alphabetical will not work, use Product Tag in the products to define the sort order. Use numbers and start at 10 for the first group, 20 for the second, etc. that way if you need to add more groups to the sort order you can use 5,15, 25 etc In your printer template sort/group by PRODUCT TAG.

[JohnS]

Product Tag is different to Product Group/Group Code.

[madiha]

@JohnS what i understood by discussion and searching is that at Print Job we can filter by product group

and during my previous discussion on

How to create 2 separate screen for Orders: Drink & Food

normally in restaurant drinks come first and food is served later…so i want to know how can i display the drinks separately in drink corner on drink screen and food order in kitchen on kitchen screen is it possible? how? thnks in advance

but if misunderstood is there a way to correct it

please help

[madiha]

any suggestions @morshed1 or @JohnS

[morshed1]

i’m not sure if there is a solution if numbers are used for product groups (separating food and drinks). this is how i have setup in my configuration to sort the orders for print template.

[JohnS]

The reason why you have used numbers is so you can sort the kitchen tickets by course.
You can sort by various means in printer templates.
Setting numbers for product groups will show these numbers in all reports and this cannot be changed.
You are better using product tags instead which can be sorted, and the reports will actually show the correct group names.

[madiha]

ok thanks but then when hall we use numbers to sort kitchen tickets by course…at that we will see in reports the numbers again right?

[JohnS]

Not if your using Product Tags to enter the numbers to sort by.

Then in your Printer Templates use [ORDERS GROUP|PRODUCT TAG] to sort.

[madiha]

ok thanks for clearing my concept

[madiha]

@JohnS is there a way to edit the product name 90 to beverages…if not in samba can do in sql or not?

just have to rename or edit?

[JohnS]

Can be done in either. Make a backup first.

[madiha]

cant do backup it gives error!!

[JohnS]

This has been seen before.
Are you logged in as an administrator on your computer?
Are you running the latest SambaPOS version?
Are you running Compact SQL?

[madiha]

ya i have seen the similar error on the forum and it ask to give access rights i have try that also but no use.
yes i am login as admin
using 4.1.37 version
and DB —SQ

[JohnS]

Are you logged into Windows as madiha ?

[madiha]

YES LOGIN AS ADMIN I CHECKED AGAIN MY DATABASE BACKUP PROP DONT HV SQL OR CREATOR OWNER RIGHTS
IF I NEED TO GV THEM THE ACCESS RIGHT HOW DO I ADD THEIR OBJECT NAME

[madiha]

@JohnS can please update how to change the product name from 90 to beverages

[JohnS]

Just edit each item. It will be easier.
And it’s not the product name, it’s the product group you need to change.