Understanding Location Format Revision

When business requirements change, you sometimes need to restructure warehouse locations. Redefining the structure of warehouse locations might include adding or removing data elements, increasing or decreasing the size of location segments, changing the justification of one or more segments from right to left or vice versa, and so forth. The warehouse location can consist of up to 10 different location segments for a maximum of 20 characters.

You can change the location formats that are set up in branch/plant constants. Using the location field update programs, you can globally update the location format for multiple tables rather than having to update the location format in each table individually. The programs that update location fields include an interactive program, Location Field Update (P41822), and a batch program, Location Field Update (R41821), that you run from the interactive program.

You can use these programs to update tables that are supplied by the JD Edwards EnterpriseOne system. You can also update custom tables if those tables meet the criteria that are defined in the update procedures.

Important: The Location field is a key field in many tables. When you run the R41821 program in final mode, you must not enable other users on the system.

Depending on the number of tables that you are updating, the batch program might require a substantial amount of time. Therefore, schedule this program accordingly.