Skip to main content

Notifications

Business Central forum
Answered

Mark bank transactions on general ledger as closed

Posted on by 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?

  • crawlenj Profile Picture
    crawlenj 130 on at
    RE: Mark bank transactions on general ledger as closed

    Hi Andy,

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

  • AD-22040756-1 Profile Picture
    AD-22040756-1 622 on at
    RE: Mark bank transactions on general ledger as closed

    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."

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: Mark bank transactions on general ledger as closed

    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 622 on at
    RE: Mark bank transactions on general ledger as closed

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

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Mark bank transactions on general ledger as closed

    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.

  • Verified answer
    AD-22040756-1 Profile Picture
    AD-22040756-1 622 on at
    RE: Mark bank transactions on general ledger as closed

    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.

  • crawlenj Profile Picture
    crawlenj 130 on at
    RE: Mark bank transactions on general ledger as closed

    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?

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: Mark bank transactions on general ledger as closed

    Hi,

    Pls create one Batch Job and Mark Open Entries false.

    Regards

    Amit Sharma

    www.erpconsultors.com

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans