Question

Closed Sales Order Report

Forum|Forum|4 years ago
January 10, 2022
1 reply
3 views

Looking for a report to pull a record of CLOSED Sales Orders - is this possible? I have QB Enterprise Suite, but a solution for Desktop would be helpful as well.

Thank you

QuickBooks Enterprise Suite

J

JonpriL

Level 9

Hello there, @DanBu!

Let me help share details in generating a report showing a list of closed sales orders.

You can customize one of your transaction list report to pull up a record of sales orders that has been closed already. I'll show the steps on how to accomplish this.

Go to Reports.
Under Customers & Receivables, select Transaction List by Customer.
Select Customize Report.
Choose a report date range based on the sales orders you wanted to view.
On the Filters tab, select Transaction Type, Paid Status, and Posting Status.
- Transaction Type = Sales Orders
- Paid Status = Closed
- Posting Status = Non-posting
Click OK.

Here's an article to read and learn more about customizing a report: Customize Reports in QuickBooks Desktop.

I've also included this reference helpful with the steps needed to identify how stable is your business's financial status: Create and Manage Reports in QuickBooks Desktop.

You can always leave a comment below if you have follow-up questions with this or start a new thread if you have any other concerns. I'll be here to lend a hand. Stay safe!

D

DanBuAuthor

Thank you very much!! We are on the right track, as I can see the list of Sales Orders and it includes the closed Sales Orders - this is something I couldn't get to populate in the past!

I wonder if it is possible to limit the report to only Sales Orders that have been closed, and by date of closure?

We make an inventory transfer from our "Warehouse" to a site called "Trial" along with creating a Sales Order to track items that are "on trial" with a customer. This removes them from available "Warehouse" inventory and connects them to a customer without the transaction hitting our accounts receivable. Then, the customer will either return all items or purchase some and return others.

I would like to capture Closed Sales Orders by date of closure. This would allow me to make sure that the "returned" inventory items from the Sales Order (i.e. those not converted to an invoice) are transferred back to the "Warehouse" site location when the Sales Order is closed.

Is there a way to modify the report to show only Closed Sales Orders by date-of-closure?

Many thanks in advance for your input!!!

RenjolynC

Level 9

Thanks for your prompt reply, DanBu.

In addition to the steps shared by my colleague JonpriL, please add the Detail Level from the Filter tab. Then, select All except summary. This will only show the sales orders with a Closed status.

As for the date, we're unable to add this option. However, you can export the report to Excel by clicking Excel > Create New Worksheet. Then, manually edit the data to include the status and date when the transaction were closed.

Here's a sample screenshot for reference:

You can also find the steps in this link: Export reports as Excel workbooks in QuickBooks Desktop.

To learn more about the reports in QuickBooks Desktop and how you can customize them:

If you have additional questions regarding the report or need help with the other features in your account, please don’t hesitate to let us know in your reply. We’ll be here to assist you. Take care!

Sign up

Login with SSO

Let's get you signed in

Login with SSO