Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have several account numbers associated with 1 vendor. I am trying to figure out how to enter these account numbers to print on a vendor report WITHOUT having to enter the vendor 5 times for 1 account number each. Anyone have any ideas?? I thought I could just add them under "additional info" as a NOTE to print but...nope. Any thoughts?
Let me add some information about running a report for your vendor, Plink.
Are you trying to run a report that will give you the vendor and account number information? If so, what specific report are you trying to generate?
Generally, once you've already entered and saved a vendor name in QuickBooks Desktop the information will remain. You may need to re-enter the same vendor, however, you'll have the option to select the name automatically on the field as the information was already saved without having you type all the words or letters again.
You'll want to export reports to excel and enter additional information from there such as account numbers by copying and pasting. To do this, follow the steps below:
If you are using a newer version of MS Excel and the exported report does not show header information, go to the Printing options section and make sure the On Printed report and screen option is selected.
For more information on what else you can import or export using MS Excel files, please read the article for detailed steps and information.
If there's anything else that you want us to help you with running reports, please let me know so I can get back to you. Stay Safe!
I appreciate the response and am familiar w/ your instructions but allow me clarify;
I have several accounts for 1 vendor. I don't want to have to enter the vendor 6 times for each account, seems ridiculously redundant. What I am trying to find out is if there is a way I can enter all 6 accounts numbers (separating them w/ a colon, semi-colon, whatever....just to account for every account number w/ said vendor) into a particular field and be able to choose this field to print on the report without having to export into Excel. The method you describe, if I understand correctly, would mean every time I need to print said report and export it to excel (if I had to), I would have to manually enter each account # every time? I can't put the account numbers into the NOTE field because what if there is more than 1 note? (Provided I could even access this field to print via customizing the report), and there is no "note" area in the ADDITIONAL INFO tab when entering a new vendor. It truly just seems ridiculous to have to enter a vendor 6 times to account for each account number w/ said vendor. We are property management company and several of our properties have several buildings at 1 locations, thus, every building has its own set of account numbers but just 1 vendor. Just looking for a way to enter ALL account numbers under the 1 vendor to which they apply. Thanks
Good morning, @Plink.
Thanks for reaching back out to the Community. Allow me to give you some information about vendors with multiple account numbers.
The details that my colleague provided is the only way to associate all of the account numbers to one vendor. However, I'll send feedback to our Product Developers so they can consider this in one of the upcoming releases. They regularly review customer-submitted feedback and tries to collaborate them into the next available update for the product.
Cruise on over to our QuickBooks Blog to keep up with what's new in the product. We try to improve our system to help every user of QuickBooks.
Let me know if you have any other feedback about our system. I want to ensure that you're able to get back to running your business as soon as possible. Should you need any further assistance, feel free to ask. I'm always here to lend a helping hand. Have a great day!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here