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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Year end closing
Microsoft Dynamics AX (Archived)

Year end closing

(0) ShareShare
ReportReport
Posted on by imran ul haq 4,017

Hi All

 

I have close the year 2011, and now when i am printing the trail balance, with the criteria transaction some of the account are missing, they are not showing, due to that the opening balance difference is showing. And when i select the "Opening Balance " in the critearia it is coming fine.

 

 

Can anyone advise me

 

 

thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    M.Aamer Profile Picture
    M.Aamer on at

    Hi Imran,

    1-Review ledger accounts setup (Account Type) the balance, and profit & loss accounts are assigned correctly, specially the accounts are not appear to you on the report.

    2- Validate ledger balnces, and transactions for thos accounts from ledger transaction list report, just to make sure every thing are OK, and we have to check the report output.

    Regarding the Trial Balance output you mentione,  the accounts which are only appears when you select opening balances, it seems those accounts does not have transactions "period movements" (weired for me).  Did you tried to mark the Include opening balance check box? may be it works with you.

    Wishing the following blog post help you: blog.mohamedaamer.com/.../ms-dynamics-ax-trail-balance-report

    Regards

  • imran ul haq Profile Picture
    imran ul haq 4,017 on at

    Hi Aamer

    thanks for replying

    I review the ledger type it is "Asset" and through the Transaction report i saw the balance is there in debit.

    when i generate the trail balance, with criteria "opening balance" for the next fiscal year e.g i make the closing for 2011 and now generarting the trail balance for 2012. in the report opening balances shows, but when i generate the trail with criteria transaction, it skip these account.

    i am not getting why

  • Suggested answer
    M.Aamer Profile Picture
    M.Aamer on at

    Hi Imran,

    Opening balances: Generate report for accounts only have opening balances

    Transaction: Generate report for accounts for account have transaction (month/period) movement

    Please try to mark: Include opening check box: which means Include opening balance in the monthly movement

  • imran ul haq Profile Picture
    imran ul haq 4,017 on at

    Hi Aamer

    You r right my dear friend but my problem is this when i generate the trail balance after unchecking the both check mark and in criteria i am selecting the transaction. The opening balance is not showing for some account. I think as per your answer, if the account have the opening balance and during the year it does not have the transaction it will not take that account in the trail balance.

    And i want to generate the trail balance for 2012 in which i can see the opening balance, as i completed the closing of 2011. And also want to see the account in which balances are transfer (opening balance) but during the year it does not have the transaction. How can i generate this report.

    thanks

  • Verified answer
    M.Aamer Profile Picture
    M.Aamer on at

    Hi Imran,

    The best selection certria is Closing Balances, where the result will be the accounts which have closing balances whether has opening balances, and/or period movements.

    It was great since we have explored the trial balance priting options.

    Regards  

  • imran ul haq Profile Picture
    imran ul haq 4,017 on at

    thanks Aamer, really i you solved my problem.

  • M.Aamer Profile Picture
    M.Aamer on at

    You're most welcome.

    Just mark this post as Answered.

    Enjoy your time with MS Dynamics AX :-) just

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans