Microsoft Dynamics 365 for Finance and Operations: Inventory consignment process

In this blog post we are going to review consignment scenario where vendor sends the inventory to the company but vendor retains ownership until the consumption. It could be production consumption or sale.  Once the company received the goods, it will be stored in companies’ site or warehouse. Later on, the company can take the ownership of the item once the item is ready to be consumed on a production order/sale. Until changing the ownership, item is still owned by vendor.

The process flow might be as presented below:

Inventory Consignment process

The general idea is in using of the tracking dimension “Owner”. This tracking option gives the visibility who owns what. Using this tracking dimension, you can easily identify where is vendor-owned inventory and where is company-owned inventory. In this process a new type of orders is represented. It’s called Consignment replenishment order which track incoming vendor-owned inventory. In addition to that inventory ownership change journal enables automatic generation of the purchase order product receipt which will constitute grounds for invoice and payments.

There is basic setup that needs to be completed for using inventory consignment capability.

Setups

Inventory owners.

Navigate to Inventory management > Setup > Dimensions > Inventory owners.

Add the vendor who becomes consignment vendor.

Click New button and select Vendor in the Vendor account.

Inventory owners

Tracking dimension group.

Navigate to Product and information management > Setup > Dimension and variant groups > Tracking dimension group.

Create new Owner tracking dimension group by clicking New button.

Set Owner dimension active.

Tracking dimension group

Inventory journal name.

Navigate to Inventory management > Setup > Journal names > Inventory.

Create new journal name by clicking New button.

Select Ownership change journal type.

Inventory journal names

Inventory management parameters.

Navigate to Inventory management > Setup > Inventory management parameters.

Switch to the Journals tab.

Set the default journal name for the Ownership change field.

This journal name will be defaulted upon Inventory ownership change journal creation.

Inventory management parameters

Process overview.

In this example we will follow the process as presented below:

Process overview

1. Product creation

Navigate to Product and information management > Products > Released products

Click New button.

Select Owner tracking dimension group.

Populate the rest of the fields.

Product creation

Keep in mind that Owner tracking dimension could be assigned to the products which have Standard cost or Moving average products.

Moving average productsST

2. Create and activate item price

Navigate to the Manage costs tab > Setup group of fields > Item price button.

Create new record by clicking New button.

After saving it, click Activate pending prices button.

Create and activate item price

3. Create Consignment replenishment order

Navigate to Procurement and sourcing > Consignment > Consignment replenishment orders.

Create Consignment replenishment order

Create the lines of the consignment order.

Lines of the consignment order

Check the inventory transaction. You will notice that Owner inventory dimension is automatically set.

Inventory transaction

4. Record the product receipt

Navigate to Procurement and sourcing > Consignment > Consignment replenishment orders > Receive > Product receipt.

Product receipt menu

Set the Product receipt number.

Adjust the Qty if needed.

Record the product receipt

Check the transactions. You will notice that status has been changed to Purchased.

Purchased inventory transaction

5. Change the ownership

Navigate to Inventory management > Journal entries > Items > Inventory ownership change or Procurement and sourcing > Consignment > Inventory ownership change.

Create new journal.

Journal name will be defaulter from Inventory management parameters.

Change the ownership

Create journal lines.

Change the ownership line

Post the journal by click Post button.

Infolog message will appear with the Purchase order number created.

Message

Check inventory transaction. You will notice that purchase order transaction in the Received status.

Received inventory transaction

That’s it!

Advertisements

3 thoughts on “Microsoft Dynamics 365 for Finance and Operations: Inventory consignment process

  1. Hi, thank you! Very helpful!
    I would like to ask you: is there something that can I use to return to the original vendor the quantity we recived wuth the consignment order?

    Then: we thought to use the consignment order as first step to manage the subcontracting process ads we are the contractor.
    1. recive the quantity with a consignment order
    2. use it as BOM quantity in a production/batch order
    3. generate a sales order for a service item about the finished product transformation
    4. send the finished product to a customer

    is there something to perform te step 4?

    Many thanks!
    Luca

    Like

  2. Hi Galyna Fedorova,

    Really helpful document. Is there any financial Impact/Postings during this cycle.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s