Hello trying to make my stock reports easier to work out.
I have it setup up to show any gifts (wastage) and all drinks sales.
[Z Reading End Of Day:3,3]
Loyalty Discounts | [=TN(‘{REPORT CALCULATION TOTAL:(CT=Loyalty Discount)}’)]
>FOOD | [=F(TN(‘{REPORT CALCULATION TOTAL:(CT=Loyalty Discount)}’) + TN(‘{REPORT ORDER DETAILS:O.ExactTotal.Sum:MenuItem.Tag = "FOODS"}’))]
>DRINKS | [=TN(‘{REPORT ORDER DETAILS:O.ExactTotal.Sum:MenuItem.Tag = "DRINKS"}’)]
>SUNDRIES | [=TN(‘{REPORT ORDER DETAILS:O.ExactTotal.Sum:MenuItem.Tag = "SUNDRIES"}’)]
>>GRAND TOTAL | [=F(TN(‘{REPORT CALCULATION TOTAL:(CT=Loyalty Discount)}’) + TN(‘{REPORT ORDER DETAILS:O.ExactTotal.Sum}’))]
[Wastage Details: 3,2,4,2.5,1.5,2]
>Reason | Date | Product | Portion | QTY | Price
{REPORT ORDER DETAILS:OSV.GStatus,OSD.GStatus,O.MenuItemName,O.PortionName,O.Quantity,O.TotalPrice:(OS.GStatus=Gift)}
Total Wastage Amount £{REPORT ORDER DETAILS:O.TotalPrice.Sum:(OS.GStatus=Gift)}
@Draught,Wines,Spirits,Bottles,Soft Drinks
@{REPORT ORDER DETAILS:O.MenuItemId,O.ExactTotal.Sum.desc:(ODI=True) and (MG=$1):{0}:,}
[$1 Sales:7, 2, 3]
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemId=$2 and (MG=$1)}
{REPORT ORDER DETAILS:’ '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemId=$2 and (MG=$1)}
>>Total $1|{REPORT ORDER DETAILS:O.Quantity.Sum,O.ExactTotal.Sum:(ODI=True) and (MG=$1)}
However the gifts (wastage) show as individual totals and don’t accumulate,
This is great for my own records but does not help for stock taking purposes.
What I would like to show is the total wastage for each menu item accumulated over a period.
So where Pravha is shown as 2 separate instances it should be showing a total of 3 on one line.
Product | Portion | QTY | Total Price
Pravha | Normal | 3 | 11.40
I have been trying different ways of showing this report but cant find the correct syntax as yet, has anyone else already implemented something similar (couldn’t find anything on forum search).