You’re offline. This is a read only version of the page.
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,524
Super User 2024 Season 2
#2
Martin Dráb
228,493
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (