Commission for employees based on order tags

V5 Question
10

Hi @emre

Sorry, another question…
Can you please allow O.ItemTag as a condition, so we don’t have to duplicate the item tag as a custom tag

My staff get different commission rates depending on if they sell diving (services) or equipment (products).

I currently have items set up using the “Tag” to differentiate between diving and equipment.

The group code is then used to sub-divide the large equipment menu so it is easier to navigate…

image.png1179×272 17.8 KB

I have custom Entity fields called DivingCommission and EquipmentCommission which hold the different rates for each different member of staff.

In my custom report for commissions I would like to be able to first run through all Diving items and then all Equipment items, but I cannot use AND (O.ItemTag=$2) as a condition, for example in the following simplified report:

[Tag issue:.5,1,1,1,1,2,.5,.5]
@{REPORT ORDER DETAILS:OT.Commission.asc::,}
@Diving,Equipment
>>Ticket#|Total|Customer|Staff|Item type|Item|Item price|Commission Rate
> $1
{REPORT ORDER DETAILS:
	T.TicketNumber,T.TotalAmount,EN.Customers,OT.Commission,O.ItemTag,O.MenuItemName,O.Price	
	:(OT.Commission=$1) AND (O.ItemTag=$2)
	:{0}|{1}|{2}|{3}|{4}|{5}|{6}|{REPORT ENTITY DETAILS:EC.$2Commission:(ET=Employees) AND (EN=$1)}
}

The only options that seem to be available are:

  • MG (Menu Group) - The problem is that I have many different Menu groups
  • MT (Custom product tag) - This does work, but it seems silly to add a new custom tag to all products which is the same as the product tag.

To prove the concept of the report, I created a new custom product tag called CommissionType and manually assigned it the same value as the actual item tag…

Using these tags I was able to make this report work correctly…

[Tag issue:.5,1,1,1,1,2,.8,.8]
@{REPORT ORDER DETAILS:OT.Commission.asc::,}
@Diving,Equipment
>>Ticket#|Total|Customer|Staff|Item tag|Item|Price|Comm Rate
> $1
{REPORT ORDER DETAILS:
	T.TicketNumber,
	T.TotalAmount,
	EN.Customers,
	OT.Commission,
	O.ItemTag,
	O.MenuItemName,
	O.Price	
	:(OT.Commission=$1) AND (MT.CommissionType=$2)
	:{0}|{1}|{2}|{3}|{4}|{5}|{6}|{REPORT ENTITY DETAILS:EC.$2Commission:(ET=Employees) AND (EN=$1)}
}

Output (as you can see the commission rate is different per item type)…

image.png722×434 22.2 KB

The question…

Can you please allow O.ItemTag as a condition, so we don’t have to duplicate the item tag as a custom tag