Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

consignment inventory

Posted on by 240

Does basic AX manage consignment stock from the customer's point of view.  i.e. the supplier has stock in your warehouse, you want to see the stock as available and include in reports and for customer availability, but not to include stock values on your books.  Then to manage the process of automatically raising PO's/invoices when the stock has been sold.

*This post is locked for comments

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: consignment inventory

    Hi Tim

    The Russian localization has the "Owner" dimension and a different way of handling consignment stock I believe - something else for you to look at if you get time, but no idea what other functionality gets switched on when you activate the key for Russia or Poland!

  • RE: consignment inventory

    That External Inventory function looks useful, I wonder why it's not more widely available. But ideally you wouldn't just be able to Register inventory into the External warehouse, you'd be able to create a Purchase agreement and register physical receipt against that. And then when you issue from the consignment warehouse you'd get a [release] purchase order.

    And do you know if there's any other functionality that gets switched on (or altered) if you enable to Poland configuration.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: consignment inventory

    There is such functionality in Country Specific functionalities for Poland. It's called 'External inventory' there. You can enable it for your country.

  • Suggested answer
    Ismael Quteifan Profile Picture
    Ismael Quteifan 667 on at
    Re: consignment inventory

    In addition to Diana's post, below are a few options (using Dynamics AX 2012 terminology):

    Option 1: Negative physical inventory.

    Create a warehouse called consignment, and receive initial stock in there at zero value (movement journal).

    Create an item model group for consignment items that allows negative physical inventory.

    Don’t set any min-max levels in consignment warehouse.

    Use item coverage type requirement in main warehouse.

    Upon requirement, issue items from main warehouse and stock will go below zero. This will trigger a PO to the main warehouse.

    Physically take the items from consignment. Run a periodic stock count in consignment to adjust stock levels up/down.

    When the PO is received, physically put the replacement in consignment, but receive in main warehouse. Stock is now back to zero.

    When the invoice is received, process as normal.

    Run recalculation after invoice always for the cost to flow.

    Downsides:

    Manual adjustment of consignment, no master planning.

    The PO is meant for the replacement but the invoice is meant for the item used. These should not belong to the same PO in the eyes of auditors.

    Master planning will not suggest transfers.

    Option 2: Simplified PO receipts.

    Create an item model group that will not post physical inventory and call it consignment.

    Item model group will have physical value included in item cost.

    Can create a consignment warehouse.

    (Alternatively, create a consignment location only and make it the default receipt location. This way you'll have to override this setting every time you purchase the same item for stock).

    Can have a trade agreement for all other warehouse, but not consignment, with prices (as cannot have zero prices on trade agreements, but can have them on item).

    Have a min/max policy in consignment warehouse with min=max.

    Create a PO pool called consignment to separate consignment POs from all other types.

    Raise POs for all existing consignment quantities for zero value.

    Register receipt these POs in consignment (item arrival journal or receipt list from the PO).

    When an item is required, create a product receipt of that item quantity only into the main warehouse (override registered quantity) and post the items.

    When the invoice comes in match it with the product receipt in the main warehouse.

    Run recalculation after invoice for the cost to flow.

    Master planning will kick in and reorder for consignment. When items arrive, register them and repeat cycle.

    Downsides:

    Leaves open POs for a long time, however they will have zero value. Accountants do not like that especially towards end of periods.

    Not posting physical inventory will back fire on POs ordered straight to the main warehouse. Have to wait for invoice to realise cost.

    Can work around the above by enforcing zero value in consignment warehouse and ticking post physical inventory. This is a matter of process discipline rather than system enforcement.

    Will have to tweak inventory valuation reports unless physical value is not part of cost calculation (item model group).

    Option 3: Service items.

    Consignment item will have zero value always, no trade agreements.

    Item coverage will be min/max in consignment (min=max) and requirement in main warehouse with refill from consignment via transfer orders.

    Create a service item called consignment stock (or many service items if you like).

    When the item is reqwuire, master planning will suggest you transfer from consignment and reorder replacement. Firm the two orders.

    Receive replacement at zero value (and invoice at zero value too).

    Manually raise a PO for the service item to the vendor, when the invoice comes in, receive the PO and invoice match it, then post it to the same destination you posted the item to (project, sales order, production order etc.).

    Downsides:

    The cost of the item will only be known if the item is ordered for main stock. In all other cases it will be zero in all warehouses and all projects/sales orders/production orders.

    Manual control, but this is across the board for all solutions.

    Still have a couple of suggestions up my sleeve, but would like to hear feedback on these first.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: consignment inventory

    Michael, can I ask a question please as I am looking into consignment stock .. When you say its tied to the customers RQ within the system.

    Could you elaborate more on this please, did you use standard AX or something specifically for this need?

    Thanks and much appreciated

  • Michael Evans Profile Picture
    Michael Evans 30 on at
    Re: consignment inventory

    We have developed an interface using EP and Transfer Orders for consignment purposes.  It’s quite slick.  When A transfer order is created, it posted the items onto the portal.  Once received, the customer then simply check the boxes when it’s received and it updates the transfer order and placed the item into the consignment warehouse.  (Bar code scanning to be added later)  The customer also has a 2nd tab in which they can consume the inventory and in doing so, it creates a sales order.  It’s tied to the customer RQ within the system and has rules to prevent them from selecting more items then are the customer RQ.

  • hassan210360 Profile Picture
    hassan210360 450 on at
    Re: Re: consignment inventory

    In addition to Thompson post,

    You can create also a new location called consignment and several warehouses used to keep the consignment separated from the other inventories.

  • diana g Profile Picture
    diana g 689 on at
    Re: consignment inventory
    You can kind of do it, but raising the vendor invoice is a manual process. You can create a purchase order for the quantity you are receiving and do a packing slip update to bring it into stock. You’ll need to make sure that the stock is brought in at 0 cost so that it doesn’t appear in your books. For that, you have 2 options.. 1. don't put a price on the PO so that when you do the packing slip update it will have no value in inventory or the ledger. Then enter the price in the invoice update screen when posting the invoice. Depending on your inventory costing method, you may need to run a close to update the cost of sale.
    2. if you put the price on the PO then make sure the item does not "post physical inventory" which is set in the inventory model group. That will make sure that the value does not hit the ledger until the invoice is posted. This will however give a physical value in the inventory module so you need to consider that and exclude those if you run physical inventory value reports. If you ‘include physical value’ on the model group then the cost of sales will go through at the price on the PO and you won’t need to wait for the close to get the cost right. This is probably the best way to set it up.

    When you sell the items then you need to go back to the PO and do the invoice update for the quantity you sold. You might need to setup a report and/or alerts to tell you to invoice the PO. This invoicing would be a manual process because in standard AX, there is no functionality to automatically raise the PO invoice based on a sale. If you have a high quantity of these, then you will probably want a customization to raise the PO automatically. This shouldn’t be too difficult.

    Di Thompson

    www.ThePPAXStore.com

     

     
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: consignment inventory

    Hi Steve,

    I do not think this function is standard available in Dynamics AX. You would have to make a customization for it.

    Kind regards,

    Dennis

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans