Receivables and payables

Inactive Sales Items

Items that have not appeared on any Sales Invoice or order for a chosen number of days.

In detail

Inactive Sales Items lists items that have not appeared on any Sales Order or Sales Invoice for a chosen number of days, 30, 60 or 90, optionally within one territory or item group. Stock that nobody buys ties up cash and shelf space, so this is the list to review before a clearance sale, before reordering and before stock taking. It compares the Item master against recent sales documents, so an item sold only through a Delivery Note without an invoice will wrongly appear here. Of the 100 demo items, those never sold since Shrawan 2083 are listed. Disable items you will never sell again so they stop cluttering searches.

Formula

Row appears when the item has no submitted Sales Invoice (or Sales Order) line in the last N days chosen

How to record it in BRAccount

  1. 01Go to Financial Reports > Inactive Sales Items.
  2. 02Set Based On to Sales Invoice and Days to 30, 60 or 90; optionally Territory or Item Group.
  3. 03Read Item, Item Group and Last Order Date for each row.
  4. 04Open Stock > Stock Balance for the listed items to see how much cash is sitting in them.
  5. 05Plan a discount or return to supplier, and lower the reorder level on the Item.
  6. 06Disable items that are discontinued so they no longer appear.

When to use it

Open before a stock clearance to find products nobody is buying.

Example from the demo books

Of the 100 demo items, those never sold since Shrawan 2083 are listed here.