How to Manage Reserved Inventory in Dynamics GP

Dynavistics Trinity Reserved Stock Module provides distributors with a method of assigning quantities of a product to several customers, when supply is limited, and in advance of actual order placement. For more information on the Trinity distribution modules please visit the Trinity Product PageTranscript.

Reserved stock provides distributors with a method of assigning quantities of a product to several customers, when supply is limited, and in advance of actual order placement.
An example would be a wine merchant with a finite quantity of a vintage. In this example, the Reserved Stock module allows us to reserve items for an individual customer, a specific delivery address or a group of customers, as we shall see later. When the reserve is first created, the user has the option of allocating the stock.

When a sales transaction is entered, for an item that has been held in reserve for the customer, the user will have the option to take the stock from the reserve.
In addition we can also define a specific selling price for any stock taken out of reserves. And when circumstances dictate, we can reassign reserved quantities, to accommodate changes in the actual ordering pattern of customers
So how does this work?

On this screen we are entering an order for an item that has been reserved for this customer.If we accept the prompt, the next screen shows that the customer has a reserve of five cases shown here in the base unit of measure, 5 times 6 bottles per case.
The customer has already taken two cases (12 bottles) and is about to take another case. Once the order is entered, your normal pick-pack-ship procedure remains unchanged.
When the reserve for Kensington was created, it was for three customers, one of whom is shown here, who have each been assigned a reserve of 5 cases from an overall total of 15 cases.

The available to promise inquiry for the item shows an on-hand quantity of 46 and an allocated quantity of 13.
If we look at the allocated figure in detail, we can see orders totaling 24 bottles (4 cases). The other 9 cases are shown in the Reserved Stock allocated figure, and represent allocated reserves which have not yet been converted to firm orders.
Back on the Group reserve screen if we select Kensington we can see the status of the reserve, and see all the transactions associated with it.

In this example, we can see the original reserve of 30 bottles, an order placed for 12 bottles, and its subsequent invoice transaction.
Of the original three customers in the group, the second in the list has not placed any firm orders. Assuming the customer now intends to purchase a smaller quantity, and given the finite nature of supply, we can re-distribute reserves to other customers whose demand is greater. In this example, Kensington’s initial reserve of 5 has been increased to 7.
At any time, we can view the status of reserves by customer, and by product.

Reserved stock is designed to help you:

  • Guarantee supply when stock is limited
  • Enable you to monitor promised sales against actual orders placed via its detailed audit trail
  • Re-assign reserve quantities when required

This presentation is one of several short videos on our website that cover Additional Inventory, Purchasing and Order processing functionality that will complement your Dynamics GP system.

I hope you found this presentation interesting and if you would like to know more please schedule your free demonstration today. Thank you.