Before You Begin

This 10-minute tutorial shows you how to use blank and 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.

Prior to this enhancement, all non-blank codes in UDC table 41/L indicated that the lot status is unapproved or on hold. By following the steps in this OBE, you can set up blank and 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 Blank and Non-Blank Approved Lot Statuses

To use blank and 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. This is an optional step, because you intend to also use blank as an approved lot status. Use the reports Lot Status Mass Update (R41085) and Lot Master Status – Mass Update (R41087) to update or change the lot status code in the tables Item Location (F41021), Item Master (F4101), Item Branch (F4102), and Lot Master (F4108).

   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 another item 270875 has the following availability status in the Work with Item Availability program (P41202).

    

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

    These are the valid Location and Lot/Serial combinations that support the creation of a sales order for Item 270875.

    Location = 1.A.1

    Lot/Serial = 1NK010

    
    

    Location = . .

    Lot/Serial = 1NK001

    

    When the location that corresponds to Lot/Serial 1NK001 is changed to 1.A.1, and Lot/Serial = 1NK001 the system displays an error message. The lot status = Q [non-approved] for this item in location 1.A.1 with Lot/Serial = 1NK001.