Some reports are not necessarily meant to match because they use different logic with regard to dates e.g transaction date vs posting date. Differences can arise in the reports with closed dates of transactions and the reports may not necessarily match for that reason e.g.
• Vendor Balance list records the balance as at a date.
• Vendor Ageing Report looks at what transactions are OPEN at a date.
Through open transaction editing (normally) the date principle determines the date the transaction is settled (closed) and this could be closed at a date prior to your balance date, and be settled against a payment past your balance date.
Therefore it would be excluded from the Ageing Report, but not the balance list.
Dynamics AX is date driven system rather than by period buckets, – when you set the date principle to the date on which you do the open transaction editing settlement (i.e. today's date), generally the results match. It is possible to get currency differences after exchange rate adjustment when the invoice stays open after financial closing and you are running a back dated report.
There have been some hotfixes for TB in the past- I don't know what version you have.
Voucher prefix, Transaction type and Posting type, help you identify mis-postings.
Ensure the 'Do not allow manual entry' checkbox is marked on the ledger account to avoid direct posting to the account. This setting requires that all transactions post through the subledger accounts.
Reports that can be used for reconciliation are:
•Bank to ledger reconciliation report
•Customer to ledger reconciliation report
•Potential conflicts – work in process and general ledger
•Inventory value report
•Potential conflicts – inventory and general ledger
•Vendor to ledger reconciliation report
•Sales tax/ledger reconciliation report
