The Below is my End of Day Stock Take Report - Consolidated across all cashiers and tracks all inventory items
[Grills Stock Take Report:2,2, 1, 1, 1, 1, 1, 1, 1, 1,1]
>>WP Ended On|Item|Op Stock|Sold|Received|Expected|Count|Variance|U-Cost|Var-Value
{REPORT CONSUMPTION DETAILS:C.EndDate,C.Name.asc,C.InStock,C.Consumption,C.Added,C.Prediction,C.PhysicalInventory;#0.000,[($7-$6)];#0.000,C.Cost;$0.00,[(($7-$6)$9)];$0.00:(PCW=Grills) }*
The Below is my Item Sales by Cashier Report - Which only tracks Products
[Item Sales By User:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.User.asc:(ODI=True):,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1):{0}:,}
$1
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1) and O.MenuItemName=“$2”}
{REPORT ORDER DETAILS:’ '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (OU=$1) and O.MenuItemName=“$2”:2}
Totals|{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum}
The objective is to have a sort of combined report of the above, whereby we have a Stock take Report by Cashier, which tracks inventory items as well.
This way, at the end of every shift (which corresponds to a change in cashier), each cashiers cashup report corresponds with their own stock take by inventory item.
This would make it extremely easy and quick to track any stock variances by cashier.
I look forward to your kind feedback
Regards