Deleted Bank Reconcilliation Lines ... nearly.
bob_up
Member Posts: 155
We added an option to the bank reconcilliation form to delete all unreconciled lines. Unfortunately, our modification didnt fire the code in the OnDelete trigger which clears down the statement links on the bank, BACS and cheque ledger entry tables.
So now these unreconciled ledger entries dont get get picked up when you run 'suggest lines' in bank reconcilliation because they have a 'statement status' which is not 'Open'. The bank account ledger entries concerned also still have the "Statement No." and "Statement Line No." from the previous reconcilliation.
I am hoping that I can create a batch job to read these entries and clear these statement fields so that the ledger entries will get picked up by the suggest lines option.
Does anyone have any advice ? [-o<
So now these unreconciled ledger entries dont get get picked up when you run 'suggest lines' in bank reconcilliation because they have a 'statement status' which is not 'Open'. The bank account ledger entries concerned also still have the "Statement No." and "Statement Line No." from the previous reconcilliation.
I am hoping that I can create a batch job to read these entries and clear these statement fields so that the ledger entries will get picked up by the suggest lines option.
Does anyone have any advice ? [-o<
0
Comments
-
Either way, you will need to modify ledger entries....
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 333 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions