Skip to main content

Posts

Start Here

Start Here

Something in Business Central not behaving? Work down this page. Most things are answered here already — and if they aren't, the last section tells you exactly what to send me so we can skip three rounds of questions. The sixty-second checks These four clear most of what reaches me. Try them before anything else. Hard refresh the page. Hold Ctrl and press F5. A normal refresh reloads the cached copy; this one doesn't. Check which company you are in. The name is at the top of the screen. Posting into the wrong entity is easier than it sounds. Open it in a private window. If it works there, the problem is cache or a browser extension, not Business Central. Try a different browser. If Edge fails and Chrome works, that alone narrows it down enormously. Part 1 — Something on screen isn't working A page won't load, a button does nothing, something has gone missing, or an error stops you posting. Start here if Business Central itself is misbehaving. A...
Recent posts

Reverse a Wrongly Posted Payment in Business Central (Open or Closed Month)

A customer or vendor payment was posted wrongly in Business Central: wrong amount, wrong bank, posted twice, or it never happened at all. Now you need to undo it without messing up the vendor balance, the bank reconciliation, or a month that Finance has already closed. Quick answer Payment's month still open → Reverse Transaction from General Ledger Entries. BC reverses everything on the original date. (Method 1) Payment's month already closed → post a reversal journal dated in the current month, then apply it to the original payment. (Method 2) Either way: unapply the payment from its invoice first, and clear the two bank entries in your next bank reconciliation. First, do you really need to reverse? Reversing is for a payment that is wrong as a whole. Smaller mistakes have a cleaner fix: What's wrong Best fix Only the dimension (e.g. wrong department) Correct Dimensions on General Ledger Entries. Nothing is reversed. Wrong vendor or customer...

Which Exchange Rate Does Business Central Use on Invoices and Payments?

An auditor asks: "Which date is used as the basis for the exchange rate on this invoice – the invoice date or another date?" Here is the short answer, and how to prove the exact rate used on any posted invoice or payment in Business Central (BC). Short answer: BC uses the exchange rate effective on the document's Posting Date (not the Document Date). The rate comes from one of two places: System rate (default): the rate maintained in the Currency Exchange Rates table. Spot rate : a rate the user keyed in on that document, which overrides the system rate. 1. How BC picks the system rate Go to Currencies , select the currency, then choose Exch. Rates . BC takes the line with the latest Starting Date on or before the document's Posting Date . LCY amount = Foreign amount × Relational Exch. Rate Amount ÷ Exchange Rate Amount Starting Date Exchange Rate Amount Relational Exch. Rate Amount Used for documents posted 2/1/2013 100 65.7023 2/1...

Business Central: Return Defective Items to Vendor & Receive the Replacement

Your store team found defective items after the goods were received (GRN) in Business Central, and the vendor has agreed to replace them. Now you need to send the bad stock back and receive the replacement, without messing up your inventory cost or the vendor balance. Quick answer GRN not invoiced yet → Undo Receipt , then receive the replacement on the same PO. (Scenario A) GRN already invoiced → a Purchase Return Order to send the item back, a new PO to receive the replacement, then apply the credit memo against the replacement invoice. (Scenario B) First, check: has the receipt been invoiced? Open the Posted Purchase Receipt and look at Quantity Invoiced on the line. 0 or blank → go to Scenario A. Has a value → go to Scenario B. The whole flow at a glance Defective item found after GRN ▼ Has the receipt been invoiced? NO → Scenario A Undo Receipt, then receive again on the same PO YES →...

Business Central: Apply a Payment or Credit Memo After Posting (Invoice Still Shows Remaining Amount?)

Short answer Forgot to apply a payment or credit memo before posting? You can still apply it from Customer Ledger Entries or Vendor Ledger Entries . Choose Apply Entries , mark the invoice with Set Applies-to ID , then click Post Application . If you skip Post Application, nothing is applied and the invoice still shows a remaining amount. Step 1: Open the ledger entries Open the customer or vendor card and choose Ledger Entries . The steps are the same for customers and vendors. Select the open payment or credit memo, then choose Apply Entries . Step 2: Select the invoice, then Post Application This page works the same way as applying while you prepare a payment or credit memo. There is only one extra step at the end. 1 Select the invoice line and choose Set Applies-to ID . Your user ID appears on the line. 2 Change Amount to Apply if you are applying only part of the amount. 3 Choose Post Application . Important: the step most users miss Set Appl...

Business Central: Auto-Post Purchase and Sales Invoices After Approval (Workflow Setup)

Want a purchase or sales invoice to post by itself the moment it is approved, so nobody has to go back and click Post ? Business Central can do this with a standard approval workflow. No customization is needed. Short answer: tick one box in Workflow Event/Response Combinations , then add the response Post the sales or purchase document in the background as the last response on the approved line of your workflow. Where it works Document Auto-post after approval Purchase Invoice Yes Purchase Credit Memo Yes Sales Invoice Yes Sales Credit Memo Yes Journals (General, Payment, Cash Receipt and the rest) No Journals can be approved by workflow, but standard Business Central has no response that posts a journal after approval. Someone still has to post the batch. For the journal approval setup, see my earlier post: Business Central Journal Approval Workflow: Any 1 of 3 Approvers . T...

Build a Simple P&L Report by Dimension Using G/L Entries Analysis Mode in Business Central

Need a quick P&L by department or customer group, but don't want to set up a Financial Report or ask a developer? You can build one yourself in a few minutes from General Ledger Entries using Analysis mode . Important: new versions only. Analysis mode is available in Business Central 2023 release wave 2 (version 23) and later. Adding columns from related tables (Step 3) needs version 26.2 or later. If you don't see the icons below, your version is too old. Step 1: Open Analysis mode Search for General Ledger Entries , then click the Enter analysis mode icon next to the search icon. What you can do here: Group, filter and total your G/L entries without leaving Business Central Pivot the data like an Excel pivot table Save several analysis tabs for different reports Note: Analysis mode only reads data. Nothing you do here changes your postings. Step 2: Add or remove columns In the Columns pane on the right, tick the fields you want to see and untick ...

Business Central Journal Approval Workflow: Any 1 of 3 Approvers (Step-by-Step)

Scenario: a journal batch has 3 possible approvers. As soon as any 1 of them approves, the batch is approved. As soon as any 1 rejects, the batch is rejected. Nobody has to wait for all 3. Tested on Business Central version [fill in]. Works for General, Sales, Purchase, Cash Receipt and Payment Journals. Which setup do you need? Your rule What to follow Scenario A: any 1 approver is enough Steps 1 to 5 below, exactly as written. This is the main guide. Scenario B: all approvers must approve Go to the Scenario B box near the end. It reuses Steps 1 to 4 with its own settings. Each workflow handles one scenario only . Do not mix the settings. Scenario A in one line: put the 3 approvers in a Workflow User Group with the same Sequence No., set Pending Approvals to 2, and add the response Approve the approval request for the record . Before you start Every approver must exist in Approval User Setup . Do not put the ...