Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHi there,
On a weekly basis I am having to run a report for 1 customer that shows all of the current Sales Orders. I then export that to excel, sort it by due date, go into QB, select Create Invoice. select the customer and manually go through the list of all sales orders and check off each Sales Order number that is due that week which I found on the excel spread sheet.
Is there a way to do this all in QB? For example, view all Sales Orders for a customer, sort by due date, select the ones with the specific due date, and it create one Invoice for all that I have checked?
Thanks!
Good afternoon, @cmcquillan.
Congrats on making your first post here in the Community! I can show you some different ways to get the results you want.
There are two ways that you can pull the data:
2. Open the Sales Order by Customer report and customize it to show all open sales orders. Visuals below:
Picture 1
Picture 2
In addition, when creating an invoice, on the right-hand side it shows if there are any Sales Orders that need to be invoiced.
I hope this helps. Feel free to come back if you have any further questions about the information I provided. Bye for now!
Thank you for your help!
Both of those options allowed me to add columns and filter to find what I was looking for but then there is no way to then easily bulk select the sales orders and create an invoice from there correct? That is the part I am struggling to do.
Thanks,
Chiming in on this conversation to further assist you and share additional information, @cmcquillan.
The ability to select multiple Sales Orders and generate a single Invoice in QuickBooks Desktop is currently unavailable. Although it may seem logical to have this functionality in the Customer Center or on the Report page, where all the Sales Orders for a particular customer are displayed, the mentioned menus are designed for information viewing purposes only.
You can alternatively select multiple Sales Orders into one Invoice by directly going to the Invoice page. I'd be glad to narrow down these steps:
Note that this process is only applicable if the Sales Orders are for the same customer.
Additionally, since you've been dealing with invoices in most of your business activities, here's an article that'll guide you in case you'd want to personalize their appearance by including necessary fields only for better business communication: Use and customize form templates in QuickBooks Desktop.
Thank you for choosing QuickBooks Desktop for managing your sales orders and invoices. We're here to help you every step of the way. If you have any additional questions or need further assistance, please don't hesitate to hit on the Reply button. Our dedicated team is ready to provide the support you need to ensure your business management experience is seamless.
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