cancel
Showing results for 
Search instead for 
Did you mean: 
matt61
Level 1

I'a trying to import inventory items via an Excel file. I reciever "Unit of Measure is Currenty turned off and the mapping you selected was created..." Tried new mapping.

 
7 Comments
AlexV
QuickBooks Team

I'a trying to import inventory items via an Excel file. I reciever "Unit of Measure is Currenty turned off and the mapping you selected was created..." Tried new mapping.

I'm here to help, matt61.

 

We can turn on your unit of measure (U/M). You can follow these steps:

  1. Go to the Edit menu and select Preferences.
  2. Select Items & Inventory tab, then go to Company Preferences.
  3. In the Unit of Measure section, click on Enable. Click OK to save.

Once done, let's import your inventory item once again.

 

You can also read this guide about the usage of single and multiple units of measure for items.

 

Comment below if you have clarifications.

matt61
Level 1

I'a trying to import inventory items via an Excel file. I reciever "Unit of Measure is Currenty turned off and the mapping you selected was created..." Tried new mapping.

Thank you for your reply. The option to turn on the unit of measure is not available. It is greyed out. See attached.

 

I also tried to recreate the import mapping with no success.

 

Matthew

matt61
Level 1

I'a trying to import inventory items via an Excel file. I reciever "Unit of Measure is Currenty turned off and the mapping you selected was created..." Tried new mapping.

Thank you for your reply. I am unable to turn on the unit of measure. The option is greyed out. See attached.

 

MatthewUnit of measure.jpg

Rasa-LilaM
QuickBooks Team

I'a trying to import inventory items via an Excel file. I reciever "Unit of Measure is Currenty turned off and the mapping you selected was created..." Tried new mapping.

Hello again, @matt61.


Thanks for adding a screenshot about your concern and letting us the result of the troubleshooting steps.


There's an open investigation about the error you're experiencing while importing inventory items (INV-37720). Rest assured, our engineers are diligently working to come up with a solution as soon as possible.


While waiting for the permanent fix, contact our Technical Support Team to sign up for the notification list. This way, you’ll receive an email about the resolution status.

 

  1. Let’s go to the Help section of the company file to see the contact details.
  2. Choose QuickBooks Desktop Help to open the Have a Question window.
  3. Hit the Contact us link to see the Contact Us screen.
  4. Tap the Search for something else link and then type the issue in the field box.
  5. Choose Search to display the support information.


As a workaround, let’s go to the Add/Edit Multiple List Entries page to input the items. Here's how:

 

  1. Tap the Lists tab at the top to select Add/Edit Multiple List Entries.
  2. This will display the Add/Edit Multiple List Entries window.
  3. From there, click the List drop-down arrow and select the appropriate option you’re working on.

To continue with the process, I suggest following the recommended steps in this article and perform 5-9: Add and edit multiple customers, vendors, and items.

I’ll keep you in the loop once I hear updates and post them on this thread.


I appreciate your patience while we’re working through this. Reach out to me if you have other concerns or QuickBooks-related questions. I’ll jump right back in to help. Have a good one.

crydul
Level 1

I'a trying to import inventory items via an Excel file. I reciever "Unit of Measure is Currenty turned off and the mapping you selected was created..." Tried new mapping.

I would like to  follow this response.

crydul

Mike Figaro
Level 1

I'a trying to import inventory items via an Excel file. I reciever "Unit of Measure is Currenty turned off and the mapping you selected was created..." Tried new mapping.

I am having the same issue.  It's like a flag in the software is inverted.  When I enable units of measure, it tells me it was created in multiple and I am in single.  When I change it to multiple, it tells me the mapping was created in single.  It is comparing to every case but the current one, which suggests a software bug. Please fix this.

 

Mike

Joesem M
QuickBooks Team

I'a trying to import inventory items via an Excel file. I reciever "Unit of Measure is Currenty turned off and the mapping you selected was created..." Tried new mapping.

Hello there, @Mike Figaro.

 

Thanks for letting me know about this concern. I've got some additional information to share in fixing your concern in QuickBooks.

 

In cases like this, we can go ahead and run the Verify/Rebuild tool in QuickBooks. This helps identify the most commonly known data issues within the file and resolves it.

 

Before we begin with the troubleshooting, let's secure a backup of your company file. Once done, we can proceed to verifying and rebuilding your data in QuickBooks Desktop.

 

Here’s how to verify:

  1. Click on File.
  2. Select on Utilities.
  3. Click on Verify Data.
  4. If you see QuickBooks detected no problem with your data, select OK. You may continue using your company file.

 

To rebuild:

  1. Click on File at the top menu bar.
  2. Select on Utilities.
  3. Click on Rebuild Data.
  4. Select OK when you see Rebuild has completed.

 

For detailed information about this, please see this link: Resolve data damage on your company file.

 

Also, I'd highly suggest contacting our Support Team and provide this investigation number INV-37720 so they can add your company details to the list of affected users. Rest assured that our Product Development Team is already investigating the root cause of this unexpected hitch and working to implement a solution and will notify you with updates regarding the status via email.

 

For the support's contact information, you can refer to the steps provided above. If you need to know more about the QuickBooks Desktop support hours type, you can refer to this link: Support hours and types.

 

Also, you can follow the workaround shared by my colleague @Rasa-LilaM on how to input the items in QuickBooks. You can also click this article for more information: Add and edit multiple customers, vendors, and items.

 

You can check this article for more info about single and multiple units of measure for items: Use single and multiple units of measure for items.

 

 

We appreciate your patience as we work through this. Don't hesitate to leave a comment below if you have any other concerns. I'll be around to help. 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us