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

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

Business Central: Created By vs Modified By in Ledger Entries

In Business Central, the name on a ledger entry is the person who posted it, not the person who keyed in the document. This surprises many users, especially when they open Page Inspection and see two different names on the same entry. The same rule applies to general ledger, customer, vendor and other ledger entries. This post explains what the two system fields mean, why they can show different people, and how to find the original creator when you need it. What the two fields mean Every table in Business Central has system fields that record who inserted a record and who last changed it. You can see them in Page Inspection (Ctrl+Alt+F1) under Table Fields. Field What it records Does it change? SystemCreatedBy The user who inserted the record. For a ledger entry, this is the user who posted. Never SystemCreatedAt The date and time of posting Never SystemModifi...

Business Central Error: Debit Rounding Account Is Missing in Vendor Posting Group

Posting a payment or applying vendor entries in Business Central stops with this error: Debit Rounding Account is missing in Vendor Posting Group Code: XXXX. G/L Account No. must have a value in G/L Entry: Entry No.=NNNNN. It cannot be zero or empty. The fix Open Vendor Posting Groups and find the code named in the error. Fill in both Debit Rounding Account and Credit Rounding Account . Post again. Which account? A profit and loss account, such as your rounding differences account or your realized exchange gain/loss account. Use the same account for both fields. Do not use the payables account. Why it happens You partly paid a foreign currency entry, and rounding left a one-cent gap in local currency. Business Central needs an account to post that cent to. Example: invoice of USD 302.00 at rate 4.2345, part-paid with USD 101.00. Step Calculation MYR Invoice 302.00 × 4....

Why Business Central Allows the Same Document No. to Be Posted Twice

A user opens the Vendor Ledger Entries, sees the same Document No. and the same External Document No. posted twice, and the first reaction is: "Business Central has a bug. It allowed a duplicate posting!" I have been asked this question several times. The answer is always the same: the system did exactly what it was told to do. The journal line was posted without a Document Type . Short answer Business Central only checks for a duplicate Document No. and External Document No. when the journal line's Document Type is a transaction document such as Invoice or Credit Memo . When the Document Type is blank, the duplicate check is skipped. This is standard design, not a bug. What the user sees A purchase invoice was posted earlier. Later, someone keys in a general journal line against the same vendor, types the same Document No. and External Document No., leaves the Document Type empty, and posts. Business Central accepts it. Entry Document Type Docu...