In our business each individual transaction has a code number. We have a section on our invoices and estimates that say "code" and we enter the code there. My question is: Is there a way to do a search for a specific code number? An example of one of our codes would be "1/25 3-65". I've tried the advanced search function but am unable to do the search. I am forced to open and look at each invoice separately to find the code I'm looking for and this is very time consuming.
I’m here to provide some insight on how you can find a transaction using a code in QuickBooks Desktop.
If the Code box is added as a custom field under the customer’s profile, you can search for it using the Find feature. Let me show you how:
Follow the steps below to add Code as a custom field so you can use it to look for an estimate or invoice.
I’m adding a screenshot of what the custom code field looks like in an estimate:
Here's an article that tackles more about this: Use QuickBooks Desktop custom fields.
That should answer your concern for today.
Post again in the Community if you have any questions. I’m more than happy to help. Cheering you to continued success!
Thank you so much for your response! You taught me something new. However, once I followed all of the steps you laid out I was still unable to get the search to work. Code # shows up in the advanced search but when I enter our code number to pull up an invoice it said there were zero matches.
Thank you so much for your response! You taught me something new. However, once I followed all of the steps you laid out I was still unable to get the search to work properly. I can not see the "code" option in the advanced search setting but when I enter our code number it says there are zero matches. Is there something else I need to activate in our invoices or estimates to make the search work?
I’m glad to see you again in the Community, @earamirez2640.
Thank you for trying out the solutions I shared above. Let me add some more information, so you can search for the transactions using a code.
If the code field on your existing invoices and estimates are added the same way as the steps I provided, you should be able to use the Find feature to look for it. If not, make sure to edit each transaction and replace the old code field with the one you recently added.
Here's a screenshot of the result when searching for the estimate using the code:
For more information about these type of transactions, refer to the following articles:
That should get you pointed in the right direction.
Let me know if this works out for you, I’m always ready to help. Take care and have a great day!
Thanks again for responding. There is not a new code box that shows up on our invoices or estimates. We have so many customers I wouldn't have time to move every code over to a new box even if there was one. We have so many invoices and estimates with different codes already listed on them. The only new thing that I've been able to see is the option to search for a code but still when we try to search for codes that we know for certain are our codes . . . there are zero matches found ;(
Your time means a lot to us and I'm here to help you search for all of your transactions.
To start, verifying and rebuilding resolves possible data damage to your company file. You can consider this as the reason why you're unable to search the code of your invoices and estimates.
Let me show you how to verify your data:
Once done, here's how you can rebuild your company file:
This way, QuickBooks identify and resolve possible issues of your company file. From there, you can now successfully search the code of your invoices and estimates.
In addition, here's an article you can read to learn more about the Verify and Rebuild tool: Resolve Data Damage on your Company File.
It'll be always my pleasure to help if you have any other questions. I'm always around ready to help.