Starline Food Products Ltd.
Sales Data Verification — Order Date basis
Filter is applied to sale_do_master.do_date only. No created / posting / updated dates are used.
This tab is the reference source of truth. Filter by sale_do_master.do_date, restrict to status = 'COMPLETED', split gift vs non-gift by gift_id. Do not change these formulas — use the Testing Panel for experiments.
Total Sales Amount (COMPLETED)
SUM(sale_do_details.pkt_unit × unit_price) where sale_do_master.status = 'COMPLETED', filtered by sale_do_master.do_date
Total Number of Orders (COMPLETED)
COUNT(DISTINCT sale_do_master.do_no) where status = 'COMPLETED', filtered by sale_do_master.do_date
Verified Data Panel
Locked reference (Total Orders + Total Sales Amount) plus 3 new columns being tested. All rows use the same filter — do_date 2026-07-01 → 2026-07-28, status = 'COMPLETED'.
| Metric | Value | Status | Source |
|---|---|---|---|
| Total Orders | Locked | COUNT(DISTINCT sale_do_master.do_no) — status = 'COMPLETED', filtered by do_date | |
| Total Sales Amount | Locked | SUM(pkt_unit × unit_price) on non-gift lines — status = 'COMPLETED', filtered by do_date | |
| CTN Qty | Locked | SUM(sale_do_details.pkt_unit) WHERE gift_id = 0 — same COMPLETED / do_date filter | |
| Gift CTN | Locked | SUM(total_unit / pkt_size) WHERE gift_id > 0 — same COMPLETED / do_date filter | |
| Total CTN | Locked | CTN Qty + Gift CTN | |
| Gift Amount | Locked | SUM((total_unit / pkt_size) × unit_price_gift_item) WHERE gift_id > 0 — same COMPLETED / do_date filter |
Verified Breakdowns
Locked breakdown formulas for do_date 2026-07-01 → 2026-07-28. Filter: status = 'COMPLETED', non-gift lines.
Item Group Wise Sales
sale_do_details.item_id2 → item_info → item_sub_group → item_group
| Item Group | Orders | Sales Amount |
|---|---|---|
Division Wise Sales
dealer_info.division → sales_division.division_name
| Division | Orders | Sales Amount |
|---|---|---|
HOS Wise Sales
sales_division.dsm → dsm.hos → hos.name
| HOS | Orders | Sales Amount |
|---|---|---|
Customer Type Wise Sales
dealer_info.cust_category_name → customer_category (Depot / Independent Distributor / …)
| Customer Type | Orders | Sales Amount |
|---|---|---|
Item Section Wise Sales
sale_do_details.item_id2 → item_info.item_section (LEFT JOIN item_category)
| Item Section | Orders | Sales Amount |
|---|---|---|
Top 10 SKU Sales
sale_do_details → item_info (top 10 by SUM(pkt_unit × unit_price), non-gift, COMPLETED)
| SKU | Orders | Sales Amount |
|---|---|---|
Bottom 10 SKU Sales
sale_do_details → item_info (bottom 10 by SUM(pkt_unit × unit_price) > 0, non-gift, COMPLETED)
| SKU | Orders | Sales Amount |
|---|---|---|
Chalan Details — Net TP Amount Verified
sale_do_chalan · chalan_date · ERP formulaDelivery Amount TP Verified
sale_do_chalan · chalan_date · same joins as Net TPLocked logic — Delivery Amount TP = SUM(sale_do_chalan.total_amt − IFNULL(discount, 0)), joined to dealer_info, sale_do_details (order_no = ds.id AND ds.ref_no = 0) and item_info, with dealer_code ≠ 1810, filtered by chalan_date. Reference check: 2026-06-01 → 2026-06-30 = 294,276,320.58.
Sales Targets — Month wise Verified
Source: sales_target_pending (period overlaps the selected month). Locked mode ERP SO Sales Target Report matches the ERP report 100%.
Inflow Target
Mode: ERP SO Sales Target Report (matches ERP 100%)
Target TP
SUM(target_amount_tp)
Target IP
SUM(target_amount_ip)
Target DP
SUM(target_amount_dp)
sales_target_pending — periods overlapping
from_date ≤ month-end AND to_date ≥ month-start — grouped by period + target_status
| Period | Status | Rows | Inflow | TP | IP | DP |
|---|---|---|---|---|---|---|
Inflow Target — dealer wise ()
SUM(sales_target_pending.target_inflow) GROUP BY dealer_code (top 500)
| Dealer Code | Inflow Target |
|---|---|