Item Sales Report

Hi,

i do small modification to include the product portion in the report to add more value to it. Hopfully it benifit some one.

[Group Sales by Amount:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent.desc,O.ExactTotal.Sum:(ODI=True)}
>Total|{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True)}

[Group Sales by Quantity:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.Percent.desc,O.Quantity.Sum:(ODI=True)}
>Total||{REPORT ORDER DETAILS:O.Quantity.Sum:(ODI=True)}

[Items Sales:2, 1, 1]
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True)}


[Detailed Sales Product :2, 2, 2, 2, 2]
>ITEM GROUP|ITEM|PORTION|QUANTITY|TOTAL
{REPORT ORDER DETAILS:O.ItemGroup,O.MenuItemName,O.PortionName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True)}
2 Likes

@nkahat1 Looks great thanks for sharing