Overview
The Inventory Location Add transaction is used to add inventory to a location where inventory does not currently exist or to add lot/serial-controlled items to an existing or new location. If inventory currently exists in a location, the Inventory Location Adjustment transaction should be used to add material. For Lot Controlled and/or Serial Controlled Items, a lot number and/or a serial number will be required.
Application
This option is used to add items to locations where they did not previously exist. It creates a new item/location record and allows the user to add quantities of the items to the location and specify the individual costs that make up the unit cost. In addition, for lot/serial-controlled items, it allows the user to create new locations or add items to existing locations.
NOTE The Inventory Location Add transaction is used to load opening inventory balances.
Financial Transactions – Sub-Ledger Accounts
NOTE Inventory and Inventory Adjustment accounts are sourced from the commodity code to which the item is assigned or from the Inventory item account record if an account override has been entered.
Processing Notes
When the Inventory Location Add transaction is initiated from a Visualforce (VF) Page, the system creates the custom setting 'LocAdd_RunAsQueueableClass' with a default value of True if it doesn't exist.
Salesforce has a limitation that only a maximum of 5 concurrent Batch Apex processes can run simultaneously.
The Inventory Location Add transaction initiated from the VF page is processed based on the value of the custom setting 'LocAdd_RunAsQueueableClass' as mentioned below:
-
When the custom setting is True, a Queueable job will be created for the transaction using Salesforce Flex Queue. If 5 batch processes are running concurrently, this job will remain in the queue and will be processed when a batch is available for processing.
-
When the custom setting is False, the system processes the transaction based on the quantity to be processed:
-
If the quantity to be processed is less (i.e., < 25), the system processes it synchronously.
-
If more quantity is to be processed and a batch is available for processing, the system processes it as an asynchronous Batch Apex. If 5 batch processes are running concurrently, an error message will be displayed, indicating that the Salesforce server is currently unavailable to process the job.
NOTE The VF page will keep loading until the system processes the job.
Navigation
Inventory Location Add
Processing
Step 1: Select the Item or items. Multiple items may be selected by searching for additional items as each selection is added to the box below. When ‘Display Loc Add Entries’ is clicked, each item will have its own line in the lower portion of the screen, with individual options to add locations, quantities, and cost components.
Fields
Division: Division is set to the current division of the user and cannot be changed directly in this process. To create a transaction in another division, the user can use the Quick Menu option or update the current division on the Manufacturing User record in System Setup.
Site: Select the site for this transaction. The site will be disabled unless there are multiple sites in the selected division.
Search Item: Select the required item. Select additional items to process multiple add transactions simultaneously. As items are selected, the system will copy the item to the item list (box).
Buttons
Clear Selected: Click to remove all the selected items from the item list.
Display Loc Add Entries: Click to display all items that match the filter criteria.
Click the Display Loc Add Entries button.
Step 2: Enter the Location Add Details.
Fields
Select: Check the Item(s) to add the inventory.
Project: When project control is active in the division, select the Project. If the project is not active in the division, the project will default to the home project for the division and will be disabled.
Stock Loc ID: Enter the destination Stock Loc ID. The Location ID must already exist in the Location ID table.
Stock Loc No: Enter the destination Stock Loc No.
Quantity: Enter the quantity to add.
Transaction Date: The date of this transaction defaults to the system date.
Adjustment Account: Defaults to the Adjustment account on the Inventory Commodity Code or the Inventory Item Account if overridden. Select other than the default using the drop-down.
Document: Free form entry of any document reference information (optional).
Comments: Free form entry of comments for this transaction (optional).
Serial or Lot No: If the item is designated serial or lot controlled, enter the serial number(s) or lot number. If the item is both lot and serial controlled, you may enter multiple serial numbers but only one lot. If there are additional lot numbers to add, each is done individually.
Lot Expiration Date: For Lot tracked Items, user-defined Expiration Date will be applied to Inventory By Lot Number resulting record. It can be left empty, and then shelf-life is defined on Inventory Item Master > Misc CC Override tab. Alternatively, if 'Expiration Date is Required' is set (also on Inventory Item Master), then an Expiration Date must be set, and the date value should be greater than the date when the transaction is processed.
NOTE Quantity is required for the lot-controlled items, while the serial number(s) entered will determine the quantity for serial-controlled and lot/serial-controlled items. You have the option to auto-generate the 'Lot No' based on a prefix plus a sequential number. The prefix is defined at the Division level under the Division Master Auto Numbering Tab. The sequential number is tracked and automatically incremented on the Order Number Assign.
Step 3: Enter the Item Cost - Item Cost Details Tab
Fields
Unit Cost, (Material, Labor, Mtl Ohd, Labor Ohd, Fringe Ohd, Mach Ohd, Sub Mtl, Sub Lab, Freight and Landed): Select the Cost Tab and enter the appropriate Unit Cost values to set the resulting costs of the Inventory being added.
NOTE The above Unit Cost fields will be available for user input only if the Division uses the Weighted Average Cost Method.
Step 4: Add Items to Inventory
Once the Loc Add Details and Costs values have been entered, click the Add Items to Inventory button to complete the transaction(s).
Results
Navigation: Inventory Transactions > Cost Transaction Query
Use the Cost Transaction Query to confirm/review the transaction processed.
Fields
Inventory Item Master: Enter an Inventory item master to view cost transactions for just one item. Leave it blank to view all the items.
Start Date: Enter the beginning date that you wish the query to capture.
Transaction End Date: Enter the "through" date to be included in the query.
Transaction ID: Enter the transaction type: INVLOCADD (Inventory Location Add).
Click the Submit button to view all cost transactions that took place between the date range specified and where the transaction type was Inventory Location Add (INVLOCADD).
SEE ALSO
Inventory Location Adjust
Inventory Unit Cost Adjust
Cost Transaction Query
Division to Division Transfer
Site to Site Transfer
Project to Project Transfer
Location to Location Transfer
