Reports

Review Products and Selling Value by Supplier

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.

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

demo.posnic.io Supplier Based Product captured 2026-09-11, frontend/modules/supplierReport.html product tab and detail drawer, frontend/static/script/js/modules/js/report_suppliers.js supplierproductreport and supplierproductdetails, api/src/controllers/items.controller.js supplierItemsReportTable and supplierProductDetails, api/src/repositories/item.repository.js supplierProductDetails

Supplier product summaryLive demo captured 2026-09-11. Select a supplier name to open its paginated product-history drawer.

Run the Product View

  1. Open Supplier Reports and choose Supplier Based Product.
  2. Apply the required date and branch filter.
  3. Read Supplier Name, Products and Total Amount.
  4. Select a supplier name to open product history.
  5. Review every product-history page before exporting or closing.

Understand the Values

ValueMeaningDo not assume
ProductsCount of item records associated with the supplier in the report scope.It is not received quantity or units sold.
Total AmountAggregated stored selling_price for those products.It is not supplier spend, inventory valuation or realized sales.
Product historyItem name, source date and selling price returned for the selected supplier.It is not a purchase invoice ledger.

Export Correctly

  • The summary export filename is supplier-product-reports.
  • The selected supplier detail export uses the supplier name plus -supplier-based-product-reports.
  • The detail export includes product name, updated date and selling price.
  • Verify duplicate or reassigned supplier links in the item catalog before relying on totals.

Troubleshooting

ProblemCheckAction
Product count is lowItem supplier assignment and branchCorrect the catalog association, then rerun.
Total differs from stock valueReport uses selling priceUse inventory/cost reporting for stock valuation.
Date is blankStored item created/updated dateCorrect source metadata; do not substitute today's date.
Supplier opens no productsCurrent filter and catalog associationRefresh and verify the supplier id on item records.

Related Manual Pages

Catalog Create Item Use the full Add Item form when the product must be searchable, scannable, stocked, reported and controlled correctly. Purchase Supplier Profile The supplier profile is the purchasing memory for a vendor: contact details, purchase totals, recent bills and document preview all sit beside the supplier list. 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 Supplier Sales and Profit 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. Reports Inventory Reports Inventory reports turn item and category data into operating signals: what sold, what is stocked, what expired and which categories drive sales.