Notes about Items Imports

The following information may apply to your items imports:

Import of Inventory Detail Data Currently Not Supported

When the Advanced Bin / Numbered Inventory Management feature is enabled, the following types of items include an Inventory Detail subrecord in the user interface: Assembly/BOM Item (when Use Bins is set to True), Lot Numbered Assembly/BOM Item, Serialized Assembly/BOM Item, Inventory Item (when Use Bins is set to True), Lot Numbered Inventory Item, and Serialized Inventory Item.

The Inventory Detail subrecord includes quantity on hand and quantity available values per bin number and per serial/lot number. Import of this subrecord's data is not currently supported. If you enable the Advanced Bin / Numbered Inventory Management feature, CSV import of the types of items listed above may result in incomplete data. For details about this feature, see Advanced Bin / Numbered Inventory Management.

Unique Item Lookups by Internal ID and External ID

To help eliminate ambiguous or missed lookups, the Import Assistant lets you reference an Item's Internal ID or External ID.

For more information, see Select Reference Types.

Updating Inventory with Imported Items Data

After you have completed an import of items, you can use the Adjust Inventory Worksheet to update inventory levels. For more information, see Inventory Adjustments.

Updating Vendors on Items

You can use the Import Assistant to update Vendor sublist information for items. For these updates, depending on your setting for the Overwrite Sublists option, you can overwrite items' existing vendors sublists, or you can selectively update based on a key of Vendor name.

You also can use an alternate method to set preferred vendors for items through a CSV import. The Import Assistant supports the addition of a Preferred Vendor column to an Items CSV file. If the vendor specified in this field currently is on the vendor list, the import marks it as preferred; if it is not on the list, the import adds it. This method is available even if the Multiple Vendors feature is not enabled.

Important:

If your CSV file defines more than one vendor as preferred for an item, the last vendor listed is the one that is marked as preferred by the import.

Updating Locations on Items

You can use the Import Assistant to update location sublist information for items, when the Multi-Location Inventory feature is enabled. The fields that are updatable per location are Preferred Stock Level, Quantity on Hand, and Reorder Point. Also, if the Demand Planning feature is enabled, additional demand planning fields are available for items where the Time Phased replenishment method is used. See Selecting General Ledger Accounts for Item Imports.

After you have completed an import of items for multiple locations, you can use the Transfer Inventory form or Transfer Orders to move inventory among locations as necessary. For information, see Transferring Inventory.

The Location sublist is a keyed sublist, based on Internal ID, External ID, or Location name. Updates of this sublist vary depending on your setting for the Overwrite Sublists option.

Importing Default ATP Method Data

As of 2017.1, you can use the Import Assistant to import default available to promise (ATP) methods when you import inventory items, and you have the Available to Promise feature enabled in your account. For information about the Available to Promise feature, see Available to Promise.

Related Topics

Items Import
Item Record Types that Can Be Imported
Item Sublists Available for Import
Selecting General Ledger Accounts for Item Imports
Importing Demand Planning Data for Items
Importing Matrix Options for Items
Importing Related Items Groups
Importing Pricing Data for Items
Replacing the Bill of Materials Sublist with the CSV File

General Notices