Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowForgive me if this is the wrong place to ask this. But I am having a problem importing my inventory items into Quickbooks Pro Desktop 2020.
I am using the Advanced Import feature and have items in an Excel file. I have the mapping set up correctly. I have some Non Inventory Parts that imported fine from my spreadsheet. When I imported those items I did not specify mappings for the Asset, COGS or Sales accounts. But when I try and import Inventory parts, I get an error log saying that I must specify the Asset, COGS and Sales accounts. Once I specify those columns in the mapping, and I click Import, I get the error "Unit of Measure is currently turned off, and the mapping you selected was created when Unit of Measure was turned on".
In Inventory Preferences, the UOM option is grayed out and to my knowledge was never available.
Quickbooks support was unable to answer. All they did was sent me info I already read about how to import items.
Anyone have this problem? I'm not going to re-type 1,200 items.
Solved! Go to Solution.