Tag Wise Item Sale Report

Hi In the Product Tag Editor We have taged some has "Food and some has bar

In our Item wise report can i get all the items with Food Tag Separately and Bar Tagged Separately.

I think its something along the line of


1 Like

FYI @johnmorgan if you go to program settings there is a product tag field and you can add product tag columns. These are really handy for so many things and allows you to set other tag columns.
I have 7-8 columns for wet/dry like you but also codes for my PMS integration, whether items are included in packages at the hotel. Also use tags and translate to states for a printing setup which uses tags rather than mapping as find that easier to manage.

1 Like

check the templet

[Group Sales by Amount:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)}
>Total|{REPORT ORDER DETAILS:O.Total.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.Total.Sum.desc:(ODI=True):{0}:,}
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.Total.Sum.desc:(ODI=True) and O.MenuItemName="$1"}
{REPORT ORDER DETAILS:'     '+[O.PortionName],O.Quantity.Sum.desc,O.Total.Sum.desc:(ODI=True) and O.MenuItemName="$1":2}

with this we get like this


Yer, what were you expecting?
That matches what you put
You need to include it in the main expression of you want it to be part of report.
You put on it’s own in front so that’s what’s rendered, list of tags for each order.

Please use kb.sambapos.com and go to reports section to learn how to use custom reports.

oh ok, but not very good in the technical, if some one can help pls let me know how this can be done.

The columns are in the report,
What you have done is said;

{Report tags}
{Report orders}

That’s two reports.

You need to include tags in the report you want them part of.
{Report orders:name,tag,total etc…

There is predictive field popup on the main expressions of which report orders is one of them, look through the suggestions in the popup.

thank you, got littel

with following templet

[Group Sales by Amount:1,2, 1, 1]

{REPORT ORDER DETAILS:M.Tag,O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)}
> |Total||{REPORT ORDER DETAILS:O.Total.Sum:(ODI=True)}

[Group Sales by Quantity:1,2, 1, 1]
{REPORT ORDER DETAILS:M.Tag,O.ItemGroup,O.Quantity.Percent.desc,O.Quantity.Sum:(ODI=True)}
>|Total||{REPORT ORDER DETAILS:O.Quantity.Sum:(ODI=True)}

[Sales:1, 2, 1,1]
@{REPORT ORDER DETAILS:O.MenuItemName,O.Total.Sum.desc:(ODI=True):{0}:,}
>{REPORT ORDER DETAILS:M.Tag,O.MenuItemName,O.Quantity.Sum.desc,O.Total.Sum.desc:(ODI=True) and O.MenuItemName="$1"}
{REPORT ORDER DETAILS:'     '+[O.PortionName],O.Quantity.Sum.desc,O.Total.Sum.desc:(ODI=True) and O.MenuItemName="$1":2}

We need Seprate list of food only and Bar Only can you help to get that.

Please start formatting your reports. Past it in then put ``` before and after it to format it in the forum so it’s readable.

you mean the templet you are saying

I mean when you paste a report in the forum. You see how it’s unreadable? Put the ``` before it. Paste it then put that after it at end. I will edit your post and do it for you this time.

Ok, Thank you we will do it next time, :slight_smile:

any one who have solution to get the Report of Food Tag Separately and Bar Tag Separately,
thank you

You need to either manual split table and add a report constraint in the section with the odi= bit
Ie :(ODI=True) && M.Tag=Bar: , this may not be 100% as freehanding it.
Or use @ declaration to list tags and use similar to above with =$1 if it needs to be dynamic.
I use a similar split method with tags however my tags are transferred to order states on order adding due to other parts of my system. Think my reports use the state but will check later.
I have a total food/drink solution my receipts and wp report but again think I used my states rather than direct back to product tag.

Hey , thank you very much, this look very technical… i am not that technical, will ask some one who can understand your technical word see if i can sort out…
Thank you very much…:slight_smile:

Here is how I would do it on mine.
My wet/dry is defined by a named tag rather than the one you used.

(MT.NewBook GLA=2101)

So gussing yours might work with M.Tag=

So try

:(ODI=True) && (M.Tag=Bar):

Hey thank you for kind reply.

check with

but with

there is no report generated

Because your not listening to what im saying.

You want to report bar and drink seperatly. So you have to add a constraint to the report.
(ODI=True) is a constraint to only report items which are set to decrease inventory (so ignoring coid items etc - depending on your config)
So you need to add you tag to the constraint do the report only reports items with that tag…

This is reporting M.Tag for all orders, so gives a list of just the tag value for each order reported.

This is invalid as you put a constraint in place of where the reported fields should be.
‘M.Tag=Bar’ is not a valid column/field to report. Even if it was valid and expression validated all it might have given you is true, true, false, false etc in place of where you were reporting tags, as to whether that order details line matched the expression, but its invalid anyway so forget it. M.Tag is a column

Reports are formatted in sections seperated by colons ( : )

So take this from your earlier report;

{REPORT ORDER DETAILS: = the report type, what is to be reported

M.Tag,O.ItemGroup,O.Total.Percent.desc,O.Total.Sum = your report fields, what data to be reported

:(ODI=True) = your constraints/filters

So you need to do something like this;

{REPORT ORDER DETAILS:O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)&&(M.Tag=Bar)}

Note that I dont use the plain tag column and specify all my product tags with own columns as shown in my screenshots. The above works with my (MT.NewBook GLA=2101) which is equivilent of your Bar in default tag column.

If you still dont understand then you need to go back to basics and read up on reports as dont know how to explain it simpler than that.

Yes i tried like same what you have send, it is not working.
{REPORT ORDER DETAILS:O.ItemGroup,O.Total.Percent.desc,O.Total.Sum:(ODI=True)&&(M.Tag=Bar)}