Reports

Compare Sales and Profit by Product Supplier

Supplier Based Sale connects sold items back to their supplier association. It is a merchandising view for comparing downstream sales, not a supplier payment or purchase ledger.

Menu path
Reports -> Purchase -> Supplier -> Supplier Based Sale
Verified from
Posnic demo and current POS source reviewed on 2026-09-08
Technical source evidence

demo.posnic.io Supplier Based Sale captured 2026-09-11, frontend/modules/supplierReport.html sales tab, frontend/static/script/js/modules/js/report_suppliers.js suppliersalereportTable and supplier-sale-reports export, api/src/controllers/sales.controller.js supplierSalesReportTable, api/src/routes/sales.routes.js supplierSalesReportTable

Supplier sales and profitLive demo captured 2026-09-11. This tab attributes product sales to supplier associations for the selected scope.

Run the Sales View

  1. Open Supplier Reports and choose Supplier Based Sale.
  2. Apply the same date range and branches used for sales review.
  3. Review all supplier rows and pages.
  4. Compare Total Items Sold, Sales, Profit, Avg. Sale and Total Sales.
  5. Export only after confirming the report scope.

Read Each Metric

MetricMeaningControl
Total Items SoldSummed item quantity attributed to the supplier.Check returns and item supplier assignment.
SalesNumber of qualifying sales represented.Do not confuse transactions with units.
ProfitCalculated supplier-attributed sales profit.Missing or inaccurate purchase cost weakens this figure.
Avg. SaleAverage sale value in the supplier grouping.Compare only equal date and branch scopes.
Total SalesTotal attributed sales amount.It is revenue, not money owed to the supplier.

Export and Use

  • Export All To CSV creates supplier-sale-reports.
  • The CSV contains SupplierName, NoofItemSold, NoofSale, Profit, AvgSale and TotalAmount.
  • Use this view for assortment and vendor-performance analysis.
  • Use Purchase and Return Purchase reports for supplier statement reconciliation.
  • Treat profit as unavailable or provisional when source item cost is missing.

Troubleshooting

SymptomCheckAction
Supplier has no salesDate, branch, item supplier assignment and completed salesCorrect scope or catalog data and refresh.
Profit looks too highPurchase cost and return treatmentRepair cost evidence before making a vendor decision.
Items exceed salesQuantity versus transaction countThis can be valid when a sale contains multiple units.
Total is not supplier payableMetric is downstream sales revenueUse purchase/payment evidence for liabilities.

Related Manual Pages

Reports Sales Reports Sales Reports split normal sale lines, quick sale activity and summary totals so owners can audit bills without opening every receipt. Reports Supplier Product Summary Supplier Based Product groups catalog items by supplier. It answers how many products are associated with each vendor and their stored selling value, not how many units were purchased or sold. Reports Supplier Purchase Summary Supplier Details is a receiving summary despite its older Sale labels. Read each row as purchase activity grouped by supplier, then reconcile the totals with the Purchase register. Reports Purchase Register The Purchase report is the operational goods-in register. It answers which completed purchases entered a branch, which supplier supplied them, which item quantities were retained and what those lines cost. Dashboard Profit and Financials The Profit strip is a management estimate built from sale revenue, cost captured on each sale and Cash Book amounts. Missing costs, returns and Cash Book entry types must be checked before anyone treats it as accounting profit.