How to Manage Reserved Inventory in Dynamics GP

 

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. Visit the Trinity Product Page to learn more about our entire add-on suite of advanced features for distribution companies using Microsoft Dynamics GP.


Video Transcript

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:

  • Help you guarantee your supply when stock is limited
  • Via its detailed audit trail, enable you to monitor promised sales against actual orders placed
  • And reassign 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.  If you'd like to learn more, please schedule your free demonstration today.  Thank you.

 

 

 

You may also like

How to Improve Stock Take Process ...
on August 27, 2019
business software

  Learn how to improve your stock take process as well as managing sales batches with our Trinity ...

commentIcon 0 Comments
Staff Author
Overview of Distribution ...
on August 27, 2019
business software

  The Distribution Enhancements Module for Dynamics GP is a toolbox that contains several areas of ...

commentIcon 0 Comments
Staff Author
Managing Inventory Margin and ...
on August 27, 2019
business software

  See how Trinity Distribution Enhancements for Dynamics GP enables better sales order margin ...

commentIcon 0 Comments
Staff Author
Advanced Customer Item Management ...
on August 27, 2019
business software

  Learn how to control which inventory items customers can and cannot buy using advanced settings ...

commentIcon 0 Comments
Staff Author
How to Manage Inventory Allocation ...
on August 27, 2019
business software

  For some companies, balancing demands of customers when inventory stocks are limited is ...

commentIcon 0 Comments
Staff Author
Solving Challenges Challenges of ...
on August 27, 2019
business software

  Video Transcript Challenges of Speciality Foods Hello, and thank you for joining me.  Today we're ...

commentIcon 0 Comments
Staff Author