cancel
Showing results for 
Search instead for 
Did you mean: 
PR14
Level 2

item code

I upgraded to QB Desktop 2020, and the "Item Code" dropdown now has MPN (Manufacturers Part Number) as one of the columns displayed in the dropdown.  This has the effect of pushing my Item Descriptions in the dropdown so far to the right, I can't read them completely, so can't make a proper selection.

 

How do I eliminate the MPN column in the dropdown?  Is there a way to modify / hide which columns populate a dropdown menu, specifically in this case the "Item Code" dropdown?

7 Comments 7
SashaMC
Moderator

item code

Thank you for joining the QuickBooks Community, PR14. I will be delighted to show you how to eliminate the MPN column and ways to modify/hide other columns. 

 

  1. Go to the List and select Template.
  2. Select the template that you would like to edit.
  3. Use the drop-down arrow under Template, and click Edit Template.
  4. Click the Additional Customization button at the bottom of the screen (highlighted with the number 5).
  5. In the Column section, locate MFR Part Number and under Screen and Print, uncheck the options.
  6. You can customize and add checkmarks to what you would like to see displayed and remove other columns. Select the Print Preview to see a snapshot.
  7. Once finished, select OK twice to save the changes.

 

With this, whenever you use this template for your invoices, the part number columns will be removed and any other edits you made. For more information about customizing your invoices, sales receipts, estimates, statements, and purchase orders with QuickBooks Desktop, use this article to form templates that match your business needs.

 

 

If you have any questions or concerns, I'm a comment or post away. You are always welcomed here if you need any help. Have a great day.

 

PR14
Level 2

item code

Hi thank you, but this isn't correct.

 

The MPN is already unchecked for both in the template.  I am not seeing the MPN on the invoice, that isn't the problem.  It is when you click the dropdown that the MPN field is showing up now.  This happened between versions.

 

This problem manifests itself in the base Intuit Invoice itself, not just the customized invoice template.  This dropdown item list also has the same problem / displays like this in the "Edit Item" screen,  when you select the "Subitem of" dropdown.

 

Am attaching a screenshot so you can see the problem this extra space in the item list dropdown creates, and how it pushes the item description off-screen so you can't see exactly which item to select.

MaryLandT
Moderator

item code

I'm here to help eliminate the MPN column, PR14.

 

The manufacturer's part number (MPN) is now automatically enabled on the latest updates in QuickBooks. However, you have the option to hide this column so it won't take extra space.

 

Let me show you how:

 

  1. Go to the Lists menu, then Item List.
  2. Click the arrow next to the Item button, then choose Customize Columns.
    removempncolumn.PNG
  3. Choose MPN under Chosen Columns, then click Remove.
    removempncolumn1.PNG
  4. Click OK to save the changes.

Check out the Create and use custom fields page to learn how to personalize sales forms in QuickBooks Desktop.

 

Let me know if you need anything else by commenting below. I'm always right here to help ensure you're able to eliminate the MPN column.

BigRedConsulting
Community Champion

item code

Intuit doesn't seem to understand your question.

 

I searched, but I don't see any way to customize drop downs in QB.  It does what it does.

PR14
Level 2

item code

Hi, this is still not right.  Please re-read my question.

 

Also, what is the process to submit a bug report / trouble ticket to QB for a fix?

PR14
Level 2

item code

Hey thanks for the note.  I know -- they are not understanding the question.  I feel like many, many moons ago there were flat files that contained the dropdown list defaults, but I don't see anything like that now by doing a quick search in the program files.  Maybe I am thinking of another program.

 

Anyway, I hope someone discovers a way to do this, because I can't see my description data properly anymore.  I'm sure I could come up with a unique identifier to put in the MPN field as a workaround, but that's a pretty big pain to do by hand, given the number of items.

Nick_M
QuickBooks Team

item code

Hi there, PR14. 

 

Thanks for stopping by the Community, I'm happy to show you how to report any bugs you may be experiencing. You'll have to reach out to our support team and let them know what's happening, that way they can see exactly what this issue is and address the problem, and apply the solution. To reach them, visit the link I'm providing below. 

Thank you for your time and have a nice afternoon. 

Need to get in touch?

Contact us