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…
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)…
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