The inventory adjustment record serves the purpose of modifying the quantity and value of an inventory item without the need to input a purchase order. These adjustments are essential for rectifying clerical errors, accounting for changes in cost, addressing incidents of theft or miscounts, and maintaining accurate inventory records. The process of creating and maintaining inventory adjustment records is facilitated through the CSV Import Assistant.
To avail of the functionality of inventory adjustment records via import, it is necessary to have the Inventory feature activated. This can be done within the Items & Inventory subtab at Setup > Company > Setup Tasks > Enable Features (Administrator). Once the Inventory feature is enabled, the Inventory Adjustment option becomes accessible in the Record Type dropdown menu of the Import Assistant, particularly when the Import Type is set to Transactions.
In cases where the Multi-Book Accounting and Multi-Location Inventory features are also enabled, the import process can incorporate accounting book files and detailed inventory information.
For user-friendly navigation within the interface, locating the inventory adjustment record can be done via Transactions > Inventory > Adjust Inventory.
Inventory Adjustment Body and Sublist Fields
To prepare inventory adjustment CSV data for import, make sure that your CSV file includes the following fields.
- Adjustment Account — The account for the adjustment, for example, an expense account.
- Date — Date of the adjustment.
Most imports also require an External ID field, which is used as a unique identifier for the record. You can specify any value that has not been used as the External ID in previous CSV imports.
Note: When using issue inventory numbers in your import, you should distinguish the records you reference in your CSV file by using unique names. Names are handled case insensitively, therefore you must use names that are different not only in their capitalization. Alternatively, you can refer to the records by their internal IDs.
When importing a CSV File to create or update an Inventory Adjustment record, an error: “You cannot create an inventory detail for this item” can be encountered when the item you are importing is not a Serial/Lot Numbered Item or does not use bins.
In this scenario make sure that in the CSV file, if the item is not Serialized nor Lot Numbered, the Serial or Lot Number column must be empty.
Note: Importing an Inventory adjustment containing both Lot Numbered and Regular Inventory items using a single file may cause problems due to the mapping of fields.
When naming your columns, you should use the same naming conventions used by the Import Assistant so that your columns map automatically. For columns to map automatically, each sublist column should have prefixes that begin with Adjustment:.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding.