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 / Small and medium business | Business Central, N... / Mark bank transactions...
Small and medium business | Business Central, N...
Answered

Mark bank transactions on general ledger as closed

(0) ShareShare
ReportReport
Posted on by crawlenj 130

Hi All,

I have some historic transactions on the general ledger (there are about 250 of them, don’t ask). They are bank payments and reversals, so they net to £0.

 

On the general ledger they are all marked as Open. I have reconciled the periods covering these transactions, but obviously I must not have matched to these transactions.

 

When I run a new reconciliation it does not give me these transactions available to be matched, so I can’t clear them that way.

 

I have also tried editing the transactions in Excel, but I am not able to publish them back to Dynamics once I have changed the open status to false.

 

Is there another way to mark these transactions as closed?

I have the same question (0)
  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,037 on at

    Hi,

    Pls create one Batch Job and Mark Open Entries false.

    Regards

    Amit Sharma

    www.erpconsultors.com

  • crawlenj Profile Picture
    crawlenj 130 on at

    Hi Amit,

    Thank you for your response. Unfortunately I don't understand what you mean by 'create one batch job'.

    Please could you send further details?

  • Verified answer
    AD-22040756-1 Profile Picture
    AD-22040756-1 642 on at

    Next time you do a bank rec., in the Bank Acc. Reconciliation Page click on Process -> Suggest Lines, enter a data range for when you have the reversed transactions to pull them in the Bank Statement Lines pane. Ensure the Exclude Reversed Entries is false. Delete all the other lines that were pulled in that are not needed. When you post the bank rec. the reversed entries will be marked as open=false.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 211 User Group Leader on at

    Amit, I think what she is saying is that these entries were only general ledger entries. If that is the case Nicola, there is no way to close general ledger entries. The closed field is only in bank and check ledgers. If they are not affecting your bank reconciliation, then you are good to go.

  • AD-22040756-1 Profile Picture
    AD-22040756-1 642 on at

    It looks like she is incorrectly calling 'Bank Account Ledger Entries' as 'General Ledger' otherwise she wouldn't see the Open field

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,037 on at

    Hi,

    Thank you for suggestion.

    But She do not want to see these entries while reconciliation. So that why, i was suggesting for closing entries in the Bank Account Ledger Entries. If Entries are open in G/L Entries Table. Then create Batch Report.

    Taking Bank Account Ledger Entries base dataitem and write code on Aftergetrecords and closed G/L Entries also. From doing this activity, no confusion will create in future.

    Regards

    Amit  Sharma

    www.erpconsultors.com

      

  • AD-22040756-1 Profile Picture
    AD-22040756-1 642 on at

    Can you show where in her post she stated "But She do not want to see these entries while reconciliation." ?

    The only thing she stated was the opposite, she does want to see them but she can't "When I run a new reconciliation it does not give me these transactions available to be matched, so I can’t clear them that way."

  • crawlenj Profile Picture
    crawlenj 130 on at

    Hi Andy,

    Thank you very much for your solution. This is exactly what I needed to mark reversed transactions as reconciled / closed.

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans