25 Tips for Accountants using Business Central
1. Inventory Valuation Report Does Not Match GL Account
- Cause: Unposted inventory costs, manual journal entries, or timing differences.
- Resolution: Run the “Reconcile Inventory to G/L” report and post Adjust Cost – Item Entries to update costs in GL.
3. Customer Payments Applied to the Wrong Invoice
- Cause: Incorrect application of customer payments.
- Resolution:
- Navigate to Customer Ledger Entries and unapply the payment.
- Reapply it to the correct invoice.
5. Trial Balance Does Not Balance
- Cause: Unposted transactions, incorrect journal entries, or currency rounding differences.
- Resolution:
- Ensure all transactions are posted.
- Review and correct General Ledger Entries.
- Check for any foreign currency transactions with rounding issues.
7. VAT/Sales Tax Reporting Discrepancies
- Cause: Incorrect tax setup, missing tax codes, or manual adjustments.
- Resolution:
- Run the VAT Statement Report and compare it with transactions.
- Verify tax setup under Tax Posting Groups.
9. Differences Between Aged Accounts Receivable Report and GL
- Cause: Manual journal entries made directly to the AR GL account.
- Resolution:
- Reconcile with the Customer Ledger Entries and ensure all transactions flow through the sub-ledger.
11. Unposted Purchase or Sales Invoices
- Cause: Documents saved as drafts or in batch processing queues.
- Resolution:
- Navigate to Purchase/Sales Invoice List, filter by status, and post missing transactions.
13. Posting Date Restrictions Preventing Transactions
- Cause: Period closed or user has restricted posting dates.
- Resolution:
- Adjust General Ledger Setup > Allow Posting From/To Dates.
15. Foreign Currency Transactions Showing Incorrect Values
- Cause: Exchange rate differences or missing rate updates.
- Resolution:
- Run Adjust Exchange Rates in General Ledger Setup.
17. Duplicate Customer or Vendor Records
- Cause: Manual data entry without proper validation.
- Resolution:
- Use Merge Duplicates functionality or update records manually.
19. Payment Discounts Not Calculating Properly
- Cause: Incorrect payment terms or missing discount setup.
- Resolution:
- Verify Payment Terms in Customer/Vendor setup and adjust invoice due dates accordingly.
21. Unable to Apply Credit Memo to an Invoice
- Cause: Credit memo not posted correctly or not applied during creation.
- Resolution:
- Go to Customer/Vendor Ledger Entries, select the credit memo, and apply it manually.
23. Financial Period Close Errors
- Cause: Unposted transactions or unbalanced trial balance.
- Resolution:
- Run “Check G/L Balance” before closing the period and correct any errors.
2. Bank Reconciliation Doesn’t Balance
- Cause: Missing transactions, incorrect posting dates, or manual adjustments.
- Resolution:
- Verify all bank transactions are posted.
- Check for unposted journals in Bank Account Ledger Entries.
- Use automatic matching to reconcile transactions efficiently.
4. Vendor Payments Applied Incorrectly
- Cause: Wrong selection of invoices during payment application.
- Resolution:
- Use the Unapply Entries function in the Vendor Ledger Entries and reapply the payment correctly.
6. Journal Entry Posting Errors
- Cause: Missing mandatory dimensions, incorrect account selection, or posting date restrictions.
- Resolution:
- Enable “Allow Posting From/To Dates” in General Ledger Setup.
- Ensure required dimensions are assigned.
8. Recurring Journal Entries Not Posting Correctly
- Cause: Incorrect recurring method (Fixed, Variable, Balance).
- Resolution:
- Verify and select the correct Recurring Method in the journal.
- Ensure the Expiration Date is not set incorrectly.
10. Differences Between Aged Accounts Payable Report and GL
- Cause: Manual postings to AP GL without corresponding vendor transactions.
- Resolution:
- Verify vendor balances and use the Reconcile AP to GL report.
12. Financial Reports Not Generating Correctly
- Cause: Incorrect row definitions or missing account mappings.
- Resolution:
- Edit the Account Schedules and ensure proper GL accounts are assigned.
14. Error: “You do not have permission to post this transaction”
- Cause: User role does not include posting rights.
- Resolution:
- Modify permissions under User Groups & Permissions in Business Central.
16. Fixed Asset Depreciation Not Posting
- Cause: Incorrect depreciation book setup or missing posting setup.
- Resolution:
- Run the Calculate Depreciation batch job and verify depreciation settings.
18. Item Costs Are Incorrect After Purchase Posting
- Cause: Costing method mismatch or missing cost adjustments.
- Resolution:
- Run Adjust Cost – Item Entries and revalue inventory if needed.
20. Data Export to Excel Not Formatting Correctly
- Cause: Excel templates or export settings incorrect.
- Resolution:
- Use Edit in Excel for better formatting control.
22. Users Unable to See or Access Certain Transactions
- Cause: Role-based security settings restrict access.
- Resolution:
- Assign appropriate Permission Sets to affected users.
24. Dimensions Missing from Transactions
- Cause: Dimensions not set as mandatory.
- Resolution:
- Enable Mandatory Dimensions in General Ledger Setup.
Last but not the lease
25. Slow Performance When Running Reports
- Cause: Large data sets or inefficient filters.
- Resolution:
- Use Filters to narrow report scope and schedule large reports for off-peak hours.