Skip to main content
March 3, 2023
Question

How to receive multi PO, but invoiced partial can be mixed from PO

  • March 3, 2023
  • 1 reply
  • 0 views

So basically I have over 200 SKUs and I place PO for items different PO and etc. when customer buys then I’ll be invoice that day, for items, but the items are spread across multiple PO. How I reconcile or close the PO once it’s completely paid

1 reply

March 3, 2023

Hello, nitsujayyy.

 

I'm chiming in to help you manage those multiple purchase orders, and ensure they are reconciled or closed. 

 

A purchase order is closed or reconciled once a bill (or an item receipt) is raised for the items ordered. I also take it that you're referring to a customer invoice. It won't actually affect the PO, regardless if the invoice is paid or not. 

 

With that said, the process to close or reconcile your purchase orders starts with a bill (or an item receipt followed by a bill). 

 

If those multiple purchase orders are recorded under a single vendor, then let's raise a bill from them:

 

  1. Click on the Vendors menu, then select Enter Bills
  2. Select the vendor's profile under VENDOR. If there's an open PO under the vendor, QuickBooks will automatically prompt you. Hit Yes to attach the POs to the bill. 
  3. Check the PO, then click OK.

 

 

This is just a matter of adjusting what the customer ordered. So, we'll want to delete the items they didn't order, then adjust the quantity if needed. 

 

Under the CUSTOMER:JOB column, attach the customer's profile, then check the Billable column. This allows us to copy the contents of the bill to the customer's invoice (when we raise it). 

 

 

Although, if those purchase orders are recorded under different vendor profiles, then we'll want to raise multiple bills for them. A single bill can only accommodate one vendor.

 

Let's just make sure to attach the customer's profile under the CUSTOMER:JOB column, then mark them as billable. Doing this would allow us to create only one single invoice. 

 

After raising the bills from those POs, they would either be closed (with a check mark under CLOSED) or have their quantities adjusted automatically (received quantities are indicated under RCV'D column).

 

If all quantities were copied to the bill, then the purchase order would be marked as Received in full

 

 

More details about purchase orders are highlighted here: Create purchase orders in QuickBooks Desktop.

 

If you need to track these transactions, we can run some reports in QuickBooks. Take a look at this article if you need help in the future: Understand reports

 

If you have more questions about managing your purchase orders, let me know and I'll gladly help you out. If you need help with something else like your sales entries or reports, include the details in your reply. Always here to assist. 

March 3, 2023

Let me read it a bit but basically it’s like this. I also have integration with Shopify. So let’s say this. I would purchase inventory from vendor. It will be open or closed whatever it is to receive it. When I have my customer who buys inventory can be 1 cases or whatever I let my vendor know and they’ll invoice me. Example

 

PO1

product A 500 cases

PO2

product B and C 300 cases

 

customer placed 1x A and 2x B 5x C. So I tell my vendor that these items sold and vendor will invoice these. But how can I link the invoices appropriately to PO open/close to deduct total balance. Eventually when customer buys it will eventually close out. So I’m my inventory I’ll have A 499, B 298 cases, C 295 cases left. The open PO balance will deduct accordingly