15.1 Purchase Orders, Receiving, Over-Receipt & Undo

15.1 Purchase Orders, Receiving, Over-Receipt & Undo

Quick Summary: In Microsoft Dynamics 365 Business Central, procurement execution begins with Purchase Quotes and Purchase Orders (Table 38 Purchase Header, Table 39 Purchase Line). When physical goods arrive at a facility, posting a Receipt updates physical inventory in Item Ledger Entries (Table 32) and accrues interim liabilities in Value Entries (Table 5802). To accommodate supplier packaging variances, Over-Receipt Codes (Page 8000) allow receiving quantities exceeding original purchase commitments within defined tolerance thresholds. If errors occur, the Undo Receipt function reverses posted receipts by generating negative corrective entries and reopening the purchase order, provided the received stock has not been consumed or invoiced.

---

Purchase Quote Lifecycle & Order Conversion

A Purchase Quote (Alt+Q -> type Purchase Quotes, Page 49 / Table 38 with Document Type = Quote) serves as a preliminary document used to request bids, solicit pricing, and negotiate terms with vendors. Quotes have zero impact on physical inventory availability, item reservations, or general ledger accounts.

Purchase Quote to Order Conversion Workflow:

[Vendor Request / RFQ]
         │
         ▼
[Purchase Quote (Page 49)] ──► Set Prices, Quantities, Vendor Quote No., Expected Receipt Date
         │
         ├──► Send by Email (PDF Vendor Quotation)
         │
         ├──► Archive Quote (Manual action or automatic via Purchases & Payables Setup)
         │
         ▼
   "Make Order" Action (Codeunit 96 Purch.-Quote to Order)
         │
         ▼
[Purchase Order (Page 50)] ──► Retains original line details, dimensions, and quote references

Converting Quotes to Purchase Orders

When terms are finalized, selecting the Make Order action executes Codeunit 96 (Purch.-Quote to Order):

1. A new Purchase Order is created, transferring vendor details, line items, pricing, discounts, and dimension sets.
2. In Purchases & Payables Setup (Alt+Q -> type Purchases & Payables Setup, Page 460), the Archive Quotes field dictates retention: setting this to Always or Question ensures an immutable snapshot is preserved in the Purchase Quote Archives before the active quote is deleted.

---

Purchase Order Architecture: Headers & Lines

A Purchase Order (Alt+Q -> type Purchase Orders, Page 50 / Table 38 with Document Type = Order) is the operational document for managing inbound goods, services, and vendor commitments.

Document Header Structure

The purchase header establishes commercial terms across four primary FastTabs:

• General: Captures Buy-from Vendor No., Vendor Order No., Posting Date (financial ledger date), Document Date (calculates payment due dates), Order Date, and Purchaser Code.
• Invoice Details: Contains Pay-to Vendor No. (if billing differs from purchasing vendor), Payment Terms Code, Payment Due Date, Currency Code, and Tax Area / VAT Bus. Posting Group.
• Shipping and Payment: Defines Location Code (destination warehouse), Ship-to Address, Expected Receipt Date, and Inbound Whse. Handling Time.

Purchase Line Types

Each purchase line defines a specific transaction category via the Type field:

Operational Line Quantity Fields

Precision tracking across the procurement lifecycle relies on dynamic quantity fields:

• Quantity: Total units ordered from the vendor.
• Qty. to Receive: Units expected in the upcoming physical delivery (defaults to Outstanding Quantity).
• Quantity Received: Historical units already posted via purchase receipts.
• Qty. to Invoice: Units ready for financial voucher matching (defaults to Quantity Received - Quantity Invoiced).
• Quantity Invoiced: Historical units already matched to posted vendor invoices.
• Outstanding Quantity: Remaining units yet to be received ($\text{Quantity} - \text{Quantity Received}$).

---

Receiving Workflow & Financial Accruals

When vendor shipments arrive at the dock, warehouse personnel verify contents and record receipt. In standard (non-warehouse) locations, receiving occurs directly on the Purchase Order card.

Purchase Receiving Posting Flow:

[Purchase Order: Qty = 10, Qty. to Receive = 10]
                       │
                       ▼ Post (F9) -> "Receive"
       ┌───────────────┴───────────────┐
       ▼                               ▼
[Posted Purchase Receipt]     [Inventory / G/L Ledger Entries]
- Table 120 Header            - Table 32: Item Ledger Entry (+10 Qty, Open = Yes)
- Table 121 Lines             - Table 5802: Value Entry (Expected Cost)
                              - Table 17: G/L Entry (if Expected Cost enabled):
                                  Debit: Inventory (Interim)
                                  Credit: Invt. Accrual (Interim)

Posting Options on Purchase Orders (F9)

• Receive: Records the physical receipt. Updates Quantity Received and decreases Outstanding Quantity. Creates a Posted Purchase Receipt (Table 120 / Table 121), an Item Ledger Entry (Type: Purchase, positive quantity), and an expected cost Value Entry.
• Invoice: Processes financial vouchers for quantities where Quantity Received > Quantity Invoiced.
• Receive and Invoice: Executes physical receiving and financial voucher processing in a single atomic database transaction.

[!IMPORTANT] If Expected Cost Posting to G/L is activated in Inventory Setup, posting a receipt prior to invoice generates balanced interim accruals: Debit: Inventory (Interim) (Balance Sheet asset) and Credit: Invt. Accrual (Interim) (Balance Sheet interim liability). This ensures management accounts reflect unbilled received stock.

---

Over-Receipt Functionality & Governance

Vendors in bulk material, fastener, chemical, or agricultural industries frequently deliver quantities slightly above the purchase order commitment due to packaging, weight scales, or production yield.

Over-Receipt Codes Setup

Business Central provides the Over-Receipt Codes page (Alt+Q -> type Over-Receipt Codes, Page 8000 / Table 8000) to govern permissible overages.

Over-Receipt Hierarchy Resolution:

1. Purchase Line Override (Manually selected on line)
            ▲
            │ (Falls back to)
2. Item Card (Purchasing FastTab -> Over-Receipt Code)
            ▲
            │ (Falls back to)
3. Vendor Card (Receiving FastTab -> Over-Receipt Code)
            ▲
            │ (Falls back to)
4. Global Default (Code with "Default" checkbox enabled)

Over-Receipt Parameters

• Over-Receipt Tolerance %: The maximum allowable percentage above the initial line quantity (e.g., 10.0 allows receiving up to 110 units on a 100-unit order).
• Default: When flagged, this code automatically applies to all items and vendors that lack an explicit over-receipt assignment.

Receiving an Over-Receipt Quantity

1. A purchase order line is established for 100 units with a 10% over-receipt tolerance.
2. The vendor delivers 108 units. The receiving clerk enters 108 directly into Qty. to Receive.
3. Business Central validates that 108 is within the 110-unit ceiling ($100 \times 1.10$).
4. The system automatically updates the line's Quantity field to 108, populates Over-Receipt Quantity with 8, and references the applied Over-Receipt Code.
5. Posting the receipt creates an Item Ledger Entry for 108 units. The Posted Purchase Receipt line captures the over-receipt quantity for vendor audit trails.

[!NOTE] Organizations can activate the Purchase Order Over-Receipt Approval Workflow. When an over-receipt is keyed on a line, the document status shifts to require manager sign-off before warehouse personnel can post the receipt.

---

The Undo Receipt Action & Reversal Mechanics

When goods are received into the incorrect location, assigned the wrong item variant, or posted with erroneous quantities, users cannot simply delete the posted receipt. Instead, Business Central provides the Undo Receipt action.

Undo Receipt Execution Pipeline:

[Posted Purchase Receipt (Page 136)]
                │
                ▼ Select Line -> Functions -> "Undo Receipt"
       ┌────────┴────────┐
       ▼                 ▼
[Posted Receipt Updates]  [Ledger Reversals & Order Restoration]
- Inserts negative        - Table 32: Negative Item Ledger Entry (Correction = Yes)
  corrective line         - Closes original inbound Item Ledger Entry
  on receipt document     - Table 5802: Reverses Expected Cost Value Entries
                          - Purchase Order Line: Decreases Quantity Received,
                            restores Qty. to Receive and Outstanding Quantity

Strict Prerequisites for Undo Receipt

The system enforces three rigid operational constraints before allowing an Undo Receipt:

1. Item Line Type: The action functions exclusively on lines where Type = Item. It cannot be executed on G/L Account or Fixed Asset lines.
2. Uninvoiced Quantity: The line must have Quantity Invoiced = 0. Once any portion of the receipt line is invoiced, the receipt cannot be undone; an adjustment or Purchase Return Order is required instead.
3. Available & Unconsumed Stock: The specific Item Ledger Entry generated by the receipt must not have been consumed by a production order, assembly order, negative adjustment, transfer shipment, or applied outbound sales shipment. The exact quantity must remain open and available at the receipt location and bin.

Reversal Results in the System

When Undo Receipt is executed:

• A new corrective line is inserted into the existing Posted Purchase Receipt with a negative quantity and the description Undo receipt of %1 items.
• An Item Ledger Entry is posted with a negative quantity and Correction = Yes, applied directly to the original receipt entry to close it.
• Corresponding expected cost Value Entries are posted to negate the interim asset and liability balances in the General Ledger.
• On the original Purchase Order, the Quantity Received is reduced, and Qty. to Receive and Outstanding Quantity are restored to their pre-receipt values, allowing warehouse staff to re-receive the correct goods.

---

Purchase Document Posting Comparison

---

Step-by-Step UI Execution Workflows

Workflow A: Configuring Over-Receipt and Receiving Excess Inventory

1. Press Alt+Q, type Over-Receipt Codes, and select the related link (Page 8000).
2. Click New, enter Code OVER10, Description 10% Receiving Tolerance, and set Over-Receipt Tolerance % to 10.0.
3. Navigate to an Item Card (Alt+Q -> Items -> select ITEM-1000). On the Purchasing FastTab, assign OVER10 in the Over-Receipt Code field.
4. Create a new Purchase Order (Alt+Q -> Purchase Orders -> New) for vendor 10000.
5. Add a line: Type = Item, No. = ITEM-1000, Quantity = 50.
6. In the Qty. to Receive field, enter 54 (an 8% overage). Verify that Quantity updates to 54, Over-Receipt Quantity displays 4, and Over-Receipt Code shows OVER10.
7. Press F9, select Receive, and click OK.

Workflow B: Executing Undo Receipt on Erroneous Delivery

1. Press Alt+Q, type Posted Purchase Receipts, and select the related link (Page 136).
2. Locate and open the receipt containing the erroneous item intake.
3. Navigate to the Lines FastTab and highlight the line to reverse.
4. Click Functions -> Undo Receipt in the line menu.
5. Confirm the system prompt: "Do you want to undo the selected receipt line?" Click Yes.
6. Verify that a negative corrective line appears on the receipt, the Item Ledger Entry is reversed, and the original Purchase Order's Outstanding Quantity is restored.

---

Common Configuration Pitfalls & Exam Traps

• Pitfall 1: Attempting Undo Receipt After Invoicing. If an accounting clerk posts a purchase invoice against a receipt (even for a single unit), the Undo Receipt action will fail with the error: "You cannot undo receipt of line... because it has already been invoiced." The user must instead create and post a Purchase Return Order or Credit Memo.
• Pitfall 2: Consumed Inbound Stock Blocks Undo Receipt. If received raw materials have been picked and consumed by a released production order, or if finished goods have already shipped on a customer sales order, Business Central blocks Undo Receipt because the underlying Item Ledger Entry is no longer open.
• Pitfall 3: Over-Receipt Tolerance Exceeded. If warehouse personnel attempt to key an over-receipt quantity that exceeds the configured tolerance percentage, the system raises a strict validation error and prevents document posting until either the quantity is reduced or a manager increases the tolerance.
• Pitfall 4: Missing Vendor Invoice Number on PO Invoicing. Attempting to choose Receive and Invoice without entering a value in Vendor Invoice No. on the Purchase Order header will fail if Ext. Doc. No. Mandatory is enabled in Purchases & Payables Setup.