Commission based On product sold

waiter gets commission based on quantity he/she sold not the total sale

i need product listed

@{REPORT ORDER DETAILS:O.User.asc:(ODI=True)}
[Item Sales by $1:3,2]
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.sum:(ODI=True)&&(OU=$1)}

image

You could have found something pretty similar just by searching forum.

samba1

on the right track but am look for this

This is why I was asking questions.
If your not clear, have to guess… Not mind reader.

COMMISION.pdf (202.8 KB)

@{REPORT ORDER DETAILS:O.User.asc:(ODI=True)}
[Item Sales by $1:3,2,2]
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.sum,[O.Quantity.sum]*10:(ODI=True)&&(OU=$1)}
Total||{REPORT ORDER DETAILS:[O.Quantity.sum]*10:(ODI=True)&&(OU=$1)}

image

Capture

show this when more than 1 user make a sale

Are, ok, missed the list separator.
Will need to check on pc.
Or if you look at default wp or item sales for the code.
After the odi and ou=$1 it needs something like :{0},}
Look at those reports where there is an @ line and you’ll see what I mean.

Thanks a lot i manege

a quick one. is it possible to increase inventory quantity {what i have in stock} when i sale menu item

Should be a new topic but I think it should be posible.
You will see in the update order action there is an increase inventory field which if set to true will do what you ask. So you would need to automate process for this.
If you look at different redund options on forum you will find examples from those who have setup a refund process which puts item back into stock.

Thanks for reply. great job i creat as a new topic

hi
i need assistance of this code i dont know where an wrong

Inventory Cost Report:1, 1, 1, 1, 1]

Item|Unit|Inv|Cost|Price|Total
{REPORT CONSUMPTION DETAILS:C.Name,C.Unit,C.Inventory, C.Cost,C.Price, ([C.Inventory][C.Cost][C.Price])}
Totals||{REPORT CONSUMPTION DETAILS:C.Inventory.sum, C.Cost.sum,C.Price.sum, [([C.Cost]*[C.Inventory]).sum]}

Whats this meant to be… its not valid as far as I can see. Guessing your missing * or /
Similar with your total line I would imagine. dont think you can tack .sum on the end of a calculation like that.

Already i have * or / between [C.Inventory] [C.Cost] [C.Price]

steal no showing

Make sure you highlight and click < / > button on forum post editor to show its code and prevent any html stripping etc.
If you already have you * then I would ask why the ( ) brackets? Where have you seen that?

{REPORT CONSUMPTION DETAILS:C.Name,C.Unit,C.Inventory, C.Cost,C.Price,[C.Inventory]*[C.Cost]*[C.Price]}

What is that calculating? Cant understand the use of cost multiplied by price

i want to add a column to show selling price on this