Can Sale Reports show menu name?

Version 4 V4 Question
5

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

791ed76708bc8e7f.png847×373 68.7 KB

and during my previous discussion on

but if misunderstood is there a way to correct it

please help

6

any suggestions @morshed1 or @JohnS

7

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.

8

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.

9

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?

10

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

7313128f217ee5e9.png1024×768 51 KB

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

1 Like
11

ok thanks for clearing my concept

12

@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?

13

Can be done in either. Make a backup first.

14

cant do backup it gives error!!

2c4ca6caf5c2eefd.png1366×768 108 KB

15

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?

16

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

17

Are you logged into Windows as madiha ?

18

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

20

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

21

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

22

u mean i will have to put the new group code under each product

23

Yes. Product Name and Product Group Codes are used on the Work Period & Item Sales reports.

24

@JohnS so cant i just write a sql query to replace 90 with beverages it would same time

25

Use at your own risk…

UPDATE [SambaPOS4].[dbo].[MenuItems] set
[GroupCode] = '90 Beverages'
WHERE [GroupCode] = '90'

SELECT [Id]
      ,[GroupCode]
      ,[Barcode]
      ,[Tag]
      ,[Name]
      ,[CustomTags]
  FROM [SambaPOS4].[dbo].[MenuItems]
  order by [GroupCode], [Name]
1 Like