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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How to Zero/nill trail balance.

(0) ShareShare
ReportReport
Posted on by 5

Hello All,

We are implementing updated version of Dynamics AX as a functional consultant.My Employer told me that we will  empty /Zero our trail balance and once again take a fresh start to get real figures in trial balance..

My question is how i can zero (effect of all posted transactions reverse) my trail balance ?

Thanks

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How to Zero/nill trail balance.

    Hi Mr.Accountant,

    The data that you see in the trial balance are the result of postings made.

    You cannot simply zero them without making corrective postings.

    Can you let us know why you have to nil the balances?

    Is this a test/demo or live system?

    Best regards,

    Ludwig

  • Mr.Accountant Profile Picture
    5 on at
    RE: How to Zero/nill trail balance.

    Dear Mr. Ludwig

    We are in testing phase and now ready to go live that,s why we want to nill all balances we already have posted in all account. Irrespective of the fact it was right or wrong figures.

    Can you explain me, Is there any way we can nil all posted balances?

    Thanks

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How to Zero/nill trail balance.

    Hi Mr. Accountant,

    You should be able to simply setup a new test environment based on your golden configuration system.

    That is, a developer can help you creating a new demo/test company out of the golden configuration system that you setup.

    This new demo/test company can then be used for additional testing and does not have any transactions posted in it; it only has the setups that are made in the golden config system.

    Is this what you want to have?

    Best regards,

    Ludwig

  • Mr.Accountant Profile Picture
    5 on at
    RE: How to Zero/nill trail balance.

    Dear Mr. Ludwig,

    Thank you for your detailed answer.

    I understand a new test company should be created by developer  through golden config system.

    i need to know further a little more, lets change this scenario if we go live and need the same change (need to nil the trial), Is there any option available to us as a functional consultant ?

    Anticipated Thanks

  • Verified answer
    Satish Panwar Profile Picture
    14,671 Moderator on at
    RE: How to Zero/nill trail balance.

    Hello,

    You can't get rid of existing transactions. What you can do is reverse the entire transaction set. Make sure your reversal is exact opposite of amount(previous debit are now credit and vice-versa), dates and other details are exactly same including account + financial dimensions.

    E.g.

    acct1  +100. 1/1/2019

    Acct2. -200..1/1/2019

    Create reversal general

    acct1  -100. 1/1/2019

    Acct2. +200..1/1/2019

    Now you balance is zero for the account.

    Now load correct balances by account.

  • Verified answer
    nmaenpaa Profile Picture
    101,160 Moderator on at
    RE: How to Zero/nill trail balance.

    No, you can't wipe out posted transactions by any button / function in the system. And in Live system you would surely not want to do that.

  • Mr.Accountant Profile Picture
    5 on at
    RE: How to Zero/nill trail balance.

    Thank you All

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,167

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 867 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 617 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans