Custom Field is blank on Unpaid Bills Detail Report

So why is it in the list of fields that can be added to the report if it really does not work?  Seems misleading.  Thanks for the response.

@Jim Culpepper 

"So why is it in the list of fields that can be added to the report if it really does not work?"

Because it Is available on the List report. It's like "Nickname" or "Alt Phone #" in other words.

Are you using Vendor Type for anything else? You didn't describe what you want this field to be doing, reporting, or used for. Vendor Type is an example of how to "tag" something. This would be maintained on a List of its Own; you see the little dropdown arrow, and you see Add New. The Custom Field clearly is freeform text as alpha-numeric, and not really Functional like what you were hoping for.

I wanted to use Vendor Type originally, but I did not see it in the list of fields that could be added to the Unpaid Bills Detail Report.

Hello there, @Jim Culpepper.

Allow me to join this thread and share some insights about the vendor custom fields.

As per qbteachmt, the custom fields are only for the extra information you'd like to assign for the vendor. You can enter free-form text like alpha-numeric. However, this information doesn't reflect on any customized report in QuickBooks.

I already sent your idea to our engineers about this. I also encourage you to pass along your suggestion for consideration for the future updates. That way, they’ll know a lot of customers have the same need for this option.

1. Click the Help menu bar.
2. Scroll down to Send Feedback Online.
3. Select Product Suggestion.
4. Choose Product Suggestion for the Type of Feedback.
5. Product Area is optional.
6. Enter your suggestion.
7. Click Send Feedback.

Thank you for reaching out to us here, and please let me know if there's anything else I can do to help. Have a good one.

@Jim Culpepper 

For this: "I wanted to use Vendor Type originally, but I did not see it in the list of fields that could be added to the Unpaid Bills Detail Report."

Yes, that works fine in Vendor Reports. Then you Filter that report; use the Customization button and then the Filters tab and Filter on Vendor Type = what you want.

Here are the functions:

If you want to show something on a report, you use Customize, then the Display tab, to see what is Available. Not everything here applies to every report; reports can be Transactions as Rows, or Details from transactions as Rows, or Summary rows. Then, top right of the report, you might see a Columns By. Not everything available in the database is available here. You might see a Sort By; you cannot Sort By something you didn't Display, first. And lastly, some "tags" or settings are Filters, not Display or Sort or Columns. Example:

Sales by Customer Summary. Columns by item Type, Filter on Customer Type = only those Customer Name I tagged as being in Idaho.

We tried doing the same thing, we needed to assign vendor ids unique to each vendor for tracking purposes.  We created a field, added the ids and they wouldn't show on any reports.. extremely frustrating!  Why would it be listed in the fields to customize your report, but not really... I have no other place to put the information.  

Hello there, Jessi09,

Allow me to step in and share some information to help you create an effective reports in QuickBooks.

QuickBooks uses a concept called Source and Targets when you create a transaction. And, how it reflect on your reports. See the attached screenshot below to determine concept.

Common vendor and payable reports, such as A/P Aging Summary, Vendor Balance Summary/Detail, Unpaid Bills Report. They display:

• Source data from open item receipts, bills, and bill credits.
• Target data from open bill, payment checks, and open journal entries.

As a workaround, you can enter the vendor ID in the Memo field when you pull up the Unpaid Bills Detail report. This will show up on your statement.
 

Check out the Targets vs. Sources overview to learn more about the concept.

Let me know if you need additional information by commenting below. I'm always right here to help.

Did you type in Vendor ID in Memo manually ?

I have same issue, we created Vendor ID so that we can generate Integrated Payable files for our Bank portal.

This column available in Display section but I am getting no data showing up on freshly created report.  So useless. Please find a way or send full details on how I can bring it up under Advanced Report.

Thanks

Raj

Hello, BRaj. 

Thank you for reaching out to the Community. Yes, you have to type it manually, and we need to make sure we customize the report and mark check the memo so that it will show up in the column upon pulling up the report. 

I have added screenshots for visual reference: 

However, after following the procedure above, and still doesn't resolve the issue. We can perform Verify and Rebuild data. Sometimes, this can happen if the company file in your QuickBooks Desktop is damaged. We can do the Verify and Rebuild Data to identify and fix these issues.  

You can follow the steps in this article: Verify and Rebuild Data.  

Reach out to me anytime if you have any questions. Please know I’m always ready to help. Have a great rest of your day.

Yes, this is frustrating as hell, that the column I need on a transaction report won't show up. I want to know the county that purchased the particular item, but QB, alas, can't do that. So I have to figure out some ridiculously time-consuming work-around.