Last Updated: March 2026
Your sales rep lands a great deal. The customer agrees to stock your products at their facility. You ship a pallet out the door, and they’ll pay as items sell. Everyone’s happy.
Until three months later, when nobody can tell you how much of your product is at that customer site, whether any of it has been consumed, or what you’re owed.
This is the consignment problem. And if you’re managing it on spreadsheets and phone calls, you’re not alone, but you’re spending a lot of time you shouldn’t have to.
What Consignment Inventory Really Means for Your Business
Let’s be clear about what we’re talking about, because the term gets used loosely.
You own the inventory until the customer uses it. That’s the defining characteristic. Stock is physically located at the customer’s site, but it stays on your balance sheet. You’re not recording a sale when you ship it out. You record the sale when the customer reports consumption.
This arrangement is common across industrial distribution, medical supply, and specialty product companies. It reduces purchasing friction for your customer and keeps your product top of mind. But it also means your inventory is sitting in locations you don’t physically control—and if your ERP can’t track it, you’re flying blind.
How ERP Manages Customer Consignment Locations
The foundation of consignment inventory management in a modern ERP like Acumatica is the virtual warehouse.
You set up a separate warehouse in the system for each customer consignment location. It’s not a physical building—it’s a logical location that lets the system track quantities, values, and movements at that customer’s site exactly like it tracks inventory at your own facility.
Here’s how the flow works:
- You ship inventory to the customer site → the system records a transfer, not a sale
- Stock moves from your main warehouse to the customer’s virtual warehouse
- Your total inventory value stays the same—it’s just at a different location
- When the customer reports consumption → the sale is recorded and the invoice is generated
- When stock drops below threshold → the system automatically triggers a replenishment transfer
That last point is a big one. Instead of waiting for a customer to call and say they’re running low, your ERP flags it and initiates replenishment automatically—based on safety stock levels, reorder points, and max quantities you configure per customer location, per item.
The Real Cost of Managing Consignment on Spreadsheets
Here’s what we see all the time: a distributor thinks they have 400 units on hand. But 150 of those are spread across three customer sites. If those customers have been consuming without reporting consistently, your real available inventory is significantly less than your spreadsheet shows.
Meanwhile, you might be reordering stock you don’t need—because the system doesn’t know what’s already out in the field. That’s working capital tied up unnecessarily, and it’s a problem that compounds month over month.
With proper consignment tracking in your ERP, your inventory reports reflect reality. You can see total on-hand broken out by location, including every customer consignment site. You can see which customer has what, how long it’s been there, and what the consumption rate looks like. And because inventory, purchasing, sales orders, and financials all run on the same database, when a consignment sale is recorded, the GL updates automatically. No separate reconciliation step.
Three Things That Cause Consignment Setups to Break Down
Even with the right ERP in place, a few things consistently cause problems:
- Inconsistent consumption reporting. Your system is only as good as what customers tell you. Set a clear reporting cadence—weekly, monthly, or triggered by reorder point. Some distributors use EDI connections or customer portals to automate this entirely.
- Costing decisions upfront. You’ll need to decide how inventory is valued at customer locations and whether consigned inventory gets tracked under separate GL accounts or subaccounts. Getting this right at setup avoids messy reclassifications later.
- Returns. Not all consigned inventory gets consumed. Expired product, slow movers, contract changes—your system needs to handle the return transfer cleanly so inventory gets back into your main warehouse without creating a GL mess.
Ready to Get Your Consignment Inventory Under Control?
If you’re still tracking customer consignment locations on spreadsheets or through manual reconciliation calls, you’re spending time and energy you shouldn’t have to. The right ERP handles the tracking, the replenishment triggers, and the financial reporting automatically.
CAL Business Solutions has been working with distributors across New England for over 40 years. We know how consignment arrangements work in the real world and how to set them up correctly in Acumatica so your inventory data actually reflects what’s out in the field.
Contact our team today or call us at 860-485-0910 x4 to talk through your distribution setup.
