How to create a relationship between a sales order and a purchase order

Hello there, Jenny-TMX.

I'll be glad to share what I know about purchase and sale orders.

To help you keep track of the items you promised to customers, you can create a sales order and create a purchase order within the sales transaction.

Here are the steps to turn on Sales Order:

1. Sign in to the QuickBooks company file as Admin.
2. From the QuickBooks Edit menu, select Preferences.
3. On the left pane, choose Sales & Customers then go to the Company Preferences tab.
4. Select the Enable Sales Order checkbox then select OK.

Once the sales order is turned on, you can create a purchase order for all items or selected items.

See this reference to get started with sales orders.

Don't hesitate to comment if you need help creating your transactions. Have a nice day!

Hi Abegail,

Thanks, I understand how to create the purchase order from within the sales order. 

Is there a way to get a report that lists the sales orders and the associated purchase order? I need to be able to look at the open sales orders and quickly find if a purchase order was placed. I also need to know if the purchase order was shipped or confirmed by the supplier. 

Thanks

Greetings, @Jenny-TMX.

You can run and customize the Transaction Details report. I can guide you on how to do it.

1. Go to the Reports tab.
2. Choose Custom Reports.
3. Select Transaction Detail.
4. Click the Customize Report button.
5. In the Display tab, update the report date.
6. On the same page, click Paid from the Columns section.
7. Go to the Filters tab.
8. In the Filter section, click Posting Status then select Either from the options.
9. Click Transaction Type from the Filters, and choose Purchase Order from the Transaction Type drop-down.
10. In the Total By drop-down, select Customer.

This report will show the PO's received or billed. To view open PO's, you can use the Open Purchase Orders by Job. Follow the steps below:

1. Go to the Reports tab.
2. Click Purchases.
3. Choose Open Purchase Orders by Job.
4. Click the Customize Report button.
5. Go to the Display tab.
6. In the Columns section, click Debit and Credit.
7. Click OK.

Also, I've added these articles to help maximize the built-in reports in QuickBooks and how to customize them:

• Understand reports
• Customize reports in QuickBooks Desktop

Let me know if you have other questions or clarifications about QuickBooks or this topic. I'll be right here to help you whenever you need it. Have a lovely day!

Hi,

Thanks for the reply. But the reports you describe do not address my question. 

Maybe the solution is in Advanced Reporting.