Skip to main content

Consignment Inventory Management

Overview of setting up and managing a customer consignment branch within The Business Edge.

J
Written by Jeff Laub
Updated over a year ago

If you have consignment inventory at your customers location, this can be handled in The

Business Edge using the Branch and Transfer Systems. Tracking inventory with spreadsheets or warehouse locations is prone to error and lost inventory. Using Transfer documents allows you to move product from your primary branch to the customer consignment branch and to record all relevant information (date, product code, quantity, lot number, etc.) for the material being moved.

This process starts with setting up a consignment branch within The Business Edge for the

customer. It is required that you track locations in order to use the Branch feature. We offer consignment branches at a discounted price since they are not fully functional branches. The Business Edge has a flag that can be set for the branch that indicates that it is consignment so the stock will not be considered as available to sell.

After setting up the Branch you create an initial transfer to move the products out of your primary branch and into the customer consignment branch. Once the inventory has been moved to the consignment branch you can run reports showing what products are there. If you are lot tracking you can also get detailed reports by Lot.

Products in the consignment branch get added to a sales order only as the customer

consumes the material. This can be done by notification from the customer or by using a delivery driver\salesperson to reconcile physical inventory counts and then billing the customer for the material missing as compared to the consignment branch values tracked on the Business Edge.

To bill for the consumed material, you will enter an Order for their consignment branch. During order allocation, the system will only allow you to allocate from the inventory in the consignment branch. After an invoice is created for the order and updated, the on-hand values in their branch will be reduced.

If you need to replenish the inventory that has been used, there is a button on the final screen of Allocate Inventory under Output Options – Create Transfer, that will allow you to create a Transfer without leaving the order. The options for the quantity to be transferred are the quantity that was on the Order or the re-order point value set up for the Product associated with the consignment branch. Once the transfer is created it can be edited to add or remove lines or adjust quantities in Enter & Edit Transfer.

A Transfer Pick Ticket can then be printed to pull the products that will be replenished on consignment.

When you are sending additional product to your customer as consignment you can enter a Transfer following the same process that was used to create the original Transfer that loaded the branch.

There are three steps to transfers, Enter, Send and Receive, more detailed instructions on how to utilize Transfer documents to move material between branches is located here:

Did this answer your question?