cancel
Showing results for 
Search instead for 
Did you mean: 
Jenny-TMX
Level 2

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

Hi,

Some of the products we sell are custom orders. When this happens we need to send purchase order to the manufacturer for the custom order.  I need to be able to easily find the relationship between the sales order and the purchase order for tracking purposes. 

Does anyone have a recommendation on how to accomplish this? At the moment I use the memo field of the purchase order, but this method is not efficient. Any recommendations?

 

Thanks

Solved
Best answer March 31, 2021

Best Answers
AbegailS_
QuickBooks Team

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

Hello there, Jenny-TMX. 

 

Yes, advance reporting can help you find your purchase order quickly.

 

QuickBooks Advanced Reporting is a feature that lets you create customized reports. You can use your QuickBooks data to build your own report based on your specific needs. This lets you see how you’re doing with your business.

 

Check on this article to learn more about QuickBooks Advanced Reporting (QBAR) FAQ.

 

I also added this article on how install and use QuickBooks Advanced Reporting.

 

 If you have any other questions or need further help with this topic, feel free to comment. Have a nice day.

 

View solution in original post

5 Comments 5
AbegailS_
QuickBooks Team

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!

 

Jenny-TMX
Level 2

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

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

IamjuViel
QuickBooks Team

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

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:

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!

Jenny-TMX
Level 2

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

Hi,

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

Maybe the solution is in Advanced Reporting.

AbegailS_
QuickBooks Team

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

Hello there, Jenny-TMX. 

 

Yes, advance reporting can help you find your purchase order quickly.

 

QuickBooks Advanced Reporting is a feature that lets you create customized reports. You can use your QuickBooks data to build your own report based on your specific needs. This lets you see how you’re doing with your business.

 

Check on this article to learn more about QuickBooks Advanced Reporting (QBAR) FAQ.

 

I also added this article on how install and use QuickBooks Advanced Reporting.

 

 If you have any other questions or need further help with this topic, feel free to comment. Have a nice day.

 

View solution in original post

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up