Cannot Add Primary Location - Workaround

Purpose of Document

Is there a standard way to create the Primary Location (F41021) when this was not added during Item Branch creation with the P41026 program?
 

No. There is no standard way to populate the primary location through the following applications:

• P41026 - Item Branch, based on F4102 (Item Branch File)
• P41024 - Location Revisions, which allows additions and updates to the F41021 (Item Location File)
• Or R4101Z1I - Item Master Unedited Transactions Inbound Processor which allows the user to create F4101/F4102/F41021

Reference:

• Interactive application: <Bug 16953703> : ADD PRIMARY LOCATION (this is an enhancement request, this functionality does not yet exist)
• Batch application: <Document 625451.1> E1: 41: How to Create Item Master and Item Branch Plant Records Using Interoperability (R4101Z1I/P4101Z1/F4101/F4102/F4101Z1)

  Question 10: Is it possible to create secondary locations using R4101Z1I? Also, is it possible to create a primary location for already existing Item Branch/Plan records?
  Answer 10: No, R4101Z1 is not designed to create additional F41021 records. You can create multiple F4102 records against already existing F4101 records, and can create primary locations when creating F4102 records, but not secondary locations for existing item/branch records. In addition, you cannot use R4101Z1 to restore a missing primary location record.

Workaround 1:

(Custom routine) If this is a frequent requirement, the user can call the form W41026B (Primary Location) through W41026H (Work with Item Branch) form. This creates records in the F4111, F4108 and F41021.

 Example :

      1. Create a dummy B/P
      2. Create dummy records through P41026 by adding Item B/P (F4102) for your item
      3. The system open W41026B [Primary Location] for this new (dummy) Item B/P. Click OK on this form W41026B [Primary Location]. Now , there is a primary location for the dummy B/P .
      4. Update F41021.MCU with an SQL instrument , with the B/P that it needs .

Workaround 2:

This method involves lot/location creation 'on the fly' as explained in <Document 1075187.1> - E1: 40: Item Branch/Location/Lot Creation On the Fly in E1 Inventory Transaction.

1. Go to P4114 (Inventory Adjustment)
2. Specify Item, Quantity, and Lot Number with (for lot controlled item) with Lot Expiration Date which creates Primary Location. To create item location on the fly, you must specify either Location or Lot (or both)
3. (Not to change physical inventory or it's value and cost) Reverse it
4. In case the primary Location with Blank Lot then update F41021 (Item Location) Lot Number using query tools because there is no means to create blank value