Day-by-day sale amounts broken down by item group, with employee filter, optional return detail, and a summary or detailed view. Use it to compare category mix across days for a salesperson or the whole team.
What it shows. One row per calendar day in the selected date range. Columns show TOTAL NET and one column per item group. By default each cell is the net amount (sale taxable amount minus return taxable amount). Use Show Detailed for sale, return, and net quantity and amount per group.
When to use it. Daily category performance — e.g. how Nutra vs Pharma (or any item groups) sold each day for a selected employee.
How amounts are calculated. Aggregates approved sale invoice item lines and credit note item lines by bill date and item group. Amounts use taxable amount. Items without an item group appear under Others. TOTAL NET is the sum of the item-group net amounts for that day.
Header (quick filters)
Advanced Filter (filter icon) — additional fields:
Tap clear after applying Advanced Filter to reset advanced filters.
One net amount cell per item group. TOTAL NET (bold) is the day total of those nets.
| **Column** | **Description** | |------------|-----------------| | DATE | Calendar day (DD/MM/YY). |
| TOTAL NET | Sum of item-group net amounts for the day (bold). |
| Item group columns | One column per item group — net taxable amount. Items with no group show under Others. |
Toggle Show Detailed for a two-row header. Per item group (and under TOTAL):
| **Column** | **Description** | |------------|-----------------| | Sale Qty | Quantity from sale invoices. | | Sale Amt | Taxable amount from sale invoices. | | Return Qty | Quantity from credit notes *(hidden when Hide Return is on)*. | | Return Amt | Taxable amount from credit notes *(hidden when Hide Return is on)*. | | Net Qty | Sale qty − return qty. | | Net Amt | Sale amt − return amt. |A footer TOTAL row (bold) sums all days.
How is this different from Day Wise Sale?
Day Wise Sale shows invoice-level day totals (count, discount, tax, balance). This report breaks each day into item group columns with optional return detail.
How is this different from Customer Item Group Wise Sale?
Customer Item Group Wise Sale uses customers as rows. This report uses days as rows.
Why does TOTAL NET not match the item groups I can see?
Scroll horizontally — there may be more item group columns. Amounts for items without a group appear under Others. TOTAL NET equals the sum of all item-group net columns for that day.
Are returns included?
Yes. Net amount is sale taxable minus return taxable. Use Show Detailed to see sale and return separately, or Hide Return to hide return columns in detailed view.
Which date is used?
Sale invoice and credit note bill date in the selected range. Only approved / pre-approved documents are included.
Why don't I see some employees?
User employee data filters for the Sale module may restrict which employees appear. See User Management → employee filters.