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?
Hi Andy,
Thank you very much for your solution. This is exactly what I needed to mark reversed transactions as reconciled / 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."
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
It looks like she is incorrectly calling 'Bank Account Ledger Entries' as 'General Ledger' otherwise she wouldn't see the Open field
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.
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.
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?
Hi,
Pls create one Batch Job and Mark Open Entries false.
Regards
Amit Sharma
www.erpconsultors.com
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148