Pulling reports by custom fields

I can share some tips so you can run the report you desire, @rickyspud.

You can run a report and use your created custom field. Please refer to the steps below. If you're using the QuickBooks Online, here's how to use custom fields in the report:

1. Go to the Reports menu and open the report you want to run.
2. Click the Customize button.
3. From the Filter option, select the custom field you've created. 
4. Click Run report. 

If you're using QuickBooks Desktop, you have the option to create a new Custom Transaction Detail Report and customize it to display the custom fields that you have created. Here's how:

1. Go to the Reports menu and choose Custom Reports, then Transaction detail.
2. You'll see the Modify Report window.
3. Go to the Columns field and pick the custom field you have created.
4. You also have the option to filter out the report so this will only show the item you need. Just go to the Filters tab. 
5. Select OK when done.

You can also export the report to excel with the data you need and paste them into one spreadsheet. Before doing so, just make sure to filter first the data from your QuickBooks account. 

Let me know how this goes and post a reply below. I'm always here to help you. Have a good one. 

I appreciate your quick response!

After review, the custom field may just be a base QB field that we use. It's called "tracking number", and it doesn't show in the filters for Sales by Product/Service Summary when I pull the report, see attached screenshot.

Thanks for sharing a screenshot of the Filter section in your reports, rickyspud.

Can you also tell us how the Tracking Number data is entered in your sales transactions? Can you also share a screenshot of a transaction that has a field for Tracking Number?

Some of the most commonly used base fields are Date, Number, Memo/Description, Qty, Sales Price, Amount, and Class. They're normally listed under the Columns section when customizing a report. 

However, most of the summary reports, including the Sales by Product/Service Summary, does not have an option to add or remove columns. You'll want to use the Sales by Product/Service Detail report instead. It has more data compared to the summary report and gives you more option when customizing it. Just go back to the Reports menu and type in the name of the report in the Search bar. 

I'd also like to share these articles with you for additional guidance: 

• Customize Reports In QuickBooks Online
• Common Custom Reports In QuickBooks Online
• Customize And Modify Columns On Reports

Please don't hesitate to reply again if you want to share more screenshot. We'd want to make sure that we're able to sort this out. 

Yes, but this is too much data. My sales reps need to have quick access to data that is relevant to them. When I add the tracking number field to the columns, it still doesn't show up as a filter that I can use. Here is another screenshot of how we use tracking number:

This report would be great, but only if we could fine-tune it by the Project Code/Tracking Number.

Thanks for updating this thread, @rickyspud. 

Let's have you run the Sales by Product/Service Detail Report in the same way.  This is a more detailed version of the previous report and should allow for you to filter by  Project Code/Tracking Number.

I'd love to hear how this goes! I look forward to hearing from you. 

Still no option to filter by Tracking Number in the Product/Service Detail, see attached screenshot.

I even added Tracking Number to the columns, but to no avail.

Welcome back, @rickyspud.

You can select Tracking Number from the Group by drop-down when running the Sales by Product/Service Detail report. This way, you can view transactions by tracking number. Here's how:

1. Run the Sales by Product/Service Detail report.
2. Set the reporting period you want to view.
3. In the Group by drop-down, select Tracking Number.
4. Click Run report.
5. Once done, you can now see the transactions filtered by tracking number.

However, if you don't see the option to group the tracking number, the same as filtering it, let's try logging in to your QuickBooks Online (QBO) account using a private or a different browser. This way, we can check if it's a browser data issue.

If this works, it means that you need to clear the browser's cache so the system can start fresh. 

If you get the same result, I suggest contacting our QuickBooks Support Team. They can further check on this matter and provide additional troubleshooting to get this resolved.

You might want to learn more about customizing reports in QuickBooks Online, feel free to check out this article: Customize reports in QuickBooks Online.

Please know that I'm just a reply away if you need any further assistance customizing reports. I'll be sure to get back to you.

Cleared my browsing history, and it still is not showing up in Group by after I added the column. I'll reach out to QB Support. I appreciate the prompt responses though, thank you.

Just got off the phone with QB Support, and they weren't able to troubleshoot the issue. Really would be nice to filter the Sales by Product/Service Detail by the tracking number, but it doesn't seem to be possible at the moment.

Are there any updates on this situation? We really would appreciate an update on this topic, as it is vital to the success and record-keeping of our sales reps.