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
indent
minLevel1
maxLevel23
includeoutlinefalse
excludeTable of Contents
typelist
classprintablefalse

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.

Image Added

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. Enable Landed cost as price in the Advanced settings.

  6. Click Save to enable the new Customer.

Image Added

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.

Image Added
Step four: Sell the

Remove Expired Inventory

to this Customer

  1. Go to Order Entry and select Add Order.

  2. Select Expired Inventory as a Customer.

  3. Select Expired Inventory as a Carrier.Click on Add Items.

  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.

Image Added
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" )
We've encountered an issue exporting this macro. Please try exporting this page again later.