E1: 42: Refresh Inventory Commitments (R42990)
(Doc ID 2230896.1)
Last updated on DECEMBER 23, 2019
JD Edwards EnterpriseOne Sales Order Processing - Version 9.2 and later Information in this document applies to any platform.
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.
To refresh any inventory commitments in F41021 (Item Location File) where the item does not have any active sales orders associated with it. The existing program R42995 Repost Active Sales Orders 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!