Microsoft Dynamics 365 Business Central Self-Help Place

Need your P&L split by department, side by side? You can build it once in Financial Reports (called Account Schedules in older versions) and run it every month. No Excel work, no developer. Quick answer: Create a financial report with a row definition that lists your P&L accounts and a column definition with one column per department. In each column, enter the department code in Department Code Totaling . The field is hidden by default, so add it with Personalize . Global dimensions only. This method works for Global Dimension 1 and 2. You can check yours in General Ledger Setup > Dimensions . Other dimensions need an analysis view, which this post doesn't cover. Step 1: Create the financial report Search for Financial Reports and choose New . Enter a Name and Description , for example PNL DEPT and PNL by Department (Dimension) . Select a Row Definition (for example, your Income Statement) and a Column Definition . To start a new one, create it f...

You post the electricity bill to one expense account. Then at month-end, you do a journal to move the cost to each department. Every month, the same thing. You can stop doing that. Business Central can split the cost for you when you post the purchase invoice , using an Allocation Account . Quick answer Set up an Allocation Account once, with your split (e.g. 50% / 20% / 30%) and the department for each share. On the purchase invoice line, choose it in the Allocation Account No. field. Post. BC splits the amount to each department automatically. No journal needed. Before and after Before: every month ▼ Post purchase invoice full amount to one account ▼ Create a journal reclass the cost to each department ▼ Cost split (and repeat next month) After: Allocation Account ▼ Post purchase invoice Allocation Account No. = UTILITIES ▼ Cost s...

Quick answer Business Central controls this on the G/L account , not on the dimension value. Use Dimensions-Multiple on the Chart of Accounts and set an Allowed Values Filter on the DEPARTMENT dimension. To keep MARKETING and SALES on Travel and Entertainment accounts only, you need two setups: one on the T&E accounts (allow only MARKETING and SALES) and one on every other account (block MARKETING and SALES). Got this error? "Dimension value DEPARTMENT, ADM is not allowed for G/L Account, 8430." The account has an Allowed Values Filter. Change the department on the line to one the account accepts, or ask your BC admin which departments are allowed. The example The finance team wants the MARKETING and SALES departments used only on Travel and Entertainment & PR expenses. Every other account should reject them. Why one setup is not enough The Allowed Values Filter sits on the account. It controls which departments that account accepts. It does not con...

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

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

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