How does the Stock Information of a product get updated automatically?
The sales reps need to be cogniance of the available stock in the inventory before confirming a booking with the customer. When a booking is done manually they can check and update the customer and the inventory management team if the stock is running low.
But, in cases where the order processing is done through automated systems it is important to have a way in which there is no dependency on manual updations and the system automatically stocks the inventory based on different factors.
To facilitate this, we have an automatic system to update the stock information based on these three factors:
- quantity in stock
- quantity in demand
- quantity ordered
The Quantity in stock adjusts according to the details in Invoice and Purchase Order, like this:
- Quantity in stock increases when a purchase order is delivered.
- Quantity in stock decreases when an already delivered purchase order is cancelled.
- Quantity in stock decreases with an invoice creation (this includes when a quote or sales order is converted to an invoice).
- Quantity in stock increases with an invoice cancellation.
Quantity in Demand
The quantity in demand adjusts according to the fate of the sales orders, like this:
- Quantity in demand increases when a sales order is created.
- Quantity in demand decreases when a sales order is delivered or cancelled.
- Quantity in demand also decreases when a sales order is converted to an invoice. The status of the sales order thus converted automatically changed to "delivered".
The ordered quantity adjusts according to the fate of the purchase orders, like this:
- Quantity ordered increases when a purchase order is created.
- Quantity ordered decreases when a purchases order is delivered or cancelled.
Read this example to understand the above logic clearly.