• Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • FAQ

Olof Simren - Microsoft Dynamics NAV Blog

  • Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • FAQ

Consignment Inventory

Apr 26, 2015 | Posted by Olof Simren | Finance, Inventory | 16 comments |

Being able to handle consignment inventory in Microsoft Dynamics NAV is a common requirement. There are four scenarios of consignment inventory that I frequently bump into;

1. Inventory at a Customer

2. Inventory at a Vendor

3. Customer Owned Inventory

4. Vendor Owned Inventory

Some may argue that case 2 and 3 is not consignment, and they might be right, but nevertheless they are cases that needs to be handled and to me the overall concept is closely related to consignment inventory and therefor I included them here. Case 2 and 3 are typically found in relation to subcontracting or product repairs. Case 1 and 4 are the classic examples of Vendor Managed Inventory (VMI).

Here is how it can be handled in Dynamics NAV using the standard functionality;

1. Inventory at a Customer

Inventory at a customer can be handled by creating a location that represent the customer and replenish it using transfer orders. You then invoice from the customer location based on what they used.

What I recommend is to create locations using the same codes as the customer numbers, the location ‘C-10000’ is created for customer ‘C-10000’ for example (I prefer to have prefix for master data codes and not just numbers like it Cronus). The location should have the same name, address, etc. and typically does not require bins or any type of warehouse transactions.

Customer-Location-Dynamics-NAV

You can then define the inventory posting setup for the customer location(s) to point to a specific consignment inventory account in the balance sheet. This way it is separated from an accounting point of view as well.

Customer-Location-Inventory-Posting-Setup-Dynamics-NAV

When the customer asks you to replenish the inventory you just create a transfer order to transfer the items to the customer.

Transfer-Order-To-Customer-Location-Dynamics-NAV

The transfer order has the advantage that you can process the shipments the same way as you process regular sales order shipments (see processing of shipments) and you get packing slip etc. printed from Dynamics NAV.

You also have the option to create a SKU for the items at the customer locations and through the planning parameters and MRP get suggestions of what to transfer. This could be useful if you have an agreement with the customer to keep the stock at a certain level. Don’t forget to setup the transfer routes if you want to do this.

In your balance sheet you now see the inventory you have at customers separated on a different account.

Inventory-At-Customers-Balance-Sheet-Dynamics-NAV

When the customer communicates that they have used some of your inventory you just create a sales invoice with the items at the customer’s location and post it. This depletes the inventory at the customer, creates the COGS, revenue and the AR. The alternative to a sales invoice would be to create a sales order that is shipped and invoiced; the end result will be the same.

Sales-Invoice-Consignment-Inventory-Dynamics-NAV

This way of handling consignment inventory at a customer location is straight forward and works well.

2. Inventory at the Vendor

Similar to how you would handle inventory at a customer you can also have your inventory at a vendor. This is typically for subcontracting processes where a vendor performs operations on your parts (see subcontracting posts).

You create a location for the vendor, preferably with the same code as the vendor number and the same address. Just like with the customer in the previous example.

Vendor-Location-Dynamics-NAV

You also have the option to define the inventory posting setup to separate the inventory at vendors on a separate inventory account in the balance sheet. This time it might be raw material that you have at the vendor (and not finished goods like in the case of the customer). If it is for subcontracting where the vendor is going to consume your inventory then you also need to setup a WIP account, the WIP account is by NAV determined using the location where the components are consumed in combination with the inventory posting group of the item being produced (see production order posting into general ledger for more information).

Vendor-Location-Inventory-Posting-Setup-Dynamics-NAV

I am a big fan of doing the posting setups as needed in Dynamics NAV, so if you never going to have finished goods at a vendor then don’t do the setup for this account. This way you also control what transactions that are possible. I know consultants that by default sets up all different combinations and populates all the accounts in the setup matrixes, I think that approach makes the setup more confusing than necessary.

You then replenish the inventory at the vendor using transfer orders and you can get packing slips, etc. (the same way as with the customer example).

Transfer-Order-To-Vendor-Location-Dynamics-NAV

The inventory value in the balance sheet has now moved to the inventory at vendors account.

Inventory-At-Vendors-Balance-Sheet-Dynamics-NAV

When the vendor informs you that they have used any of the inventories you consume it against the production order (in case of subcontracting). The inventory at the vendor location is then credited and WIP is debited.

3. Customer Owned Inventory

If you handle inventory that is owned by the customer then you want to make sure there is no inventory value associated with the items. You do this by checking the inventory value zero field on the item card (a field that needs to be added to the page).

Inventory-Value-Zero-Item-Card-Dynamics-NAV

If it is an item that you initially sold to the customer that is going back to be repaired then a good option is to create a new item with the same item number plus a prefix (like ‘-C’ in the end). No need to setup separate g/l accounts or posting groups.

You can then handle the inventory just like any other inventory on your regular location(s), which is typically what you want. The receiving part can be done based on sales return orders, this way you have a process to do the receiving and you have a record for the receipt (the sales return receipt).

Sales-Return-Order-Customer-Inventory-Dynamics-NAV

The only thing to make sure is that the sales return order is for a zero amount (if the customer is not going to get a credit that is) and that it gets closed by being invoiced.

If the customers inventory is used as a component in a production process (like performing subcontracting or repairs) then the value of the finished product will be the value of the components that where used from your regular inventory (if any) plus the capacity costs (labor and overhead) you added to the production process.

4. Vendor Owned Inventory

If you have inventory that belongs to vendors then the main thing is to setup posting groups that allows you to separate the inventory value that belongs to vendors from your own inventory. You do normally want the inventory costs on the items to be maintained since you are going to pay for it when you use it. If you are on a standard costing method you want the standard costs of your manufactured items to include the cost of the vendor owned items and if you are on a FIFO costing method you want the cost of your products to include the costs of the vendor owned items once they have been produced (since you pay for them).

From an operational point of view you want to be able to receive the inventory, move it around, count it, and use it just like it was your own inventory.

The way to handle this is to create separate posting groups, you need both a separate inventory posting group and a separate general product posting group. In this case I call them both ‘CONSIGN’.

The inventory posting setup is then defined to have the expected inventory value on a separate consignment inventory account in the balance sheet.

Consignment-Inventory-Posting-Setup-Dynamics-NAV

In the general posting setup you define the inventory accrual accounts to go to a separate account next to the expected inventory account in the balance sheet. The direct cost applied can be the same as the regular direct cost applied account in the P&L.

Vendor-Consignment-General-Posting-Setup-Dynamics-NAV

Now you have separate accounts in the balance sheet where you will have transactions when you receive the vendor owned inventory which net each other out. Note that some would prefer to use liability accounts (instead of an asset accounts) for this, I prefer having it together with the rest of the inventory like below, both ways work.

Vendor-Consignment-Balance-Sheet-Dynamics-NAV

When you do get the invoice from the vendor those transactions will be reversed and the in inventory will be posted against the regular inventory accounts.

Here is how it would work;

The item is setup with the consignment posting groups. In this case I use the standard costing method and the cost of the item is $10.

Consignment-Item-Card-Dynamics-NAV

I establish a purchase order with the vendor that would cover a period of time (almost like a blanket purchase order). The vendor sends you inventory and you receive it just like you would receive any other inventory against the purchase. The transactions you get in the general ledger will be as below after receiving 100 pcs @ $10.

Vendor-Consignment-Balance-Received-Values-Sheet-Dynamics-NAV

The offset account makes sure that you don’t inflate your inventory value with something that is owned by a vendor. The inventory sub ledger will still show that you have 100 pcs in inventory and when you run your inventory valuation report you could exclude the items with the ‘CONSIGN’ posting groups.

You can then move then inventory around and use it as you normally would do. When consumed it creates WIP as regular inventory would, and if sold it creates COGS as regular inventory would. This is ok, and something you want since you are now going to pay for what you have used.

Below is the result of consuming 40 pcs of the vendor inventory against a production order. The vendor consignment inventory account is credited and WIP is debited.

Vendor-Consignment-WIP-Balance-Sheet-Dynamics-NAV

The inventory used is communicated to the vendor who sends you an invoice. The purchase invoice is posted just like a regular purchase invoice (in this case I use the ‘get receipt lines’ function to retrieve the oldest receipt and invoice it (I want the oldest one since that is the item ledger entry that has been consumed or sold, the exception to this might be if the inventory is serial or lot number tracked, then you need to invoice the receipt that is related to the serial or lot number that was used). Note that you only want to invoice what you have used and not what has been received. In our case 40 pcs out of the 100 pcs received.

Vendor-Consignment-Inventory-Invoice-Dynamics-NAV

Invoicing the receipt debits the vendor consignment offset account and credits accounts payable. In case of standard cost you might also get a purchase price variance posted into the P&L. The inventory value for the vendor’s inventory is now netted to zero again.

Vendor-Consignment-Invoiced-Values-Sheet-Dynamics-NAV

Note that the above examples uses the expected cost postings, which is something I think everybody should use (at least if you are in a manufacturing environment).

This was all I could think of in relation to consignment inventory. 🙂

Make sure to visit the new Dynamics NAV FAQ section on my blog.

Tags: ConsignmentCostsGeneral LedgerInventorySubcontracting
16 Comments
2
Share

You also might be interested in

Revalue Closed Item Ledger Entries

Feb 25, 2014

I have meet many experience Dynamics NAV consultants and end[...]

Add Fields to the Item Tracking Lines

Jun 7, 2016

This blog post is to describe how fields can be[...]

Subcontracting Part 1: The Basics

Aug 5, 2014

This is the first part of a series of blog[...]

16 Comments

Leave your reply.
  • Wayne
    · Reply

    June 10, 2015 at 12:27 PM

    Nice post Olaf, think it solves the accounting problems very well.

    My only question is what would sales people see on the item card for available stock.
    Would it include the Consignment stock or just the main location/warehouse ?

    Thanks

    Wayne

    • Olof Simren
      · Reply

      Author
      June 10, 2015 at 4:42 PM

      Hi Wayne,
      The Item Card shows the total inventory by default, but you can use the ‘Limit totals to’ (also known as flowfilters in the older versions of NAV) to define what location(s) that should be included in the quantity on hand.
      If you are on a sales order and entering a line, then the availability is only for the location entered on the sales order line.

      /Olof

      • Wayne
        · Reply

        June 11, 2015 at 5:37 AM

        Looks like we can use it for consignment and also our quarantine and external storage stocks.
        We currently use bins and it forces a lot of calculating for the available stock figures where as a NAV flow filter or sql WHERE clause on location would sort our problems easier and faster.

        Thank you

        Wayne

  • Joern-Hendrik
    · Reply

    August 20, 2015 at 5:45 AM

    Hi Olof,

    as for no.4. “vendor owned (consignment) stock”: this approach probably requires to set up two items “vendor owned item” and “regular owned item” in case the company has also items owned by itself in stock?

    Regards,
    Joern-Hendrik

    • Olof Simren
      · Reply

      Author
      August 20, 2015 at 11:28 AM

      Hi Joern-Hendrik,
      Yes, that is correct.

      /Olof

  • Jamie Hornstein
    · Reply

    November 6, 2015 at 1:10 PM

    Olof, as Joern pointed out, for vendor owned stock, this would require 2 separate items. Is there a way to handle it without 2 items? I see that being problematic when sometimes the finished good items are sometimes consigned and sometimes not. It is the same item for us whether we manufacture or a vendor manufactures. Having two different items would make planning and order management difficult.

    • Olof Simren
      · Reply

      Author
      November 9, 2015 at 9:09 AM

      Hi Jamie,
      The issue is to separate who owns the inventory (and not so much who manufactured it).
      You could potentially use bins to separate the inventory (or if it is lot tracked you could have an indication by lot number), and then have a month end procedure to do journal entries to adjust for the vendor owned inventory.
      This will simplify the planning, but complicate the finance. For operations it would probably be the same, they still need to separate the two.
      That is all I can think of right now.

      Thanks for your comment!

      /Olof

  • Kim
    · Reply

    November 18, 2015 at 2:34 PM

    Olof – We are trying to set up Vendor consignment but sometimes the Item will be consignment for 1 vendor and another vendor we will own the Inventory. How do you handle it without setting up separate Item numbers? Is there any way that you could spend a little time with us? I have a Planning Director and Accounting Manager that have some questions about this process.

    • Olof Simren
      · Reply

      Author
      November 23, 2015 at 9:14 AM

      Hi Kim,
      To do this, I think you need to do a customization (something that will post the inventory using different posting groups depending on the vendor. You can potentially add the ‘Gen. Prod. Posting Group’ to the purchase order line, and change it on individual orders, but this might only get you half way).
      I will e-mail you about the rest.
      Thanks for your comment.
      /Olof

  • Andrew
    · Reply

    November 18, 2015 at 4:14 PM

    I have a few questions. We are using Nav 2009 R2
    The conditions: we are receiving 1,000 units at $20 each total cost of $20,000, the standard cost that is assigned to this item is $23
    1) The original purchase order to bring the inventory from the vendor, would it have the actual purchase unit cost of $20/unit? Or some other unit cost?
    2) When it’s time to pay for the items on consignment, does the invoice get applied to the receipt that brought the inventory into consignment inventory?
    3) How is the purchase price variance (PPV) recorded? As a normal, meaning if the items were not on consignment?
    4) How is the PPV affected if the receipt and payment cross standard cost periods? Meaning we create new standards monthly and this item changes monthly $21, $22, $23, for example, and we have a 3 month supply. Would the PPV change monthly? I have read or have been told that when the purchase order is created, it “captures” a standard cost, and all purchase price variances are generated off this “captured” standard, say it captured the $21, would all the PPV be driven off this unit cost?
    5) How do you run the Inventory valuation excluding a posting group?

    • Olof Simren
      · Reply

      Author
      November 23, 2015 at 9:14 AM

      Hi Andrew,
      Thanks for your comments, below are my replies;
      1. The cost on the purchase order will be according to the standard cost of the item, this is the ‘Unit Cost (LCY)’ field. The purchase price will be whatever you are buying it for (or think you will be buying it for, you change the prince when you get the invoice from the vendor if it differs), this is the ‘Direct Unit Cost’ (which is in the vendors currency if you are dealing with different currencies). So in your case I would say that the ‘Unit Cost (LCY)’ = $23 and ‘Direct Unit Cost’ = $20.
      2. Yes, correct.
      3. The PPV is recorded like with a ‘regular’ purchase.
      4. The PPV is calculated based on the current standard cost at the time of posting the invoice. So, if you change the standard cost every month and you pay the vendor the same amount every month then the PPV will change. A Purchase Order does not ‘capture’ the standard cost this way. The ‘Unit Cost (LCY)’ field on the purchase line gets set when you enter the purchase line, but it gets updated when you post the receipt or invoice.
      5. You just set a filter on the posting group like ‘<>CONSIGN’ (if ‘CONSIGN’ is your posting group).

      I hope this helps. I suggest that you stage the different scenarios and do the transactions in NAV, then you will see how NAV calculates and post the amounts to the different accounts.

      /Olof

  • Richard Keith
    · Reply

    September 20, 2016 at 9:28 AM

    Great Post, Olof

    I am investigating using option 1 to manage stock at a customer’s location, but I want to manage this through MRP, so have been trying to get my head round stock keeping units. Can I set Safety stocks at each location that will blow through to the planning function ?

    Richard Keith

    • Olof Simren
      · Reply

      Author
      September 27, 2016 at 7:11 AM

      Hi Richard,
      Yes, you use the SKUs to setup location specific planning parameters.
      Example; if you have item X on two different locations A and B, then you setup two SKUs; one for the X/A combination and one for the X/B combination. Each of those two can then be configured differently (different safety stock, ect.).

      I hope this helps!

      /Olof

  • Fred
    · Reply

    March 8, 2017 at 4:46 PM

    This post is very helpful. I have a question of how consignment inventory (at a customer) affects production orders. I know we can set a filter to limit what is viewed as available stock. Does this filter apply to production order triggers (i.e. when the system alerts production staff to build more product)?

    • Olof Simren
      · Reply

      Author
      March 8, 2017 at 8:26 PM

      Hi Fred,
      Thanks for your comment.
      The availability in NAV is calculated per location, so consignment inventory at a customer location is not considered available for another location.
      You can use the stockkeeping units to set the planning parameters (‘triggers’) per item/location combination.

      Hopes this helps..

      /Olof

  • Yeng
    · Reply

    October 12, 2017 at 4:30 PM

    I followed your procedure for step 4 and when posting the Work Order I notice that it did not subtract from the vendor consignment account. I played a little on the inventory Posting setup by changing the Inventory Account to be the same as Inventory Account (Interim) and it work. Is it due to the way we have the WIP account setup? Previous setup, I use the same as our Finish good account except for the Interim Account which was using the Consignment account. Also how do I do a Purchase Invoice if we are using advance warehouse management? It will not let me create a manual PI due to advance whse.

Leave a Reply

I appreciate all feedback!
Cancel Reply

Subscribe to Blog via Email

My Dynamics NAV Partner

Naviona, LLC

Categories

  • Assembly (3)
  • Development (31)
  • Finance (14)
  • General (26)
  • Inventory (22)
  • Manufacturing (34)
  • Miscellaneous (25)
  • Purchase (9)
  • Sales (11)
  • Warehouse (7)

Top Posts & Pages

  • Home
  • Kill Sessions in Dynamics NAV
  • Subcontracting Part 1: The Basics
  • XML Buffer and CSV Buffer Tables
  • Processing of Shipments
  • Scrap in Production
  • Functionality Improvements in NAV 2017
  • Add Fields to the Item Tracking Lines
  • Production Order Posting to General Ledger
  • Downloads

Tags

.net Add-in Assembly Assembly BOM CAL Capacity Components Consumption Contact Costs Customer Development Dimensions Excel Finance Flushing General Ledger Inventory Item Items Lot Size Low-Level Code MRP NAV 2015 NAV 2016 Output PDF Planning Production Production BOM Production Orders Purchase Orders Receipts Reporting Reports Role Center Routing Sales Sales Order Sales Orders Stockkeeping Unit Subcontracting Task List Warehouse Warehouse Shipment

Recent Posts

  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Reversing Production Output and Consumption
  • Return Merchandise Authorization (RMA)
  • Sales Quote without Customer
  • Parallel Routings
  • Add Fields to the Item Tracking Lines
  • Field Level Security using Events in Dynamics NAV 2016
  • Schedule MRP
  • Activate WMS Functionality for Existing Location

RSS Feeds

RSS Feed RSS - Posts

RSS Feed RSS - Comments

Microsoft Dynamics NAV - ERP of choice for 110,000 Companies

Categories

  • Assembly (3)
  • Development (31)
  • Finance (14)
  • General (26)
  • Inventory (22)
  • Manufacturing (34)
  • Miscellaneous (25)
  • Purchase (9)
  • Sales (11)
  • Warehouse (7)

Top Posts & Pages

  • Home
  • Kill Sessions in Dynamics NAV
  • Subcontracting Part 1: The Basics
  • XML Buffer and CSV Buffer Tables
  • Processing of Shipments
  • Scrap in Production
  • Functionality Improvements in NAV 2017
  • Add Fields to the Item Tracking Lines
  • Production Order Posting to General Ledger
  • Downloads

Recent Posts

  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Reversing Production Output and Consumption
  • Return Merchandise Authorization (RMA)
  • Sales Quote without Customer
  • Parallel Routings
  • Add Fields to the Item Tracking Lines
  • Field Level Security using Events in Dynamics NAV 2016
  • Schedule MRP
  • Activate WMS Functionality for Existing Location

Recent Comments

  • Arão Benjamin on Discrepancy Between Purchase and Direct Cost Applied
  • Olof Simren on Subcontracting Part 1: The Basics
  • Olof Simren on Discrepancy Between Purchase and Direct Cost Applied
  • kelseyk on Reversing Production Output and Consumption
  • Shafeeque on Discrepancy Between Purchase and Direct Cost Applied
  • Shafeeque on Discrepancy Between Purchase and Direct Cost Applied
  • Gabriela on Subcontracting Part 1: The Basics
  • Andrew Trayfoot on Activate WMS Functionality for Existing Location

© 2018 · Olof Simren

  • Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • FAQ
Prev Next