{"id":2400,"date":"2022-07-12T17:58:14","date_gmt":"2022-07-12T12:58:14","guid":{"rendered":"https:\/\/omar-iqbal.com\/?p=2400"},"modified":"2023-11-23T19:06:44","modified_gmt":"2023-11-23T14:06:44","slug":"inventory-consignment-ownership-process-in-microsoft-dynamics-finance-operations","status":"publish","type":"post","link":"https:\/\/omar-iqbal.com\/index.php\/2022\/07\/12\/inventory-consignment-ownership-process-in-microsoft-dynamics-finance-operations\/","title":{"rendered":"Inventory consignment\u00a0ownership process in Microsoft Dynamics Finance & Operations"},"content":{"rendered":"\n

In this article we will show you the process of inventory consignment and inventory ownership process in Microsoft Dynamics 365 for Finance and Operations.<\/p>\n\n\n\n

First we will understand the functional part of this process then we will jump over to dynamics and see step by step process.<\/p>\n\n\n\n

In this scenario where vendor\/supplier sends the stock\/inventory to the organization however seller\/vendor holds possession until the utilization. Once the company received the goods, it will be stored in company’s 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. Until the consumption. It could be production consumption or sale.<\/p>\n\n\n\n

In order to perform the inventory consignment process we need to setup the vendor as inventory owner and the tracking dimension to be setup as “Owner” which identifies the separate entities ownership. You can identify using this tracking dimension which inventory is owned by a vendor and by a company.<\/p>\n\n\n\n

In this process we will create new types of order which identifies the vendor ownership inventory, these order are named as Consignment replenishment order<\/strong>. When these types of order is created the it adds the inventory to the system having vendor ownership on it.<\/p>\n\n\n\n

In order to change the ownership of the inventory created by Consignment replenishment order from vendor to company we will create a Inventory ownership change journal by creating and posting of this journal the ownership of that inventory will be changed from vendor to company also a purchase order is created and received as well to sold the inventory from vendor to company.<\/p>\n\n\n\n

Before going to the actual process first we need to setup some prerequisites in Finance & Operations.<\/p>\n\n\n\n

Inventory owners<\/h4>\n\n\n\n

In order to setup a vendor as consignment vendor, we need to create its inventory owner record. For that navigate to <\/p>\n\n\n\n

Inventory management –> Setup –> Dimensions –> Inventory owners<\/strong><\/p>\n\n\n\n

Click New<\/strong> button and select Vendor which you want to make consignment vendor and Save<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Tracking dimension group<\/h4>\n\n\n\n

The tracking dimension group to be setup as “Owner<\/strong>” which identifies the separate entities ownership. You can identify using this tracking dimension which inventory is owned by a vendor and which is owned by a company. For that navigate to <\/p>\n\n\n\n

Product and information management –> Setup –> Dimension and variant groups –> Tracking dimension group<\/strong><\/p>\n\n\n\n

Create new tracking dimension group named as “Owner” by clicking New<\/strong> button, set Owner<\/strong> dimension active for this tracking dimension group.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Inventory journal name<\/h4>\n\n\n\n

Create inventory journal name for journal type Ownership change<\/strong> so that when inventory ownership journal is created it will pick journal name from here. For that navigate<\/p>\n\n\n\n

Inventory management –> Setup –> Journal names –> Inventory<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Inventory management parameters<\/h4>\n\n\n\n

In order to populate inventory ownership journal name to be populated from inventory journal name which we setup in previous step we need to give it to the inventory journal parameters. For that navigate<\/p>\n\n\n\n

Inventory management –> Setup –> Inventory and warehouse management parameters –> Journals tab<\/strong><\/p>\n\n\n\n

Set the default journal name for the Ownership change<\/strong> field.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

After all these setups are done now we will proceed to the process, the process flow diagram is defined below,<\/p>\n\n\n\n

\"\"<\/p>\n\n\n\n

Create new product<\/h4>\n\n\n\n

Create new product. For that naviagate<\/p>\n\n\n\n

Product and information management –> Products –> Released products<\/strong><\/p>\n\n\n\n

Click New<\/strong> button. Select Owner<\/strong> tracking dimension group. Fill the rest of the fields.<\/p>\n\n\n\n

*Make sure that Owner tracking dimension could be assigned to the products which have Standard cost or Moving average products.<\/mark><\/em><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Create and activate item price<\/h4>\n\n\n\n

For create and activate price navigate to<\/p>\n\n\n\n

Manage costs tab –> Setup group of fields –> Item price button<\/strong><\/p>\n\n\n\n

Create new record by clicking New<\/strong> button. After saving it, click Activate<\/strong> pending prices button to activate this price.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Create Consignment replenishment order<\/strong><\/h4>\n\n\n\n

For creating consignment replenishment order navigate to<\/p>\n\n\n\n

Procurement and sourcing –> Consignment –> Consignment replenishment orders<\/strong><\/p>\n\n\n\n

Click New<\/strong> button to create new consignment replenishment order.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now create the line in consignment replenishment order.<\/p>\n\n\n\n

Give Item number value is the item we just created in previous step and quantity to 100.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now check the inventory transaction of this line in consignment replenishment order, you will notice that the owner inventory dimension is automatically setup.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Post product receipt for consignment replenishment order<\/h4>\n\n\n\n

To post product receipt for consignment replenishment order, click on Product receipt<\/strong> button in Generate<\/strong> section.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Enter the External product receipt number<\/strong> and External product receipt date<\/strong> and click OK<\/strong> button.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

After posting of product receipt for a consignment replenishment order, check its inventory transactions again it will be now set to Purchased<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Up till these steps the inventory of these products of 100 units is added to the system but within the ownership of a vendor.<\/p>\n\n\n\n

Create inventory ownership change journal<\/h4>\n\n\n\n

In order to change the ownership of inventory from vendor to company we will now create inventory ownership change journal to do so. For that navigate to<\/p>\n\n\n\n

Inventory management –> Journal entries –> Items –> Inventory ownership change<\/strong><\/p>\n\n\n\n

OR<\/strong><\/p>\n\n\n\n

Procurement and sourcing –> Consignment –> Inventory ownership change<\/strong><\/p>\n\n\n\n

Click on New<\/strong> button to create new inventory ownership change journal.<\/p>\n\n\n\n

Journal name will be defaulter from Inventory management parameters<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Create journal line now.<\/p>\n\n\n\n

Enter Item number, From site (To site will be defaulted from From site), From warehouse (To warehouse will be defaulted from From warehouse), From owner as vendor account, Quantity as 100 units.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Post inventory ownership change journal<\/h4>\n\n\n\n

After creation of inventory ownership change journal, click on Post<\/strong> button in the menu bar, it will open up a dialog click on OK<\/strong> button then to post the inventory ownership change journal.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

It will take some time and a message will appear saying that the “Posting – Journal<\/strong>“.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Check inventory transaction of inventory ownership change journal line. You will notice that purchase order is created and received transaction in the Received<\/strong> status.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

For creation of Consignment replenishment order using X++ code follow the link given below<\/p>\n\n\n\n

\n
Create consignment replenishment order using X++ code<\/a><\/blockquote>