My Oracle Support Banner

E1: 42: Sales Order Entry (P4210) Program Should Validate the Production Number in Item Location Tag File (F41021T) and Set the Line on Backorder If Production Number Is Not Found (Doc ID 2851261.1)

Last updated on FEBRUARY 23, 2022

Applies to:

JD Edwards EnterpriseOne Warehouse Management - Version 9.2 and later
Information in this document applies to any platform.


Currently, when you enter a sales order, P4210 will only check for the quantity available based on F41021 (Item Location) table.

If Production Numbers are used, the system should check F41021T (Item Location Tag) file and set the order on backorder if the Production Number associated with the sales order line is not present in F41021T with quantity on hand.

For example:

  1. P4114 (Inventory Adjustmnets) add inventory for 10 EA on Production Number (PN) 22|2705|264
  2. Check F41021T - 22|2705|264 has on hand qty = 10
  3. Check P41202 (Item Availability) - qty available = 10 (no mention of PN here)
  4. P4210 Enter sales order for 6 EA. Notice the Production Number on the sales order line was automatically created 22|2705|265.

The order does not go on backorder as the system checks only F41021, not F41021T.

The requirement is for the sales order line to go on backorder if a production number exists on the sales order line but not in F41021T file.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.