Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
topofpage
topofpage

Excerpt

In this article, you will learn how to manage unsold inventory by creating a dedicated payment method, carrier, and customer for expired items, also known as dumping inventory.

Info

Use this method of removing expired (dump) or missing inventory (shrink) to remove unsold inventory from your account and keep track of unsold products in Komet Analytics.

Tip

Common industry terms for this process and inventory:

  • Dump. Inventory that is to be intentionally discarded.

  • Shrink. Missing Inventory.

  • Expired Inventory. Product that has passed its maximum aging and is to be discarded.

You can use any of these or any other term for naming the things you’ll create during the setup process described in this article.

Table of Contents

Table of Contents
minLevel1
maxLevel3
outlinefalse
excludeTable of Contents
typelist
printablefalse

Setup

To start removing and acocunting for expired or missing inventory, you need to do the following steps:

Step one: Create a new payment method

  1. Go to Setup and select Settings.

  2. Click on Payment Methods located in the Account Receivables group.

  3. Click on Add a new payment method.

  4. Name it Expired Inventory and click Save.

Step two: Create a new Customer

  1. Go to Setup and select Customers.

  2. Click on Add Customer.

  3. Name it Dump Account.

  4. Select Expired Inventory as a payment method.

  5. Click Save to enable the new Customer.

Step three: Create a Carrier

  1. Go to Setup and select Carriers.

  2. Click on Add Carrier.

  3. Name it Expired Inventory.

  4. Add EXP as the Carrier Code.

  5. Click Save.

Remove Expired Inventory

  1. Go to Order Entry and select Add Order.

  2. Select Expired Inventory as a Customer.

  3. Select Expired Inventory as a Carrier.

  4. Add the products you are removing from the Inventory.

  5. Sell them at a price of $0.00.

  6. Click on Confirm to submit the Order.

  7. Scan the boxes and remove them from your warehouse.

Info

Following this process will help you with the following:

  1. Maintain correct inventory data.

  2. Allow the loss from Dump/Shrink to be tracked by viewing the Dump Account in the Sales Detail Report. The Total Landed Cost column is the cost of the products dumped or lost to shrink. (in the Reports/Customers/Sales Details).

  3. Automatically provides accurate net margins (GPM) at the product, line, and vendor levels.

  4. Companies using Komet Analytics can also see these GPM values before and after dump.

Back to top


Filter by label (Content by label)
showLabelsfalse
max5
titleRelated Articles
cqllabel in ( "Inventory" , "order-entry" )