Microsoft Dynamics 365 Business Central Self-Help Place

The auditor asks for the debtors aging. You print it, and the total doesn't match trade receivables on the trial balance. Now you have to explain the difference. Most of the time it isn't a real difference: the two reports were run differently. When it is real, it's almost always the same thing: someone posted straight to the control account. Here's how to check, find it and stop it happening again. AR and AP work exactly the same way. Quick answer Run the Trial Balance and Aged Accounts Receivable for the same date, with Aging by = Posting Date . The Balance of all your receivables control accounts should equal the aged report's Total (LCY) . Still different? Run Reconcile Customer and Vendor Accounts . The Difference column shows which account is off. Open General Ledger Entries for that account and filter Source Type = blank. Those entries were posted straight to the account, without a customer. Turn off Direct Posting on every receivables and ...

You search Business Central for SST or GST and find nothing. Everything says VAT . That's because Business Central uses one tax engine for every country, and it calls it VAT. Malaysian SST and Singapore GST are set up in the same place. Wherever you see VAT, read SST or GST. Quick answer VAT Product Posting Groups: one for each country's tax, for example SST and GST . VAT Business Posting Groups: one for each tax code, for example SVC-8 , SR-9 , TX-9 . VAT Posting Setup: one line for each combination, with the rate and the tax accounts. Put the codes on your customers, vendors, items and G/L accounts. BC then calculates the tax on every document. To find posted tax for your return, open VAT Entries and filter by code and VAT Date . How BC finds the tax rate Customer or vendor card VAT Bus. Posting Group SVC-6 G/L account or item VAT Prod. Posting Group SST ▼ VAT Posting Setup the line fo...

The forwarder's sea freight bill arrives three weeks after the goods. So it gets posted straight to Freight Expense. Now the items in your warehouse look cheaper than they really are, and every sale of them shows a bigger margin than you actually made. Business Central can add that freight to the cost of the goods you already received, using an Item Charge . No change to the receipt, no journal. Quick answer One time only: create the item charge in Item Charges (for example P-FREIGHT). Create a purchase invoice for the forwarder. Add a line with Type = Charge (Item) and the freight amount. On that line, open Item Charge Assignment → Get Receipt Lines and pick the posted receipts the freight belongs to. Choose Suggest Item Charge Assignment → By Amount → OK , then post the invoice. BC adds the freight to the cost of those received items. No journal needed. Before and after Before: freight as an expense ▼ Freight bi...

Your financial year has ended. Now Business Central needs to zero the P&L accounts and move the year's profit into retained earnings. It takes three actions, and BC does the maths for you. One of them can't be undone , so do them in this order. Quick answer Accounting Periods : make sure next year exists, then choose Close Year . Search Close Income Statement : enter the year-end date, a journal batch and your retained earnings account, then OK . Open that journal batch, check the lines, and Post . Posted something into the old year later? Post it, then run Close Income Statement again. The whole flow at a glance Year-end close in Business Central ▼ 1. Make sure next year exists Accounting Periods → Create Year (if it isn't there yet) ▼ 2. Close Year Accounting Periods → Close Year (can't be undone) ▼ 3. Close Income Statement BC creates the closing lines in a journal ▼ 4. Review and post the journal P&L accounts zer...