Need Help in Report

V5 Question
1

Hello, I am sharing screen shot of my sale and report where you can see that I am selling my item in 1.5 Qty but my report is showing 2 Qty but amount is showing perfect but I also need Item sale in Qty. So Please check my report code and give my solution.

This is my report code.

@{REPORT ORDER DETAILS:O.ItemGroup.asc,O.ExactTotal.Sum::{0}:,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
[$1 Sales:8, 4, 2]
{REPORT ORDER DETAILS:O.MenuItemName,O.PortionName,O.Quantity.Sum.asc:(MG=$1)}
>Total $1||{REPORT ORDER DETAILS:O.Quantity.Sum:(MG=$1)}

Thanks

2

First I wonder why you have 2 parameters but only using 1.

Can you show a screenshot of the result and explain better what you expect?

Also I changed this to v5 question. This is not a broken issue with SambaPOS it is a configuration question.

3

Try this. Should stop rounding your quantity

@{REPORT ORDER DETAILS:O.ItemGroup.asc,O.ExactTotal.Sum::{0}:,}
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
[$1 Sales:8, 4, 2]
{REPORT ORDER DETAILS:O.MenuItemName,O.PortionName,[O.Quantity.Sum.asc]:(MG=$1)}
>Total $1||{REPORT ORDER DETAILS:[O.Quantity.Sum]:(MG=$1)}
1 Like