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

open sales order report by item detail export Excel item# and item description become combined field

When I  create an "open sales order report by item detail"  and export to  Excel the item# and description combine into one field i.e item#(description). I need to export to Excel a field with only the item#. I don't need the description.

5 Comments 5
Jen_D
Moderator

open sales order report by item detail export Excel item# and item description become combined field

It's nice to see you here, @PDG610,

 

I can guide you with the steps on how to customize a report in QuickBooks before exporting it to Excel.

 

You will need to exclude the Item Description from the report so it doesn't export in the worksheet. Follow the steps below:

 

  1. On the Open Sales Orders by Item report, click on Customize Report.
  2. Under the Display tab, head to the Columns section.
  3. Make sure to remove the check mark for Item Description so it doesn't display on the report.
  4. Once done, press OK.

 

Please note that the report will get the item information from the item list. If the item number and name is added under one field, this will likely to show as combined when you export them. See this as an example:
 

Item List:

 

Report:

 

In this case, you will need to edit the item manually under Lists > Item List, or directly in Excel.

 

I'm also adding some related articles to help you learn more about the reports in QuickBooks:

Let me know if need additional assistance with this or have other questions with QuickBooks. I'll be right here to help. Have a lovely day!

PDG610
Level 1

open sales order report by item detail export Excel item# and item description become combined field

In the open sales report the  item number and the description are combined into one field and thus did export combined. It looks like if I should directly  edit the item manually under Lists > Item List this is linked to the sales description in the parts Lists. Therefore, if I did edit to remove the description in the List section  then the sales description would not show up on the invoice when I bill which is unacceptable. True? There are too many records to directly edit in Excel a report every day.

 

I need to get only the item# onto an Excel report. In the parts record  I have the “Manufacturers Part Number” field available but I cannot get that field to display on an “Open Sales by Item Report” and I have the same problem using a defined field.

MadelynC
Moderator

open sales order report by item detail export Excel item# and item description become combined field

I have a way here, @PDG610.


You may consider adding a separate Item Number column on your Excel. You can sort the entries into alphabetical order or by dates to avoid missed details. Then copy the number from the combined item and description column. 


Once copied, you can remove the combined column on your Excel report. This way, the item number will only remain. Doing this won’t affect your transactions in the program.

Capture.PNG

Capture 1.PNG

 

There are several elements that you can modify. However, it varies depending on the report you run. Available columns and filters differ for each report or group because each draws information from the company file differently.


You can check this article here about customizing reports in QuickBooks Desktop. It includes resources that contain basic information about reports. 


Let us know if you need something else besides accessing detail on the report. We’ll be here to help you further.

Shocky2021
Level 1

open sales order report by item detail export Excel item# and item description become combined field

So You want me to do this manually for 1000 transactions every month? I am sorry, this is not a difficult thing to do on QB end. QB just does not want to. THEY feel we don't need to see it that way.

Sunrise31
Level 1

open sales order report by item detail export Excel item# and item description become combined field

Hello, I see that on the Open Sales Orders by Item you can see the item. However, how come I cannot get the item the customer is going to be purchasing on the Open Sales Orders by Customer? Even when I go to customize report and add that to appear on the report, it does not. 

Need to get in touch?

Contact us