Daily Report Problem and Code

[Kyaw]

[Detailed Sales Product :10, 12,10, 10, 10, 10, 10, 10, 10,13]
>TICKET NO|ITEM GROUP|ITEM|Topping|TAG PRICE|PORTION|PRICE|QUANTITY|TAX|TOTAL
{REPORT ORDER DETAILS:T.TicketNumber,O.ItemGroup,O.MenuItemName,O.OrderTagList,OTP.Topping,O.PortionName,O.Price,O.Quantity.Sum.desc,T.Tax.sum,O.TotalPrice}

This is the code for report

I also want to add this report at Round up and Down also to show report.

[JTRTech]

Don’t think you will be able to do this accurately.
Rounding is a type of ticket calculation/discount.
As a ticket level factor it is not directly resolveable to orders.

[Kyaw]

ok @JTRTech Thanks Brother
How About Upper Tax want to included at Total amount.

[QMcKay]

Try this:

[Detailed Sales Product :10, 12,10, 10, 10, 10, 10, 10, 10,13]
>TICKET NO|ITEM GROUP|ITEM|Topping|TAG PRICE|PORTION|PRICE|QUANTITY|TAX|TOTAL
{REPORT ORDER DETAILS:T.TicketNumber,O.ItemGroup,O.MenuItemName,O.OrderTagList,OTP.Topping,O.PortionName,O.Price,O.Quantity.Sum.desc,T.Tax.sum,=[T.Tax.sum+O.TotalPrice]}

[Kyaw]

@QMcKay

[Detailed Sales Product :10, 12,10, 10, 10, 10, 10, 10, 10,13]
>TICKET NO|ITEM GROUP|ITEM|Topping|TAG PRICE|PORTION|PRICE|QUANTITY|TAX|TOTAL
{REPORT ORDER DETAILS:T.TicketNumber,O.ItemGroup,O.MenuItemName,O.OrderTagList,OTP.Topping,O.PortionName,O.Price,O.Quantity.Sum.desc,T.Tax.sum,=[T.Tax.sum+O.TotalPrice]}

Brother

It Happen This one I think not working

[JTRTech]

Not working, thanks…
Maybe it would be a good idea to explain what’s wrong…
Talk is not going to be a product level aspect so guessing that’s the column that’s wrong.

[Kyaw]

Brother Right now at total amount is Product price and tag price
I want to add tax price into Total amount. So that will be total price of One Order Ticket.
I want to show report to Shop Owner To one item sale detail cost. Right Everything is on total amount except tax is not include it . i want to include tax is also.

[QMcKay]

Maybe try this:

[Detailed Sales Product :10, 12,10, 10, 10, 10, 10, 10, 10,13]
>TICKET NO|ITEM GROUP|ITEM|Topping|TAG PRICE|PORTION|PRICE|QUANTITY|TAX|TOTAL
{REPORT ORDER DETAILS:T.TicketNumber,O.ItemGroup,O.MenuItemName,O.OrderTagList,OTP.Topping,O.PortionName,O.Price,O.Quantity.Sum.desc,T.Tax.sum}|[=TN('{REPORT ORDER DETAILS:T.Tax.sum}')]+[=TN('{REPORT ORDER DETAILS:O.TotalPrice}')]

[Kyaw]

@QMcKay

[Detailed Sales Product :10, 12,10, 10, 10, 10, 10, 10, 10,13]
>TICKET NO|ITEM GROUP|ITEM|Topping|TAG PRICE|PORTION|PRICE|QUANTITY|TAX|TOTAL
{REPORT ORDER DETAILS:T.TicketNumber,O.ItemGroup,O.MenuItemName,O.OrderTagList,OTP.Topping,O.PortionName,O.Price,O.Quantity.Sum.desc,T.Tax.sum}|[=TN(‘{REPORT ORDER DETAILS:T.Tax.sum}’)]+[=TN(‘{REPORT ORDER DETAILS:O.TotalPrice}’)]

Thanks For your Support Brother But It Can’t

IT happen like this one