Skip to Content
0
Former Member
Jun 18, 2010 at 09:49 AM

Item Availability Check

66 Views

Hi Experts,

Our client is usually doing SO then A/R Reserve Invoice which creates a commitment for a certain item in a certain warehouse. But sometimes, they tend to sell more that what is only in the available stock. They are also quite misled when there is an ordered quantity since this will also add back to the available quantity. To avoid returns due to overselling, can we have a query-FMS if In Stock - Committed - Orders <= 0, when an item for the warehouse selected is being transacted in the SO?

Many thanks,

Don