Before You Begin

This 10-minute tutorial shows you how to use non-blank approved lot status codes for transactions.

Background

A lot status code from the Item Locations file (F41021) is used for lot status validation. Before this enhancement, a blank code from User Defined Code (UDC) table 41/L was the only allowed approved lot status in transactions.

All non-blank values in UDC table 41/L indicate that the lot status is unapproved or on hold. By following the steps in this OBE, you can set up non-blank lot status codes as approved lot statuses.

What Do You Need?

Working knowledge of JD Edwards Inventory Management. For more information, see  JD Edwards EnterpriseOne Applications Inventory Management Implementation Guide.

Setting Up Non-Blank Approved Lot Statuses

To use non-blank User Defined Codes as approved lot statuses:

1. Log in to JD Edwards EnterpriseOne with your user name and password.
2. Use the Fast Path to go to the User Defined Codes program (P0004A) or navigate to the Lot Control (G4113) menu and select Lot Status Code Revisions.
3. In the User Defined Codes program, select Work with User Defined Codes and complete these fields:
   • Product Code = 41
   • User Defined Codes = L

   Click Find.

4. Select the codes that will indicate an approved lot status and enter 1 as the special handling code value for these codes.

   In this example, codes with blank, A, D, I and L represent an approved lot status.

   

   Note: Codes that contain special handling code values other than 1 indicate that the lot status is unapproved or on hold. If you want to use a blank code as an approved lot status, the special handling code must be 1.

5. Records with the blank lot status code are already available in the tables Item Location (F41021), Item Master (F4101), Item Branch (F4102), and Lot Master (F4108). To update this value for the existing items, use the reports Lot Status Mass Update (R41085) and Lot MasterStatus - Mass Update –(R41087).

   Report	Table Updated
   Lot Status Mass Update (R41085)	Item Master – F4101, Item Branch – F4102, Item Location – F41021
   Lot Master Status - Mass Update(R41087)	Lot Master – F4108

6. Use the Fast Path to navigate to the Lot Control (G4113) menu and select the Lot Status Mass Update report (R41085).

   

7. Select a version and click the Row tab and select Processing Options.

   

   

8. Set the value in the Processing Options 2, 4, and 6 as 1 to update the lot status codes in the tables Item Location, Item Branch, and Item Master. If these processing options are not set to 1, then the tables are not updated.
9. Enter valid lot status codes in the Processing Options 3, 5, and 7. These statuses will be updated in the Item Location, Item Branch and Item Master tables.
10. Run the report with the data that you select from the Item Location (F41021) table.

    The PDF output should be similar to this:

    

    

11. Use the Fast Path to navigate to the Lot Control (G4113) menu and select Lot Master Status - Mass Update report (R41087) to update the lot status in the Lot Master table (F4108).

    

12. Click the Row tab and select Processing Options.
13. Enter a valid lot status code in Processing Option 2. This status will be updated in the Lot Master table.

    

14. Run the report with the data that you select from the Lot Master (F4108) table.

    The PDF output should be similar to this:

    

    

15. Use the Fast Path to access the Work with EnterpriseOne System Control program (P99410).

    

16. Click Add + and enter NBLOTSTS in the Data Item field and select Yes. Click OK to save the transaction.

    

    

    For example: Note that Item 270827 has the following availability status in the Work with Item Availability program (P41202) after changing the lot status value to blank in location = 1.A.1 with Lot/Serial = 1600358.

    

    Because a blank code indicates a non- approved lot status, the Available column for that row with Location 1.A.1 and Lot/Serial 160358 is grayed out.

    The Item 270827 from Location 1.A.2 with Lot/Serial = NKL2 is eligible for the creation of sales order.

    

    When the location is changed to 1.A.1 and Lot/Serial to 1600358, the system displays an error message. The lot status code value is blank for this location and lot/serial indicating a non-approved lot status.