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. Visit the Trinity Product Page to learn more about our entire add-on suite of advanced features for distribution companies using Microsoft Dynamics GP.
How to Manage Reserved Inventory in Dynamics GP
Welcome to this presentation on the Trinity Reserved Stock module, from Dynavistics.
Reserved Stock provides distributors with a method of assigning quantities of 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.
As you can see here, 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’s 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.
As and when circumstances dictate, we can reassign reserve quantities to accommodate changes in the actual ordering pattern of customers.
So how does this work?
Here we're entering an order for an item that’s 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 - five times six bottles per case. The customer has already taken two cases (twelve bottles) and is about to take another case. Once your order is entered your normal pick/pack/ship procedure remains unchanged.
When the reserve for Kensington was created, it was one of three customers, shown here, who have each been assigned a reserve of five cases from an overall total of fifteen cases.
The Available to Promise inquiry for the item shows on-hand quantity of 46 and an allocated quantity of 13. If we look at the allocated figure in detail, we can see all the orders totaling 24 bottles, four cases. The other nine 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 to 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 twelve bottles, and its associated 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 redistribute reserves to other customers whose demand is greater. In this example, Kensington's initial reserve of five has been increased to seven.
At any time, we can view the status of reserves by customer and by product.
Reserve Stock is designed to:
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. If you'd like to learn more, please schedule your free demonstration today. Thank you.