Skip navigation

If you buy anything at a grocery store then you have seen Advanced Lot Management at work. Shelf Life of a product translates into the expiration date of the item.  In addition there are other dates that can be utilized to manage your lot inventory.  Think about products such as pharmaceuticals, dairy, fresh meat or produce. These items not only have a shelf life and expiration date but may also have Best By Dates and Sell By Dates which are part of lot management.


Consider also, these items have manufacturing effective and purchasing effective dates. These dates, for example, can establish a time frame for the purchased goods to be inspected prior to the lot becoming “effective”.  In a similar manner, a manufacturing effective date may be used to delay release of a lot for sale to allow the product to fully mature so the product is not available for sale until the manufacturing process, (including aging, curing, etc.) has been completed.  You do not want to sell something that is immature or not ready to be sold. Therefore, not only are the above dates considered but also immature lots are considered by programs to ensure product does not go out the door prematurely.


When selling your inventory, what inventory commitment options are available?


Standard commitment methods include:

  1. Committing from locations with greatest quantity first
  2. Committing by lot where the lowest lot number is committed first
  3. Committing by expiration date where locations with the earliest expiration date are committed first.


But what if these standard methods do not provide the flexibility you need?  Maybe you would like the ability to establish rules defining how inventory is committed for a Customer, Item or Both.  Or even by Customer or Item Groups.  Your processes may require committing inventory by Lot Expiration, Sell By, Best Before, or other specific dates.  If you could just override the standard commitment method set in Item Branch/Plant Information….


As of JD Edwards World Release A9.1, all this is possible using Advanced Lot Management! 


Advanced Lot Management combines the new lot fields on the Lot Master, Item Master and Item Branch Plant with Preference Profiles to ship product by Ascending Ship Date Rules.  This functionality is incorporated into the sales order entry, pick slip, inventory commitment and shipment confirmation programs and utilizes the new Last Customer Shipment Inquiry and file, P4239/F4239. 


For more on this topic review:

Preference Profiles in Sales(Doc ID 626656.1)

Immature Lot Functionality in Sales Order Management(Doc ID 2049519.1)

Lot Effective Dates - Manufacturing and Purchasing Days(Doc ID 804166.1)


Or join us on May 11th for the Advanced Lot Management Preference/ Ship Ascending Dates Advisor Webcast were we will be discussing these topics. You can register for this webcast at JD Edwards World Advisor Webcast Schedule and Archived Recordings (Doc ID 1455377.1).

Do you need to create purchase orders to accommodate sales order demand in one fell swoop? There is new functionality in the World A9.3 release to do just that. Prior to the A9.3 release, the Direct Ship program (P4243) was only geared to accommodate transactions for which goods are supplied directly from your supplier to your customer. As of the A9.3 release, P4243 is equipped to handle stock transactions, that is, to create a purchase order for goods received to inventory prior to being shipped to the customer on a related sales order.


In addition to creating back-to-back sales and purchase orders via P4243, the Batch Sales Order Creation program (P40211Z) will also accommodate the creation of back to back orders.


Prior to the A9.3 release, if you attempt to create back-to-back orders using a stock line type via P4243, the resulting sales and purchase orders may not be processed properly by the system. The system has been enhanced to orchestrate the back-to-back order functionality, as well as to enhance the drop ship process, as follows:


Direct Ship Orders (P4243)

  • Prevent order changes at certain statuses
  • Display requested date for purchase orders in video header
  • Display pick and ship dates for sales orders
  • Invoke the Inventory Commitment Preference (for stock transactions)
  • Accommodate order templates
  • Accommodate order duplication process
  • Default Ship-To address for supply branch on PO (for stock transactions)


Enter Receipts (P4312)

  • Accommodate partial receipts by updating order lines on PO and related SO
  • Update inventory receipt location to related sales order
  • Automatic shipment confirmation of related sales order


Shipment Confirmation (P4205)

  • Prevent shipment of sales order prior to receipt of related purchase order


An extended benefit of the new functionality is the ability to track the location of drop ship items from the time they leave your supplier’s warehouse to their final destination (via receipts routing).


For more information about the Direct Ship Order Entry program, please see Direct Ship Orders (Doc ID 626663.1).

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see for instructions.