Mark bank transactions on general ledger as closed

(0) Share

Report

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?

All responses (8)

Answers (1)

crawlenj 130 on at

Like (1)

Report

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 624 on at

Like (0)

Report

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 3,025 on at

Like (0)

Report

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 624 on at

Like (1)

Report

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 11,425 User Group Leader on at

Like (0)

Report

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 624 on at

Like (1)

Report

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 130 on at

Like (0)

Report

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 3,025 on at

Like (0)

Report

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