Shopping Cart
Your Cart is Empty
There was an error with PayPalClick here to try again
CelebrateThank you for your business!You should be receiving an order confirmation from Paypal shortly.Exit Shopping Cart

Reporting Solutions Pty Ltd

Accounting ERP Software Flexible to fit your organisation - JIWA Financials Version 7

Phone : 03 9566 7249



Where oh where has all our inventory gone?

Posted on June 21, 2016 at 11:55 PM

Do you have salespeople who take sample products out of your warehouse without recording that they have taken them to show a customer? They probably think that they are doing the right thing – it’s all about getting sales isn’t it. Without sales nothing happens. Fair enough, but your computer system doesn’t know that the item has been removed, the stock on hand and stock available isn’t adjusted for the stock in the salesman’s car.

The result is: The item is not recorded at the proper time because the system thinks there is more inventory in the warehouse then there actually is.

A customer may be promised the item because the computer shows that you have it in stock. The customer drives 40km to your warehouse to pick it up, then you discover that it has gone AWAL.

Then there will be discussion around – it’s not me, it’s the ERP. This excuse works because the ERP isn’t able to defend itself, it can’t talk, but the real problem is the sales people, who are in a hurry to close deals or your techies who borrow parts.

This is what you need to do to keep your stock accurate and to track the stock in the possession of each sales person.

Create a customer account for each sales person

Record each sample taken by a sale person or a technician on a new Sales Order. As a result of entering the order, the available stock is reduced. Don’t process this order, just yet.

When the item is returned to stock, reduce the line item quantity to “0” on the sales order, make a note or comment on what occurred then process the order to close it out.

On a regular basis print or email the Open Sales Order List for each sales person and inquire as to the whereabouts of the loan stock, and when it will be brought back to the warehouse.

You need to establish a rule, a very simple rule. NOTHING LEAVES THE WAREHOUSE WITHOUT PROPER PAPER WORK! Violators of this policy face immediate termination, or they may have to undertake some arduous task.

In a similar vein, you need to stop your counter people “swapping out” one item for another with out paper work or a transaction taking place.

Go through all your procedures and see that they meet the test described in detail above. Most distribution companies have established policies & procedures for processing the following types of transactions. Review yours.

  • Normal Stock Receipts
  • Unexpected Stock Receipts
  • Requisitions for internally consumed products
  • Sales
    • Order to be delivered
    • Orders to be picked up
    • Cash Sales
    • Direct Drop Shipments
    • Order for Non Stock Items
  • Transfers to other warehouses
  • Work Orders for Assemblies
  • Bin transfers
  • Returns of Stock items
  • Returns of non-Stock items
  • Returns of damaged items
  • Returns to your supplier
  • Adjustments to Stock on Hand Levels
  • Scrapping & writing off stock

 There's probably other transactions that you do that aren't on this list. Inventory is valuable, keeping it properly is worth it.

Categories: None