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

The min quantity must be less than the max quantity in Quickbooks Pro 2017. How do I set the max field?

 
Solved
Best answer December 12, 2018

Best Answers
JanyRoseB
QuickBooks Team

The min quantity must be less than the max quantity in Quickbooks Pro 2017. How do I set the max field?

Hi there, jjm10.

 

Good to see you here in QuickBooks Community. It's my priority to guide you on how to set the maximum field in QuickBooks Desktop. 

 

Are you trying to adjust the Max Quantity box for your inventory item? If so, there are two options on how to do this in QuickBooks. First, you can make the adjustment in the Inventory Information

 

Second option, you can visit the Add/Edit Multiple List Entries. Let me walk you through the process: 

 

  1. Go to List at the top menu bar, then select Add/Edit Multiple List Entries.
  2. Choose Inventory Parts from the List drop-down.
  3. Click the Customize Columns tab.
  4. Highlight Max in the Available Columns options and click Add.
  5. Click Ok
  6. Once done, you can manually change the amount on the Max column.

For additional reference you can check this article: Create, build, and work with inventory assembly items.

 

If you need further assistance with the steps, you can contact our QuickBooks Desktop Support Team. They have additional tools to pull up your account in a secure environment and do a remote session. 

 

Here's how you can contact our support: 

  1. Click this link: https://quickbooks.intuit.com/community/Getting-Started/Contact-QuickBooks-Desktop-support/m-p/18603....
  2. Select the version of QuickBooks, click Contact Us.
  3. Type-in Technical Support on the search bar.
  4. Click Get the Phone number below.

This will get you on the right track! Don't hesitate to leave a comment below if you have any other questions about inventory. I'm always here to help you out. 

View solution in original post

6 Comments
JanyRoseB
QuickBooks Team

The min quantity must be less than the max quantity in Quickbooks Pro 2017. How do I set the max field?

Hi there, jjm10.

 

Good to see you here in QuickBooks Community. It's my priority to guide you on how to set the maximum field in QuickBooks Desktop. 

 

Are you trying to adjust the Max Quantity box for your inventory item? If so, there are two options on how to do this in QuickBooks. First, you can make the adjustment in the Inventory Information

 

Second option, you can visit the Add/Edit Multiple List Entries. Let me walk you through the process: 

 

  1. Go to List at the top menu bar, then select Add/Edit Multiple List Entries.
  2. Choose Inventory Parts from the List drop-down.
  3. Click the Customize Columns tab.
  4. Highlight Max in the Available Columns options and click Add.
  5. Click Ok
  6. Once done, you can manually change the amount on the Max column.

For additional reference you can check this article: Create, build, and work with inventory assembly items.

 

If you need further assistance with the steps, you can contact our QuickBooks Desktop Support Team. They have additional tools to pull up your account in a secure environment and do a remote session. 

 

Here's how you can contact our support: 

  1. Click this link: https://quickbooks.intuit.com/community/Getting-Started/Contact-QuickBooks-Desktop-support/m-p/18603....
  2. Select the version of QuickBooks, click Contact Us.
  3. Type-in Technical Support on the search bar.
  4. Click Get the Phone number below.

This will get you on the right track! Don't hesitate to leave a comment below if you have any other questions about inventory. I'm always here to help you out. 

View solution in original post

Bill Lee
Level 1

The min quantity must be less than the max quantity in Quickbooks Pro 2017. How do I set the max field?

Hello,

I am using Enterprise 21.0 and wanted to use the advanced import or multiple Add/Edit list entries to update MAX quantity but I am not able to find the "MAX" in the customized column or in the import mapping. I am having the same issue when importing the 'reorder point' which the min quantity must be less than the max quantity. I can't enter the max quantity one by one for thousands of items. Please advise.  

Bill Lee 1
Level 1

The min quantity must be less than the max quantity in Quickbooks Pro 2017. How do I set the max field?

I am using Enterprise 21.0 and wanted to use the advanced import or multiple Add/Edit list entries to update MAX quantity but I am not able to find the "MAX" in the customized column or in the import mapping. I am having the same issue when importing the 'reorder point' which the min quantity must be less than the max quantity. I can't enter the max quantity one by one for thousands of items. Please advise.  

Jen_D
Moderator

The min quantity must be less than the max quantity in Quickbooks Pro 2017. How do I set the max field?

Thanks for posting here again, @Bill Lee 1,

 

Have you added this item already in QuickBooks? It looks like the quantity you're importing is more that what it set in the item.

 

You will need to edit the Max field on the Item List. See this:

 

For the complete process of the Advance Import, see this link: Import or export MS Excel files

 

Otherwise, you can use another option to import the data. Here's how:

 

  1. Go to the File menu then Utilities.
  2. Pick Import then IIF Files.
  3. Use the Import it for me. I'll fix it later link at the bottom.
  4. Once done, press Import IIF.

 

Kindly update me on how it goes. I want to make sure you're able to update your items in QuickBooks. Have a good one!

Bill Lee 1
Level 1

The min quantity must be less than the max quantity in Quickbooks Pro 2017. How do I set the max field?

Thanks Jen. I know I need to enter value to MAX field before I can set the reorder point qty but the problem is the Max column is neither in the "Add/Edit multiple list entries" nor in the mapping of the advanced import with formatted excel. 

I wanted to use Excel import to map and update the MAX column for all the inventory items or at least to use the "Add/Edit multiple list entries".

It is too much job to open every individual inventory item to enter the MAX field for thousands of items. Please advise where can I find that "MAX" column in the mapping of the advanced import and in the Add/Edit multiple list entries

Thank you for your help

ChristieAnn
QuickBooks Team

The min quantity must be less than the max quantity in Quickbooks Pro 2017. How do I set the max field?

Hi there, Bill Lee 1.

 

Thank you for coming back here to QuickBooks Community to provide additional information regarding your concern about the inventory items.

 

Currently, there's no option to add the Max column when using Advanced import and in the Add/Edit multiple list page. For now, you can manually add or enter the Max details per item as mentioned by my colleague above.

 

I can see how necessary the said feature can help your business needs. For now, I suggest visiting our QuickBooks Firm of the Future blog to know about the latest news and updates from QuickBooks Desktop.

 

To see additional information on how importing CustomerVendorItems, and Chart of Accounts from an Excel spreadsheet works in QBDT, you can refer to this article: Import or export MS Excel files.

 

Please refer to this article to see steps on how you can use IIF files to import and export your lists and transactions to and from QuickBooks Desktop: Export, import, and edit IIF files.

 

Please know that I'm always around to help with any QuickBooks concern. Just get back to this page. Have a good one.

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