Microsoft Dynamics 365 Business Central Self-Help Place

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. 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'...

You set the email address on the Customer Card. You send the Statement of Account. It arrives somewhere else, or it does not arrive at all. The Customer Card is not the first place Business Central looks. What is actually happening Business Central checks Document Layouts first. Every customer has a Document Layouts page. Each row on it maps a document type — Statement, Invoice, Reminder — to a report, and optionally to a specific address in the Send To Email field. If there is a row for the statement report with an email address on it, that address wins. The one on the Customer Card is ignored completely. Only when there is no matching row, or the row has no email in it, does Business Central fall back to the Customer Card. How to check Open the Customer Card. Go to Related > Customer > Document Layouts . Find the row where Usage is the statement report. Look at Send To Email on that row. Nine times out of ten the mystery address is sitting...

If you run Calculate Depreciation for a month, then run it again before posting, Business Central will create the same lines a second time. It does not warn you. Post that batch and you have depreciated twice. This one catches people at month end, and I have explained it enough times now that it deserves a post. What is actually happening Calculate Depreciation does not look at your journal. It looks at the Last Depreciation Date on the Fixed Asset Depreciation Book. That date only updates when you post . Not when you calculate. So the sequence goes like this: You run Calculate Depreciation until 30 April. Lines appear in the Fixed Asset G/L Journal. Something else comes up and you leave the lines sitting there, unposted. A few days later you run Calculate Depreciation until 30 April again. Business Central checks Last Depreciation Date, sees that nothing has been posted, and calculates April all over again. Now you have two sets of April lines in the same journal. ...

 Microsoft Dynamics 365 Business Central has a smart feature called 'Exchange Rate Adjustment. It is a powerful tool that automatically calculates unrealized foreign exchange gain and loss on open documents at month-end, perfectly handling currency fluctuations for you. Before you can run the 'Exchange Rate Adjustment,' you'll first need to set up the month-end exchange rates on the Currencies page in Business Central. Setup Month-end exchange rates Page: Currencies 1.     Select the "Exchange Rate". 2.     Enter the Month-end exchange rates into "Relational Adjmt Exch Rate Amt" based on the month that you will need to adjust. Once the Month-end exchange rate is setup, you can close the screen. To Run Exchange Rate Adjustment for the month Page: Exchange Rate Adjustment 1.      For the Starting Date , leave this field blank. This ensures that all open transactions are included in the foreign exchange gain/loss calculation, giving you a complete p...

Extending Your Financial Year in Dynamics 365 Business Central Need to extend your current financial year in Microsoft Dynamics 365 Business Central (BC)? You can easily do this within the "Accounting Period" page. This post will guide you through extending your financial period, for example, from the standard 12 periods (1/1/2024 - 31/12/2024) to 15 periods (1/1/2024 - 31/03/2025).     Step 1: Ensure Your Financial Year is Open in Business Central Before extending your accounting period in Dynamics 365 Business Central, the first crucial step is to verify that the financial year you want to extend is still open. Navigate to the "Accounting Period" page and check the “Closed” and “Date Locked” columns for the financial year ending 31/12/2024. These columns should be clear, indicating an 'Open' status.     Step 2: Extend Your Accounting Period     Once you've confirmed the financial year is open, you can proceed with the extension. Manually add in the add...