Question

Import max quantity for items

Forum|Forum|6 years ago
December 22, 2019
2 replies
2 views

Quickbooks Desktop Enterprise 19.

Why can't we import the max quantity? I need to have min and max set on thousands of items. I have the info in a spreadsheet. I can import the min, but cannot import the max. We want to use the Auto PO procedure, but cannot until this is done.

I looked into "edit multiple list items" - which requires all items to be in the exact same order in QB and my spreadsheet. I guess this is how I'll have to do it, but it's scary because what if ONE item is missing from my spreadsheet? Then the entire copy/paste will mess up lots of items.

The max number should be importable.

S

SarahannC

Level 9

Hello, KathyS. Thanks for providing further information about your concern.

I have another way that you might consider doing when copy/paste, we can do it by batch.

This way, we can avoid missing items from the spreadsheet. For example, you copy 1 to 15 items from the spreadsheet and paste it to QuickBooks. The next one is 16 to 30 items.

I'll make sure to forward your suggestion to our product developers since we're unable to import max quantity for items. This might be given a chance to be included in the next product release.

Also, if you haven't turn on the Advance Inventory feature yet, you can follow the steps below steps on how to turn this on:

Select Preferences from the Edit menu.
Choose Items & Inventory from the left pane.
Go to the Company Preferences tab. Check the Inventory and Purchase Orders are Active box.
Hover the Advanced Inventory Settings.

Please check this article to get the detailed steps and further information about this feature: Turn on Advanced Inventory.

Let me know how it goes. I'm always here if you have other questions. I hope you're well today.

K

KathySAuthor

Inventory and Purchase Orders are Active was already checked.

What is the purpose of "Hover Advanced Inventory Settings" ? If it's just to determine if it's grayed out, it's not. Is there a setting I need to change there?

IamjuViel

Level 8

Let me share additional information, @KathyS.

When importing your inventory items, make sure to scroll to the right direction so you'll be able to see the rest of the import columns. From here, you can copy and paste the Maximum quantity for each item you're about to import.

You can read through these articles to learn more about importing items in QuickBooks: Import or export MS Excel files.

If you're still having the same result, let's run the Verify and Rebuild data utility tool. This will isolate, repair, and notify you of data damage within your QuickBooks company file.

Here's how:

Go to the File menu.
Choose Utilities.
Select Verify Data.

Once completed, you'll receive any of the following prompts:

"QuickBooks detected no problems with your data," no further action is needed.
A specific error message, there may already be an article for it.
"Your data has lost integrity," indicates there is data damage in the file. Continue to the steps below to Rebuild Data to correct the problem.

To rebuild your data, here's how:

Go to the File menu.
Choose Utilities.
Select Rebuild Data on the drop-down.
Choose OK. Follow the prompts to save a backup.
Click OK when you see Rebuild has completed.
Now, go back to File, then Utilities and select Verify Data one more time.

You can check this article to learn more about resolving possible data issues in QuickBooks: Verify and Rebuild Data in QuickBooks Desktop.

Feel free to leave your comments below if you have other questions. I'm always here to help.

9

940alex

Waiting on this solution as well.

Have you had figured out an efficient work around?

Thanks

K

KathySAuthor

No. I'm still unable to use Auto POs because I cannot fix this issue. Copy/paste THOUSANDS of items is too scary.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded