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) / Automaticaly reversing...
Microsoft Dynamics AX (Archived)

Automaticaly reversing/writting off GL accounts wheer the balance is $0.01

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

A number of our balance sheet GL accounts have a balance of $0.01 or -$0.01 at the end of a period and our users are going though and importing a journal entry for the reversal entry for all of these accounts so they balance.

 

So my question is, is there in AX to set up automatic reversal transactions for an account based of of the balance in that account?

 

I am also looking into why we have this $0.01 balance as there might be a root problem to be fixed, but I would really like to find a way to quickly brings an accounts balance to $0.

 

Thank you,

 

Phil

*This post is locked for comments

I have the same question (0)
  • nunomaia Profile Picture
    nunomaia 25 Moderator on at

    I’m not seeing a way to automatically reverse G/L accounts balance based on a criteria. It’ possible to customize that feature if it is a regular procedure.  

    Those entries can happen in some scenarios, for example currency rounding differences, etc.  Can you open the voucher entry of those entries and check the value of posting type field? You might get an idea the reason of those entries.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Phil, try the following

    1 setup a customer pool that filters for those customers with a small balance

    2 update the AR collections list page

    3 open the collections list page and select the pool with the customers that have a small balance

    4 select all of them and say write off

    5 open the GL journal that has automatically been created and post it

    This should clear all your mini balances.

    Hope it helps

    Ludwig

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Sorry just overlooked that you only talk about GL balances. What I said will only help for AR customer account balances. Maybe might be helpful anyway. Regards Ludwig

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