Home Blog Technical Tuesday: How to Implement Consigned Inventory in Acumatica Cloud ERP Software, Part 2

Technical Tuesday: How to Implement Consigned Inventory in Acumatica Cloud ERP Software, Part 2

Doug Johnson | November 17, 2022

This post is the second in a two-part series that explains how to implement two consignment inventory scenarios in Acumatica. The first post involves placing your inventory at a customer site, while this second post involves storing vendor inventory in your warehouse until is it needed. This tutorial assumes a working knowledge of Acumatica, but is also designed to give those who don’t have that knowledge a glimpse into what Acumatica Cloud ERP Software can do to transform business processes.

Demo Built in Acumatica Environment: 5.20.1452

Data: SalesDemo Data from Acumatica’s Partner Portal

Acumatica's Technical Tuesday

Business Purpose

Consignment involves two main business concepts: where inventory is stored and who owns the inventory. In this post we will discuss the first of the two scenarios below:

  • Inventory stored at your customer’s site, you own inventory until used by the customer
  • Inventory stored at your site, vendor owns inventory

The implementation of both scenarios involves setting up a consignment warehouse. In Acumatica this is easily achieved by creating a virtual warehouse, which is explained below.

Scenario 2: Inventory in your warehouse, vendor owns inventory

In this scenario, one of your vendors provides you (the purchaser of Acumatica) with inventory that you will store and sell. The goods are in your physical possession but should not impact your balance sheet because they are still the property of your vendor.

When you sell the goods, you pick them from the consignment warehouse and ship them to your customer. When this happens, you create a purchase order and take ownership of the goods.

1. Vendor signs up as a consignment vendor.

2. You (Acumatica system owner) receive consigned goods from vendor.

  • This includes a report to the vendor on what has been received.
  • Vendor consigned items are stored in warehouse and available for sale.

3. Sales order created for consigned goods

4. Consigned Items are sold

  • Items are picked, packed, and shipped to the customer
  • A purchase order is created and sent to the vendor – the PO invoice is used to register the GL costs and transfer ownership of the goods to the Acumatica System Owner

5. Customer Invoice created

Creation of Customer Invoice.

In this example, we assume the vendor arrangement only requires sending a single invoice on a periodic basis. This allows us to follow the normal customer sales order process and do a periodic inventory count to create a purchase order for our vendor.

An alternative vendor agreement may require a purchase order for each sales order that you process. If this is the case, the purchase order (step 4b) can be created at the same time as the sales order (step 4a) by selecting the option Mark for PO on the sales order and setting the PO source as purchase to order. In this case we have already ‘received’ the goods because they are in the vendor warehouse.

Implementation in Acumatica – Scenario 2

In this scenario your company receives inventory from a vendor that is placed into a separate location. The vendor owns the inventory until you remove it and use it. This scenario can be implemented by taking advantage of the following Acumatica features: multiple warehouses/locations, multiple ledgers, inter-company transactions, and import/integration utilities.

Step 1: Vendor signs up as a ‘consignment vendor’

1. Create a new branch and a new warehouse that are linked to a separate ledger so consigned inventory is not on your books

How to Implement Consigned Inventory in Acumatica Cloud ERP Software

Step 1: Vendor signs up as a ‘consignment vendor’

Revision two HQ - Warehouses.

  • The vendor warehouse could be a virtual warehouse – it does not have to be a separate building or fenced off space in your warehouse.
  • Multiple vendors can be linked to this warehouse and branch, so creating a second vendor will be easier than creating the first – all you need to do for the second vendor is add a warehouse location. With multiple vendors, check the cost separately flag for each warehouse location.
  • Set the Inventory Account to the new account (see step c below) called Vendor Owned Inventory

2. Link Customer Branch and Ledger. When inter-company transactions are turned on, you set this up in Finance -> General Ledger -> Configuration -> Manage -> Inter-branch Account Mapping as illustrated below.

Inter-branch Account Mapping.

3. Create a new account called Vendor Owned Inventory to store inventory assets on the vendor’s balance sheet.

Revision Two HQ - Chart of Accounts.

Step 2: Receive consigned inventory from your vendor

1. Create a reason code for the consigned inventory.

Revision Two HQ - Reason Codes.

Revision Two HQ - Reason Codes.

In this paper, I used the first option – the vendor owned inventory account. I created inventory items with the same inventory account – so when we receive an item, the transaction creates a debit and a credit in the same account and no value accumulates in the vendor warehouse. I could have also created a subaccount segment for tracking vendors if required.

Revision Two HQ - Stock Items.

The second reason code option is slightly easier to setup because most of my existing inventory items in the demo data use this account.

2. Enter and release a receipt for your goods

Vendors Branch - Receipts.

Important items on the receipt include:

  • Go into the VENDOR branch to receive the goods so nothing appears on your ledger/books.
  • Confirm the VENDOR branch.
  • Confirm the VENDORS warehouse (this inventory defaults to this warehouse).
  • Enter the location for the vendor which you are receiving the goods from.
  • Entering a cost is optional, but might be useful for reporting.
  • Select the reason code based on your setup in the preceding step

3. After releasing your receipt, the following transaction and inventory appears:

Vendors Branch - Journal Transactions.

4. A signed report could be created and emailed to the vendor to verify the receipt of the goods. The current available report that can be run from the receipt screen appears below:

Inventory Register Detailed.

Step 3: Vendor Consigned Goods are Available for Sale

1. Run an inventory summary report to verify that the goods are available in the vendor warehouse.

Vendors Branch - Inventory Summary.

The way that I constructed my reason codes, nothing shows up on the balance sheet of the VENDORS ledger.

Step 4: Sales of Consigned Items

The sale of consigned items is similar to the standard sales process.

1. Create a sales order to sell the items

Revision Two HQ - Sales Orders.

  • Sell from the HQ branch
  • The warehouse was automatically assigned as VENDORS because that was the default for my consignment item

2. Create the shipment, print the pick list, pack the items

Pick List

  • Items are picked from the consignment warehouse

3. Confirm shipment, prepare invoice, release invoice – review financial transactions

Revision Two HQ - Shipments.

  • Invoice: debit Accounts Receivable HQ) | credit Sales Revenue (HQ)
  • Inventory: debit Cost of Goods Sold (HQ)| credit Vendor Owned Inventory (VENDOR)
  • Inter-Company (if turned on): db Due From HQ | cr Due to VENDOR
  • The resulting vendor balance sheet from this series of transactions is:

Assets and Liabilities.

The due from related (HQ) can be cleared when we generate our purchase orders.

Step 5: Create Purchase Order (or report) for Vendor(s)

Create a report for the vendor that reports the sale of items over the time period. This can be used to create the vendor invoice or purchase order.

The Account Details report will provide this information and can easily be exported and imported as a PO.

Step 5: Create Purchase Order (or report) for Vendor(s)

Conclusion

Acumatica has built-in functionality to manage consigned inventory scenarios and Acumatica’s business model fits the needs of distribution companies that work with consigned inventory. The web-based architecture makes it easy for vendors and customers to be included in business processes from remote locations. Unlimited user pricing makes it economical to add these infrequent users with no additional licensing fees.

The scenarios discussed in this post and our post last week are a sample of different potential mechanisms for managing consigned inventory. The addition of EDI interfaces and RFID technology can improve the level of automation, restocking, and inventory management.

Have a unique consignment scenario? Contact djohnson@acumatica.com with requirements to see if the solution can be easily adapted for your needs.

Blog Author

VP, Product Management at Acumatica.

Receive blog updates in your Inbox.