Skip to main content

Posts

Showing posts from August, 2026

Business Central: Why Forex Gain/Loss Is Wrong When Applying a Foreign Currency Payment to an Invoice in Local Currency with same equivalent

Symptom: You post a Cash Receipt Journal in a foreign currency, key in the actual bank rate directly on the line, and the receipt posts correctly. Then you apply that receipt to the customer's invoice (recorded in Local Currency) — and Business Central posts a forex gain/loss that shouldn't be there at all. It looks like the customer paid more (or less) than what actually landed in the bank. The scenario Local Currency (LCY): GBP Invoice: GBP 1,000 Customer pays: USD 1,346.39 — the bank-negotiated rate that day meant this USD amount exactly covers the GBP 1,000 invoice, no more, no less. Expected result: Payment = Invoice. Applying the receipt should close the invoice with zero forex gain/loss. What actually happens: after applying, Business Central posts a gain or loss anyway, and the receipt's own Amount (LCY) changes in the process. Why this happens You post the Cash Receipt Journal with Currency Code = USD, and use Change Exchange Rate (the Assist...

Partial Delivery, Multiple Invoices: How to Process One PO in Business Central

Partial Delivery, Multiple Invoices: How to Process One PO in Business Central. One of the most common questions I get from finance teams moving onto Business Central is: "What happens when a vendor can't deliver the full PO in one go, and sends us a separate invoice for each shipment?" Here's the clean way to handle it — no manual quantity edits, no reconciliation headaches. The Scenario You raise a Purchase Order for 1,200 cases. The vendor can only ship 200 cases at a time, and invoices you separately for each shipment. Today, you've received 400 cases across two deliveries, with 800 still outstanding — and two vendor invoices already in hand. Metric Quantity Total PO Quantity 1,200 cases Goods Received 400 cases Remaining Quantity 800 cases Supplier Invoice Quantity Basis Invoice A 200 cases First delivery Invoice B 200 cases Second delivery The PO stays open as long as any quantity remains undelivered — that'...