web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :

MS Dynamics AX Trial Balance Report

M.Aamer Profile Picture M.Aamer

Recently  I have shared fiscal year close was discussing how to close fiscal year after uploading opening balances which discussed before, this blog is related to the previous two posts where  the Financial Consultant and Controllership team are getting the results of their work throughout printing trial balance.

Under General Ledger-> Reports->Transactions->Periodic-> Trial Balance

Dates:

  • From: Enter start date of report date range
  • To: Enter end date of report date range
    Tips: Trial balance date range should be within one fiscal year
    Info log message “From date is in fiscal year 2010. To date is in fiscal year 2011. Dates must be in same fiscal year.”

Details level

  • Summary: to summarize the transaction on each account
  • Details: to report each detailed transaction entry occurred on account

Criteria

  • None: Generate report for all accounts in the chart of accounts
  • Opening balances: Generate report for accounts only have opening balances
  • Transaction: Generate report for accounts for account have transaction (month/period) movement
  • Closing balances:  Generate report for accounts have closing balance
  • Include opening check box: Include opening balance in the monthly movement

Print out of Trial Balance Report

Account Number

Account Name Opening Balance Debit Credit Net difference

Closing Balance

Account number in the chart of Accounts Account name/description in the chart of accounts Opening balance amount, after performing Fiscal year closing Debit transaction amount occurred on that account Credit transaction amount occurred on that account Difference between both sides= Debit – Credit Closing balance for that account at the end date range.= Net difference + Opening Balance

 

User group: DynamicsArabia

Comments

*This post is locked for comments