Skip to main content

Purchase Order to Purchase Invoice in Business Central: Partial Receiving and How to Cancel the Balance Without Upsetting Your Auditor

In Business Central the purchase cycle produces three separate records. Together they are your three-way match.

Purchase Order
What we agreed to buy
Posted Purchase Receipt
What we actually received
Posted Purchase Invoice
What the vendor billed us

Finance signs off on the invoice because the receipt proves the goods or service arrived, and the order proves the price was agreed beforehand.

This post walks through one full cycle end to end, using a partial delivery, and finishes with the part everyone gets wrong — cancelling the small balance that will never arrive.

The scenario

We are buying a service — a purchase line of type G/L Account rather than a stocked item. This is very common for marketing, printing, subcontract labour and professional fees.

Quantity 100 × RM 25.00 = RM 2,500.00
Delivery happens in stages: 80 first, then 15, and the last 5 are cancelled by mutual agreement.
Order
100
Receipt 1
80
Invoice 1
80
Receipt 2
15
Cancel
5
Invoice 2
15

STEP 1Prepare the purchase order

Search Purchase OrdersNew. Fill the header: Vendor No., Order Date, Expected Receipt Date, and Vendor Order No. if the vendor gave you their own reference.

On the line: Quantity = 100 and Direct Unit Cost = 25.00. Set your dimensions here, not later — dimensions flow from the order to the receipt and the invoice.

Once the PO is approved and the approval workflow is complete, the status changes from Open to Released, which means the order is approved to be received against. Send it to the vendor using Print/Send.

Quantity
100
Received
0
Invoiced
0
Rcd. not inv.
0
Outstanding
100

STEP 2First receiving — 80 units (partial receipt)

The vendor delivers 80 units against their delivery order. Open the purchase order and enter the vendor's DO number in Vendor Shipment No. on the header — this is what ties your posted receipt back to their paperwork.

On the line, set Qty. to Receive = 80. Leave Qty. to Invoice at 0.

Choose Post (F9)Receive.

Business Central creates a Posted Purchase Receipt for 80 and updates the order line:

Quantity
100
Received
80
Invoiced
0
Rcd. not inv.
80
Outstanding
20
A note for finance

Because this is a G/L Account line and not a stocked item, posting the receipt does not create a general ledger entry. The expense hits your P&L only when the invoice posts. Your exposure sits in the Amt. Rcd. Not Invoiced field on the purchase line — RM 2,000 at this point. If the delivery and the invoice fall in different periods, that figure is what your goods-received-not-invoiced accrual should be based on.

Warning — non-item lines

The Undo Receipt action on a posted purchase receipt only works for lines of type Item. On a G/L Account line you will get an error, so there is no one-click reversal — the correction path is to invoice the quantity received and then issue a Purchase Credit Memo. Check the delivery order against Qty. to Receive before you press post, because on service and expense lines that number is much harder to take back.

STEP 3Invoice matching for the first 80

The vendor's invoice arrives for 80 units, RM 2,000. Create it as its own document rather than posting it from the order — one purchase invoice can then cover receipts from several orders.

Create a Purchase Invoice, select the vendor, enter the Vendor Invoice No., then choose Get Receipt Lines and pick the posted receipt. The lines are pulled in at the agreed price with the receipt reference attached.

Before posting, check the invoice total against the vendor document. If the vendor billed a different unit price, fix it here — the variance belongs on the invoice, not hidden in a manual journal.

Quantity
100
Received
80
Invoiced
80
Rcd. not inv.
0
Outstanding
20

STEP 4Second receiving — 15 units

Two weeks later, 15 more arrive. Same routine: update Vendor Shipment No. with the new DO number, set Qty. to Receive = 15, then PostReceive. You now have a second posted purchase receipt sitting beside the first.

Quantity
100
Received
95
Invoiced
80
Rcd. not inv.
15
Outstanding
5

STEP 5Cancel the remaining 5, the audit-friendly way

The vendor tells you the last 5 will not be delivered. Business Central has no "cancel remaining quantity" button — the supported way to close the balance is to reduce the ordered quantity to the quantity you actually received. Done in the right sequence, that leaves a complete trail.

Do it before you post the final invoice. That way the last posting closes the order for you instead of leaving an empty shell in your open order list.

  1. Get the cancellation in writing. An email from the vendor, or your own short-close note, is the evidence. Without it, this is just someone quietly changing a number.
  2. Attach it to the order. Drop the email into the Attachments FactBox on the purchase order, then add a Comment line: "5 units cancelled — vendor unable to supply, confirmed by email 21/08/2026, approved by [name]." Reason, date, approver.
  3. Archive the original. Choose ActionsArchive Document to freeze a copy showing the order at 100 before you change it. View it later under Purchase Order Archives.
  4. Reopen and reduce. Choose Reopen, then change Quantity on the line from 100 to 95. Business Central will not let you go below the quantity already received, which is your safety net. Outstanding Quantity drops to 0. Choose Release again.
  5. Post the final invoice. Enter the Vendor Invoice No., set Qty. to Invoice = 15, and PostInvoice. The order is now fully received and fully invoiced, so Business Central closes it out automatically.
Two switches to turn on first

Set Purchases & Payables SetupArchive Orders to Always, so the order is also archived automatically when it closes, not only when you archive it by hand.

In Change Log Setup, switch on logging for the Purchase Line table, field Quantity. The log only records changes made after you switch it on — so do it now, not the week the auditor arrives.

What the auditor can now reconstruct without asking you a single question: the original commitment of 100 in the archive, two receipts totalling 95, two invoices totalling 95, a quantity change from 100 to 95 in the change log with a name and a timestamp, and the vendor's own confirmation attached to the document.

Final position — order closed
Quantity
95
Received
95
Invoiced
95
Outstanding
0
Total posted: RM 2,375.00

Quick answers

Can I post the invoice before the receipt?
Not from a purchase order. Business Central will not let you invoice more than you have received, so receive first, or use PostReceive and Invoice when both happen on the same day.
I posted the wrong receipt quantity. Now what?
On an item line, use Undo Receipt on the posted purchase receipt. On a G/L Account or other non-item line that action is not available — invoice the quantity received, then reverse it with a Purchase Credit Memo.
Everything is received and invoiced, so why is the order still open?
Because Quantity is still higher than Quantity Received. Reduce the ordered quantity to what you actually received, as in Step 5.
Can I just delete the purchase order instead?
Business Central blocks the delete while there is a received quantity that has not been invoiced, and deleting is a poor habit anyway — you lose the link between the order and what was posted against it. Close the quantity out and let the archive keep the history.

Steps verified on Business Central online, 2026 release wave 1. Field and action names are the same on recent earlier versions.

Comments

Popular posts from this blog

How to Reverse Posted Documents in Business Central

  If you need to amend or change a posted documents in Business Central, there are few ways to do it instead of having you to manually create a reversal journal or Credit Memo to rectify a Posted Document. Before you proceed to Correct or Cancel any document that posted in Business Central, you need to identify the origin of the posted document, as the method of cancellation depends on the document type.   There are 2 types of documents that posted in Business Central. i.                      Journals – E.g., General Journals, Purchase Journals, Payment Journals, Sales Journals, Receipt Journals etc. ii.                    Documents – E.g., Purchase Invoice, Purchase Credit Memo, Sales Invoice, Sales Credit Memo etc.   A.       A.     C orrecting ...

Foreign Currency Revaluation in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central (BC) allow users to account for foreign currency transactions. BC also able to translate the registered foreign currency amount into functional currency that setup in the entity using the conversion rates which setup in Exchange Table.   Due to the exchange rates fluctuate constantly, as a dollar worth in foreign currency today might not equivalent to the same foreign currency worth the next day. Hence, users are required to adjust the open documents that transact in foreign currency which include open invoices, credit memos, and advance payments. Once the open documents transacted in foreign currency is revalued, the gain and loss which calculate after comparing the closing rates at the period end will be posted to profit and loss as unrealised gain and loss, ensuring that the subledgers and general ledger can be reconciled.   This process can be done using Adjust Exchange Rate in BC, a batch job to adjust the exchange rates fo...

How to Consolidate Customer and Vendor Balances in Business Central

Understand that some customer of the company might be the vendor of the company too. There is a feature in Business Central that allows users to consolidate both customer and vendor balances without making unnecessary payment or receipts. Prerequisite Setup for Customer and Vendor Consolidation Page: Marketing Setup           1.        Setup a Business Relation Code for each Customers and Vendors.          2 .        Assign a number series under Contact Nos. A number will be pickup from the number series when there is a new Contact code created. To Link the Relation between Customer Card and Vendor Card 1.        Go to Customer Card, look for the customer that you need to link in Customer Contact. 2.        Confirm the Customer Name that you have selected. 3.        Link with the C...