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) / How to mark a years wo...
Microsoft Dynamics AX (Archived)

How to mark a years worth of bank transactions as cleared in bank reconciliation?

(0) ShareShare
ReportReport
Posted on by Community Member

I have several bank accounts and reconciliations to bring up to date (hasn't been reconciled properly for a year).  Is there a quick way of marking a set of transactions at once (up to 4000 transactions) rather than clicking every line separately?

Also there is a rogue reconciliation with a future date on it, I presume the end balance on this one won't be used as the starting date for the next one until we get to that date in a few months time?  Can I delete this reconciliation?

 

thanks

*This post is locked for comments

  • Suggested answer
    Oceanfish26 Profile Picture
    Oceanfish26 606 on at
    RE: How to mark a years worth of bank transactions as cleared in bank reconciliation?

    I had 2700 transactions, none of them had a Check Number.  I was able to mark all of them by using Mark Check Interval and I used blank as the lower value and 999999 as my high value, then they all cleared!

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,341 Super User 2025 Season 1 on at
    RE: How to mark a years worth of bank transactions as cleared in bank reconciliation?

    AXf, can you post a screenshot of the field you're referring to, just to confirm?  Thanks

  • Community Member Profile Picture
    Community Member on at
    RE: How to mark a years worth of bank transactions as cleared in bank reconciliation?

    Don't worry, I just solved the main question by adding the 'manual' column on to the rec and found one manual entry that had no bank trans type on it. Now reconciled, I still don't know what the date relates to though.

  • Community Member Profile Picture
    Community Member on at
    RE: How to mark a years worth of bank transactions as cleared in bank reconciliation?

    thanks Ludwig, I still don't understand what the 'date' shown in this box relates to?

    I marked all my transactions as reconciled, and posted a dummy GL journal, one side to the Bank account, one side to the corresponding GL Ledger account for the bank to correct my ending reconciliation balance without changing the balance in the TB, but:

    When I click 'reconcile account' I get an error message saying: "Ledger account not specified, bank transaction type is not specified."

    Does this relates to one of the lines in the rec (how do I work out which one?), or the dummy GL journal I did to correct the balance?

    Any help appreciated.

    thanks

    AXF

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to mark a years worth of bank transactions as cleared in bank reconciliation?

    Hello AXfinance,

    the Balance that you can see in the fact pane comes from the info part "BankAccountTableBalance" that uses the DataMethod "balanceCur" from the BankAccountTable. The balanceCur DataMethod there refers back to the BankAccountTable balances Method and calculates the Balance that you see as follows:

    1bk.png

    If the data you see in this infobox does not match your TB data, try to select the button "click to load all data" to get the information shown there refereshed. It should give you the current Balance of your bank account as of today. This data should be in line with the Balance that you see in GL/common/main accounts in the Balance info part on the right-Hand side provided that the ledger account associated to your bank account has not been changed.

    Hope this helps,

    Ludwig

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,341 Super User 2025 Season 1 on at
    RE: How to mark a years worth of bank transactions as cleared in bank reconciliation?

    You would need a developer to run the SQL script for you to clear all the transactions at once.

    You can delete a reconciliation if there are no cleared transactions in it.  If there are, uncheck the boxes in the transactions list.  That should allow you to delete the reconciliation.

    The balance in the fact box is the net of all transactions in that bank account.

  • Community Member Profile Picture
    Community Member on at
    RE: How to mark a years worth of bank transactions as cleared in bank reconciliation?

    thanks, I already tried to edit the 'reconciled' box manually in the table but it is greyed out.  Would I still need to mark them all one by one in the table?  I'm not a developer, hoping to get some dev help, but would help me to understand the process.

    Also any idea where the 'balance' shown in the fact pane on the bank accounts list comes from? the date shown here doesn't correlate to anything, not TB date, not date of last reconciliation, not period end date, not system date, so difficult to tie up to anything.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,341 Super User 2025 Season 1 on at
    RE: How to mark a years worth of bank transactions as cleared in bank reconciliation?

    AXf, one way to accomplish this is via SQL query.  I've done this many times for clients by marking 'Reconciled = 1' in the bankaccounttrans table.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to mark a years worth of bank transactions as cleared in bank reconciliation?

    Hi AXfinance,

    I think you should contact a developer that can help you with this issue. From the front end side there is no way that you can automatically select more than one single cleared Checkbox in the account reconciliation form.

    Best 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans