An enhancement is available for JD Edwards EnterpriseOne 9.2 customers using the distribution modules. Refresh Inventory Commitments (R42990) refreshes any inventory commitments in F41021 (Item Location File) where the item does not have any active sales orders associated with it. The existing program, Repost Active Sales Orders (R42995) refreshes the commitments for only those items that have an active sales order. There may be a case where the sales orders are all completed for an item but for some reason there is still an outstanding commitment recorded in F41021 that needs to be cleared out. R42995 will not update this item in F41021.
Prior to the enhancement, if no active sales orders exist prior to running the Repost Active Sales Orders (R42995), when R42995 was run for locations that have hard/soft committed buckets filled but no open orders in the Sales Order Detail (F4211) exist, commitments would not be cleared for those Item Locations in the F41021 file. One workaround involved creating a 'dummy' order for the specific item so that R42995 would correctly repost the order. The 'dummy' order would then need to be cancelled after running the Repost Active Sales Orders (R42995) program. Another workaround involved using a database utility program such as SQL to clear the commitment buckets in the Item Location (F41021) prior to running the Repost Active Sales Orders (R42995). This process was more efficient if numerous items need to have the quantities and amounts reposted but do not have an open order in the Sales Order Detail (F4211). This process eliminated the need to create and delete what could be many individual "dummy" orders.
For complete information on the enhancement, see Refresh Inventory Commitments (R42990) (Doc ID 2230896.1).