The Reserved ordered items inventory parameter

So I must admit I’m a bit conflicted about the best way to set this parameter. I like to leave it off, but other consultants I’ve worked with think that it should be on.

Inventory management > Setup > Inventory management parameters > General:


So what does it do? Well it lets you reserve from open supply orders as well as physical inventory. By supply orders I mean purchase orders, production orders, or transfer orders.

So the first thing you might notice is the on-hand display. With the parameter selected I see:


But with it off, the system shows:


Let’s leave ‘Reserved ordered items’ blank, and create a sales order for 20. If I have Automatic reservation enabled, when I create the sales order I’ll see:


Fair enough. I’m ordering 20 and there are only 11 in the warehouse, so the system’s asking me what I’d like to do.

Now let’s repeat that with the ‘Reserved ordered items’ ticked:


The system silently accepts the sales order, and when we look at the inventory transactions we’ll see:


We’ve reserved the 11 from Physical inventory, and the balance from the Open purchase order (‘Reserved ordered’).

Personally, I think that’s a bit weak – if you were thinking of using ‘Reserve ordered items’ you should also be looking a ATP (Available to promise) delivery date control. Lachlan Cash, in his most excellent blog has done a series of postings on ATP http://organicax.com/tag/atp/.

The situation’s slightly better if you switch off Automatic reservation and perform the reservation manually (Inventory > Reservation from the sales order line):


The system is showing me that I don’t have enough physical inventory – but again when I click on the ‘reserve lot’ button the system silently reserves against the open purchase order:


Of course, with the ‘Reserved ordered items’ parameter switch off the reservation will only reserve from available physical inventory:


But really in a busy customer service department who’s going to be reserving inventory manually?

As always, there are exceptions. If you create a purchase order (or a production order) from the sales order line, for instance:


Your sales order line and purchase/production inventory transactions are marked, and the sales order line inventory transaction shows ‘Reserved ordered’ regardless of the fact that in this case we have not selected the Inventory management parameter ‘Reserve ordered items’.

Lastly, when you receive the open supply order, the sales order line inventory transactions that have the status ‘Ordered reserved’ are automatically updated to ‘Physical reserved’.

Advertisements

5 thoughts on “The Reserved ordered items inventory parameter

  1. I’m always struggling with those reserved ordered lines in the inventtrans. As long as they are part of a marking they’re okay, but I see rogue ones that consume every piece of inventory that enters the warehouse well before you can make other plans for it.
    It causes a lot of problems with custimizations that don’t take this into account and even with the ones that do.
    Methinks you should only use this in combination with negative inventory to prevent reservation issues.

    By the way, my system suppresses the auto reservation dialog with the parameter off (which makes sens, there’s nothing to reserve then). When the parameter is on, then you get the auto reservation dialog telling you it cannot meet your expectations.

    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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s