Item Availability Check not date sensitive

[Former Member]

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?

Thanks,

Dave

[former_member204969 · Accepted solution]

Item availability check is not date sensitive in version 2007a neither.

Its probably reason is the fact, that in general is not possible to make a good analysis based on one item alone.

For the complex analysis you can use the MRP function.

[Former Member]

Thanks, István.

Your answer made perfect sense. I developed a custom query to solve the problem.