Item Availability Check not date sensitive
In 2005A, it appears that the item "Automatic Availability Check" feature is not date sensitive. I would have expected the availability routine to use the effective availability on the order due date, including all other demand and supply on or before the sales order due date. However, it seems to use the 'infinite" available quantity shown on the item-warehouse line, that takes into consideration all orders and POs, regardless of their due date.
I can write a formatted search query to compute a true, date-sensitive available quantity and display that value in a UDF on the order line. However, it won't give the user the various options provided on the available quantity pop-up screen (i.e., change quantity to available, check other warehouses, etc.).
Can someone confirm if this is also true in the 2007 version?
Are there other ways to trap quantities in the sales order so that excessive quantities can be handled?