Get the latest perspectives on Microsoft Dynamics ERP software selection process from industry experts.

Business Central for Wholesale Distributors (Managing Consignment Inventory)

Visit Website View Our Posts

Business Central does not include a dedicated consignment inventory module, but wholesale distributors manage consignment successfully using dedicated locations or bins to separate consigned stock, deferred purchase invoicing to keep vendor-owned goods off the balance sheet until consumption, and transfer orders to track customer consignment until the point of sale. For high-volume consignment programs, distributors typically add an AppSource extension or light customization to automate ownership tracking and settlement.

That is the honest starting point, and it is worth stating plainly because plenty of distributors sign an ERP contract assuming consignment "just works" and discover the gap during go-live. At Trango Tech, we have configured consignment workflows for distributors on both sides of the arrangement, holding supplier-owned stock and placing owned stock at customer sites, and the difference between a clean setup and a messy one shows up in two places: your month-end inventory valuation and your vendor settlement disputes. This guide walks through both consignment models, the exact Business Central mechanics for each, the accounting behavior you need to verify, and the point at which native functionality runs out.

What Consignment Inventory Means for a Wholesale Distributor

Consignment inventory is stock that physically sits in one party's warehouse while legally belonging to another. Ownership transfers only when the goods are consumed, sold, or otherwise used. For distributors, this cuts in two directions:

Vendor consignment (inbound): A supplier places inventory in your warehouse. You do not pay for it and do not own it until you sell or consume it. Your cash is not tied up, and the supplier gets guaranteed shelf presence.

Customer consignment (outbound): You place your inventory at a customer's site. It remains your asset until the customer uses or sells it, at which point you invoice them. Common in MRO supplies, industrial parts, medical distribution, and vendor managed inventory (VMI) programs.

Both models create the same ERP problem: physical location and legal ownership no longer match, and a system designed around "goods received equals goods owned" needs deliberate configuration to tell those two things apart.

Does Business Central Support Consignment Inventory Natively?

There is no consignment checkbox, no consignment document type, and no built-in ownership dimension in standard Business Central. What the platform does provide is a flexible set of building blocks that model consignment accurately when configured with intent:

  • Multiple locations and location transfers to physically and logically segregate consigned stock
  • Bin-level tracking for distributors who want consignment segregated inside a single warehouse
  • Deferred invoicing on purchase orders so receipt and financial ownership are decoupled
  • Lot and serial tracking that follows consigned goods through consumption
  • Inventory valuation controls that keep vendor-owned stock out of your asset value

This building-block approach is typical of how the platform handles industry-specific processes, which is why distributors evaluating the system benefit from working through a distribution-focused lens rather than a generic demo. Our ERP for distribution page covers the broader distribution capability map, and consignment is one of the areas where configuration choices made in week two of an implementation echo for years.

Managing Vendor Consignment in Business Central (Supplier-Owned Stock in Your Warehouse)

The core challenge with inbound consignment is receiving goods physically without booking a payable or inflating your inventory asset. Here is the pattern that works.

Step 1: Create a Consignment Location

Set up a dedicated location such as CONSIGN-IN, or vendor-specific consignment locations for larger programs. All supplier-owned stock is received into this location. This gives you full visibility of on-hand quantities, lot numbers, and expiration dates while keeping the stock visually and operationally separate from owned inventory.

Step 2: Receive Without Invoicing

Post the purchase order receipt so quantities appear in the consignment location, but do not post the invoice. Business Central's separation of "received" and "invoiced" states is exactly what makes this work. The goods exist operationally, but no vendor liability is created and the interim accounts reflect that the invoice is pending.

Step 3: Trigger Ownership on Consumption

When stock is sold or consumed, transfer the consumed quantity from the consignment location to your main location (or consume directly against the sales order, depending on your process), and post the vendor invoice for exactly that quantity. Ownership, liability, and cost recognition all land at the moment of consumption, which is precisely how a consignment agreement is supposed to behave.

Step 4: Reconcile on a Schedule

Run a monthly consumption report by vendor and reconcile it against the supplier's records before settlement. Most consignment disputes are not fraud, they are timing mismatches, and a standing report eliminates them. Distributors already using dashboards can push consignment consumption into Power BI reporting so both purchasing and finance see the same numbers.

The Valuation Caveat

Watch your inventory valuation setup carefully. Depending on how receipts are configured, received-not-invoiced stock can still surface in interim inventory accounts. Your finance team needs to confirm that consignment locations are excluded from, or correctly classified within, inventory valuation reports. This is the single most common vendor consignment configuration error we see, and it is the kind of detail that separates a distribution-aware setup from a default one. It is also a good example of why out-of-the-box Business Central fails when nobody maps financial requirements to configuration before go-live.

Managing Customer Consignment in Business Central (Your Stock at Customer Sites)

Outbound consignment inverts the problem. The stock leaves your building but must stay on your books.

Model Each Customer Site as a Location

Create a location per consignment customer, such as CONSIGN-ACME. When you stock the customer, post a transfer order from your warehouse to the customer's consignment location. Nothing is invoiced, nothing leaves your asset value, and you retain full quantity, lot, and serial visibility for stock sitting in someone else's building.

Invoice on Usage

When the customer reports consumption (or your rep counts the bins during a VMI visit), post a sales order that ships from the customer's consignment location and invoices the consumed quantity. Revenue, COGS, and inventory relief all occur at the true point of sale.

Handle Replenishment Like a Planner, Not a Firefighter

Consignment locations participate in Business Central's planning engine. Set reorder points per consignment location and let requisition worksheets propose replenishment transfers. Distributors running VMI programs at scale often pair this with mobile scanning at the customer site, and if your consignment program involves third-party warehouses rather than customer sites, the ownership logic is nearly identical to what we describe for 3PL operations, where stock you own sits in a facility you do not control.

Physical Counts at Remote Sites

Schedule cycle counts for consignment locations just as you would internal bins. Shrinkage at customer sites is real, and a documented count history protects the relationship on both sides. Warehouse-level barcode capture makes remote counts dramatically faster, which is one of several reasons WMS integration with your ERP pays for itself quickly in consignment-heavy operations.

The Accounting Behavior You Must Verify Before Go-Live

Consignment succeeds or fails in the general ledger, so test these four scenarios in a sandbox with your actual posting setup:

  1. Vendor consignment receipt: Confirm no payable posts and owned inventory value does not increase on receipt.
  2. Vendor consignment consumption: Confirm the invoice posting books the liability and cost at consumption quantity, not receipt quantity.
  3. Customer consignment transfer: Confirm the transfer order moves stock between locations with zero P&L impact.
  4. Customer consignment sale: Confirm revenue and COGS recognize only on the consumption invoice.

If any of these behave unexpectedly, the fix belongs in posting groups and location setup, not in workarounds at the transaction level. Getting this right during a structured Business Central implementation costs hours. Retrofitting it after a year of misstated inventory costs an audit adjustment.

When Native Configuration Is Not Enough

The location-based approach handles most wholesale consignment programs cleanly. You have outgrown it when:

  • You manage dozens of consignment customers and location sprawl becomes unmanageable
  • Vendors require automated consumption feeds or EDI-based settlement
  • You need true ownership attributes on inventory ledger entries rather than location-implied ownership
  • Serialized, high-value consignment (medical devices, industrial equipment) demands item-level custody trails

At that point, evaluate distribution ISV extensions on AppSource or targeted Business Central customization that adds ownership fields, automated settlement batches, and consignment-specific reports. Vertical extensions exist precisely because industries like distribution have process depth that a horizontal ERP core should not hard-code, a dynamic we unpack in our guide to micro-vertical ERPs.

Budget-wise, consignment automation is usually a modest line item inside a broader project rather than a standalone initiative. If you are scoping numbers, our breakdown of how much an ERP implementation costs shows where configuration work like this sits in the overall budget.

Common Consignment Mistakes Distributors Make in Business Central

Mixing consigned and owned stock in one location. Once quantities blend, ownership becomes a spreadsheet exercise. Segregation is non-negotiable.

Invoicing vendor consignment at receipt "to keep it simple." This books liabilities for goods you do not owe money on and defeats the entire commercial purpose of consignment.

Skipping lot tracking on consigned goods. If a recall or quality claim hits supplier-owned stock in your warehouse, you need lot-level traceability to establish exactly what you consumed and when.

No consumption reporting cadence. Settlement disputes grow in the gap between your records and your partner's. Monthly reconciliation closes that gap.

Treating consignment as a warehouse problem instead of a finance problem. The warehouse workflow is the easy half. Valuation, liability timing, and revenue recognition are where errors get expensive, which is why consignment design should involve your controller from day one alongside your supply chain ERP configuration decisions.

Frequently Asked Questions

Does Business Central have a consignment inventory module?

No. Business Central handles consignment through configuration: dedicated locations or bins for consigned stock, deferred purchase invoicing for vendor-owned goods, and transfer orders plus consumption-based invoicing for customer consignment. High-volume programs typically add an AppSource extension for automated ownership tracking and settlement.

How do I keep vendor consignment stock off my balance sheet in Business Central?

Receive the purchase order into a dedicated consignment location without posting the invoice. The stock becomes visible operationally, but no vendor liability is created and owned inventory value is unaffected until you post the invoice at consumption. Verify the behavior of interim inventory accounts with your finance team.

How do I track my inventory at customer sites?

Create a location for each consignment customer and move stock there with transfer orders. The inventory stays on your books with full quantity and lot visibility. When the customer consumes stock, post a sales order shipping from that location, which recognizes revenue and relieves inventory at the true point of sale.

Can Business Central automate consignment replenishment?

Yes. Consignment locations work with reorder points and requisition worksheets, so the planning engine can propose replenishment transfers to customer sites automatically based on consumption.

When does consignment in Business Central require an extension?

When location-per-customer stops scaling, when vendors require automated settlement or EDI consumption feeds, or when serialized high-value goods need item-level ownership and custody records. Distribution ISVs on AppSource and partner-built extensions cover these scenarios.

Getting Consignment Right the First Time

Consignment inventory rewards distributors who design the process before touching the system. Decide the ownership model, the settlement cadence, and the valuation treatment first, then map each decision to locations, posting groups, and documents. Done in that order, Business Central handles wholesale consignment reliably without exotic development.

If you are planning a new deployment or fixing a consignment setup that finance no longer trusts, talk to a Microsoft Dynamics 365 Business Central partner with real distribution implementations behind them. Trango Tech can review your consignment agreements, model them in a sandbox against your actual chart of accounts, and hand your team a workflow that warehouse staff and auditors both sign off on. Book a consignment design session and see the full setup before you commit to it.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.