This blog provides an overview of the new inbound consignment inventory capabilities in Microsoft Dynamics 365 for Operations version 1611 (November 2016) release.
It is possible to have consignment inventory owned by a vendor but stored at your site. When you’re ready to consume or use the inventory, you take over ownership of the inventory.
This blog post includes information about:
- How to physically receive vendor-owned on‑hand inventory without creating general ledger transactions.
- How to start a production process where the vendor-owned inventory can be physically reserved.
- How to change the ownership of the raw material so that you can process the consumption as part of production order processing.
- There is also some information about how vendors can monitor consumption of their inventory by using the vendor collaboration interface.
By reading this this blog post, you will learn how to:
- Enable inbound consignment inventory by associating an inventory owner dimension value with a vendor account.
- Create a consignment replenishment order header and line to record and process inbound vendor-owned inventory.
- Physically receive vendor-owned on‑hand inventory.
- Monitor inventory cost values when you have on‑hand inventory that is owned by both your own company and the vendor.
- See which on‑hand inventory is owned by you, and which is owned by the vendor.
- Initialize a production order with lines that are physically reserved/picked against vendor-owned on‑hand inventory.
- Process an ownership change journal that is linked to a production, to record the change of ownership of the inventory from the vendor to the current legal entity.
- Monitor the consumed inventory that external vendors must invoice your company for.
- Adjust vendor-owned on‑hand inventory by using counting processes.
- Transfer vendor-owned inventory between storage dimensions.
The demo data company USMF is used for this blog post.
The materials manager (Karl) associates an existing vendor with an inventory owner dimension value.
To track the ownership of the on-hand inventory, it is possible to associate a vendor account with an inventory owner dimension value from the page:
Inventory management > Setup > Dimensions > Inventory owners
It is possible to add a vendor account to the list. The Owner value can be updated to a value that differs from the vendor account number in case you would like to track it differently within the inventory dimension values. The Owner value will be shown to the vendor in the vendor collaboration interface.
Note: The current legal entity owner is created automatically. In this case, the owner dimension value is USMF for all processes that are not related to consignment inventory.
The product designer (Emil) creates a new tracking dimension group and raw material product for consignment inventory.
Click Product information management > Setup > Dimension and variant groups > Tracking dimension groups.
Search for an existing Owner tracking dimension group, or create a new Tracking dimension group that has the Owner tracking dimension set to Active.
When the Tracking dimension group gets assigned to a released product, it will be possible to track the ownership of the on-hand inventory.
Only Items using Standard cost or Moving average costing methods are supported using the Owner dimension.
The purchasing agent (Alicia) manually creates a consignment replenishment order.
Procurement and sourcing > Consignment > Consignment replenishment orders
A new consignment replenishment order has been enabled to record and process inbound consignment inventory.
The order has a very simple UI with header and lines.
As for the purchase order, the consignment replenishment order lines will create expected inventory transactions and the owner dimension value will automatically be assigned based on the linked value related to the vendor account.
The receiving clerk (Sammy)/purchasing agent (Alicia) performs product receipt against the consignment replenishment order.
To get the vendor-owned inventory physically updated, a registration (either via arrival journal or inventory registration) can be processed.
To get the order and inventory transactions into the final state, run the Product receipt update from the consignment replenishment order.
Note: An External product receipt value isn’t required during the product receipt update process. An Internal product receipt number will be used for tracing.
The order status (header/lines) will be updated to Completed as soon as all quantities gets updated.
The inventory accountant (Cassie) monitors the inventory values and cost objects.
It is important to understand that during the consignment replenishment order product receipt process, no cost value will be recorded, and no general ledger transactions will be created.
This means that all inventory statements and KPIs will show values as 0 (zero).
No Inventory value will exist because the on-hand inventory is not owned by the current legal entity USMF.
The external vendor (Erin) monitors on-hand consignment inventory.
On the Vendor collaboration page, it is possible to monitor the on-hand inventory information related to consignment inventory.
Vendor collaboration > Consignment inventory > On‑hand consignment inventory.
An external user will be able to monitor on-hand inventory for several vendor accounts (inventory owners) depending on setup.
The shop supervisor (Lars) initializes the production.
The production line inventory transactions can become reserved and even updated to the status Picked and having the owner dimension value different from the current legal entity. When reserving, the on-hand inventory owned by the current legal entity will take precedence over the vendor-owned inventory.
The materials manager (Karl) processes an inventory ownership change based on production lines.
Inventory management > Journal entries > Items > Inventory ownership change
To record an inventory ownership change, a new journal has been enabled.
The journal lines can be manually entered or created based on a query linked to production lines.
It is only possible to change the owner dimension value that equals the current legal entity.
When posting the journal, the vendor-owned on-hand inventory will be issued out via an ownership change transaction reference and received on the current legal entity (USMF) dimension value via a Purchase order process. The inbound transactions will become product receipt updated (Received) and the price calculations can be based on the Item prices or Trade agreements.
The purchase order lines created based on the consignment process will have the Origin = Consignment.
From the Purchase order line, it will be possible to view the related ownership change transactions, and from the Inventory ownership change journal lines, it will be possible to see the related production line transactions.
As it can be seen from the above screenshot, the inventory ownership change process automatically updated the Issue field with Reserved physically and Picked and the Owner dimension value is updated to USMF.
Therefore, the production flow can continue for the raw material, so that the material can become consumed and put into WIP.
The external vendor (Erin) monitors the consumption of material.
The external vendor can monitor the consignment inventory ownership updates via the page Vendor collaboration > Consignment inventory > Products received from consignment inventory.
The vendor can also see detailed information about the expected invoicing process by viewing the purchase order information.
The warehouse manager (Ellen) creates an on-hand counting journal for vendor-owned on-hand inventory.
In addition to the Consignment replenishment order, the vendor-owned on-hand inventory can be recorded via a counting process. Note: The data connector can be used to create and update counting lines.
The warehouse worker (John) transfers vendor-owner inventory to production.
In case the vendor-owned inventory needs to be registered and transferred to another storage dimension, for example another location, the Transfer journal can be used.
For more information, see Demo script for Inbound consignment inventory (Requires access to PartnerSource).