Simplify Non-Stock Item Setup in Acumatica with Import Scenarios

This blog explains how to use Acumatica's import scenario feature to load non-stock items in bulk via the Non-Stock Items form (IN202000). It covers the five non-stock item types, key fields to map, and important considerations around item class changes during import.
James Mallory November 18, 2026
Simplify Non-Stock Item Setup in Acumatica with Import Scenarios

How to Import Non-Stock Items in Acumatica

Quick answer: Acumatica allows users to import non-stock items in bulk using import scenarios mapped to the Non-Stock Items form (IN202000). The process supports five item types, including Non-Stock Item, Service, Labor, Charge, and Expense, and requires careful attention to item class assignments to avoid data conflicts during import.

Manually entering non-stock items one by one is tedious, especially when you are setting up a new Acumatica environment or migrating data from another system. Load templates and import scenarios give you a faster, more reliable path to getting your item catalog ready.

This guide walks through what you need to know before you start, how to structure your import file, and where to watch out for common issues.

What Are Non-Stock Items in Acumatica?

Non-stock items are goods or services that your business sells or purchases but does not track in inventory. Acumatica manages them through the Non-Stock Items form, also known as IN202000.

There are five non-stock item types available:

  • Non-Stock Item: A general item not tracked in inventory, such as a downloadable product or a fee.
  • Service: Labor or work performed for a customer, typically billed by time or project.
  • Labor: Used in manufacturing or project accounting to track internal labor costs.
  • Charge: Miscellaneous charges applied to sales or purchase documents, such as shipping fees or handling costs.
  • Expense: Items used to record reimbursable expenses, such as travel or supplies.

Selecting the correct item type matters. Each type controls which accounts and posting classes are available, so getting this right before import will save you significant cleanup time later.

How to Set Up an Import Scenario for Non-Stock Items

Acumatica’s import scenario feature, found under the Integration menu, lets you map columns in a spreadsheet to fields in IN202000. Here is how to approach it:

Step 1: Export a Template from IN2020PL

Open the Non-Stock Items primary list form (IN2020PL) and make the Sale Unit and Purchase Unit columns visible. Then use the Export to Excel action in the table toolbar to generate a template based on your existing records. This gives you an accurate column structure to work from and reduces the risk of mapping errors.

Step 2: Prepare Your Data File

Populate the exported template with your non-stock item data. Each row should include:

  • Inventory ID
  • Description
  • Item type
  • Item class
  • Unit of measure
  • Sales and purchase account information (will default from the item class)

Keep your data clean. Blank required fields or mismatched values will cause import failures. Import scenarios failures are shown per line.   You must also set up data providers before moving on to the next step.

Step 3: Map the Import Scenario

In the Import Scenarios form (SM206025), create a new scenario and point it to the Non-Stock Items screen (IN202000). You will also need the data provider and its object for importing the data. Map each column in your file to the corresponding field in Acumatica. Pay particular attention to fields that use lookup values, such as item class or unit of measure, since these must exactly match existing records in the system.

Step 4: Run the Import and Review Results

Use the Import by Scenario feature (SM 206036) to upload your file and process the records. Review the import log carefully. Acumatica will flag rows that fail validation, along with the reason for each failure.

Once uploaded, the data file does not need to be uploaded again unless the data has changed. For example, open the Import by Scenario (SM206025) form and select your scenario. If this is your first import, you can use the sample file you already uploaded to the Data Provider (or on the Import Scenarios form), so there is no need to upload it again. For subsequent imports, use a file with the new records. The new file columns must match the structure defined in the Data Provider.

Key Consideration: Item Class Changes During Import

One area that catches many users off guard is item class behavior during import. If you attempt to change the item class for an existing non-stock item through an import, Acumatica may override account settings or reject the change entirely, depending on your configuration.

Best practice is to finalize your item class structure before running a bulk import. If you need to reclassify existing items, you can do that with an import scenario as well: export the current records, update the item class values in the file, and import them back. Afterward, verify the posting accounts on the updated items.

A Smarter Way to Manage Your Item Catalog

Getting your non-stock items set up correctly from the start makes everything downstream easier, from order processing to financial reporting. Acumatica’s import scenario toolset is designed to support exactly that kind of efficient, accurate setup.

Frequently Asked Questions

Can I import all five non-stock item types in a single file?
Yes. You can include all five item types in one import file, as long as the item type column is correctly populated for each row and the corresponding item classes are already set up in your system.

What happens if I leave the item class field blank during import?
It depends on your Inventory Preferences. If a default class is specified in the Default Non-Stock Item Class box on the Inventory Preferences form (IN101000), Acumatica assigns that class to the imported items. Review its settings in advance, particularly the posting class, to make sure the posting accounts are specified correctly.

If no default class is specified, the Item Class field remains empty. In that case, your import scenario must supply every value that would normally come from the item class, such as the posting class, tax category, and the base, sale, and purchase units. As long as all required values are provided, the item can be imported without an item class.

Can I update existing non-stock items using an import scenario?
Yes. If the Inventory ID already exists in the system, Acumatica will update the record rather than create a new one. Be careful when updating fields such as Item Class and units of measure, because changes to them can affect other item settings and future transactions. Test the scenario on a few items first.

Is there a limit to how many records I can import at once?
Acumatica does not enforce a hard row limit for import scenarios, but very large files may affect processing time. For best results, import in batches of a few hundred to a few thousand records, depending on your system configuration.

Where can I find additional help with import scenarios?
Acumatica’s Open University, Community Portal (community.acumatica.com), and Beacon (beacon.acumatica.com) offer free training, documentation, and active forums where users and partners share guidance on import scenarios and data migration.

Blog Author

Categories