Overview
The Inventory Location Adjust transaction can be used to either increase (except for serial controlled parts, which by definition there can only be a single serial in a given Inventory Location - ICITEMLOC) or decrease the existing inventory of an item in a specific Stock Location ID/Number. For Lot Controlled Items, a lot number will be required. Serial Controlled items may be adjusted down only, but adding Serial Controlled items is done using Inventory Location Add.
Application
This transaction is used when inventory for an item in a specific stock location must be adjusted (Increase or Decrease). Also, this program gives the user the option to identify a reduction in inventory as Scrap.
NOTE Cycle Count Transactions are processed using this Inventory Location Adjust transaction.
Financial Transactions – Sub-Ledger Accounts
Increase:
Decrease:
NOTE Inventory and inventory adjustment accounts are sourced from the Item’s assigned commodity code or the Item Inventory Account record if an account override has been entered.
Processing Notes
When the Inventory Location Adjust transaction is initiated from a Visualforce (VF) Page, the system creates the custom setting 'LocAdj_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 Adjust transaction initiated from the VF page is processed based on the value of the custom setting 'LocAdj_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 run 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 Adjust
Processing
Step 1: Select / Enter the Items
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. Only inventory within this division will be displayed.
Site: Select the site for this update. Only inventory within this site will be displayed.
Item No: Select the item (required). Select additional items to process multiple adjustments for different items simultaneously. As items are selected, the system will copy the item to the item list (box).
Project: Optional filter. When project control is active within the division, select a Project ID to view the inventory for a specific project or select None to view All Projects.
Stock Loc ID: Optional filter. Selecting a value will cause only inventory within this Stock Location ID to be displayed. Select None to display all locations where other filters apply. This option can be helpful when doing cycle count adjustments, for example.
Stock Loc No: Select an Inventory Location Number valid for the given Inventory Location ID if using pre-defined Location Numbers, otherwise, enter a free-form Location Number up to 10 characters in length.
Lot No: Enter a valid Lot Number currently located in the given Division/Site/Project/Stock Loc ID/Stock Loc No (as applicable).
Click the Display Inventory Location button to display all inventory locations that match the inventory/item selection criteria.
Step 2: Item / Location Selection Details
Fields
Checkbox: Select the Checkbox for each location to be adjusted.
Click the Process Selected Inventory Location button to enter the adjustment details for each location chosen (checked).
Step 3: Enter the Adjustment Details
Fields
Adjust Option: Select Adjust Up to increase inventory. Three options.
NOTE This option is not available for serial controlled items.
-
Select Adjust Qty Up to add inventory OR Adjust Qty Down to decrease inventory.
-
Adjustments create INVLOCADJ cost transactions.
-
Select Scrap to decrease inventory.
-
Scrap adjustments create INVLOCSCRP Cost.
Process Qty/Serials: For non-serial items, enter the quantity to adjust. For serial items, select or enter the serial number to adjust (adjust down or scrap only).
Transaction Date: Enter the date of the transaction. The default is the system date.
Adjustment Account: Accept the default or select a different adjustment account from the pick list.
Comment: The user entered free-form text.
Cycle Count: Check this Flag if this adjustment results from a cycle count. Inventory Location Adjustment Transactions processed as a Cycle Count are tagged with a Cost Transaction ID of INVLOCADJ and a Cost Transaction Sub ID of CYCLECNT.
Click the Adjust Inventory Button button to process the Inventory Location Adjust transaction.
Results
Navigation: Inventory Transactions > Cost Transaction Query
Use the Cost Transaction Query to confirm/review the transaction just processed.
Fields
Item Number: Enter an item number to view cost transactions for just one item, leave blank for all items.
Start Date (Required): Select/Enter the start date.
End Date (Optional): Select/Enter an end date.
Transaction ID: Enter the transaction type: INVLOCADJ (Inventory Location Adjust) or INVLOCSCRP (Inventory Adjust Scrap) or leave blank for all.
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 Adjust (INVLOCADJ).
NOTE If a Location selected for the transaction was flagged as a Cycle Count, the Inventory Location Adjustment Transaction will be tagged with both a Transaction ID (INVLOCADJ) and a Transaction Sub ID (INVLOCADJ-CYCLECNT). The query for the Transaction Type INVLOCADJ-CYCLECNT to return only Inventory Adjustment transactions where the Cycle Count Flag was selected.
SEE ALSO
Inventory Location Add
Inventory Unit Cost Adjust
Cost Transaction Query
Division to Division Transfer
Site to Site Transfer
Project to Project Transfer
Location to Location Transfer
