Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
NAV2017 (NA)Bank Reconcilation, deposits not cleared in previous month not showing on current month
KELLI
Member Posts: 21
Hello,
When my client is preparing their Bank Reconciliation for the current month (August), some deposits that did not clear the bank last month (July) but were recorded as deposits in NAV2017 for July, are not showing the deposit lines of the reconciliation to select to be cleared. When the bank reconciliation was done for July they did not populate the Cleared Boolean on the deposit lines.
Looking into the Bank Account Ledger Entry table I see the deposits there but the Statement Status = Bank Acc. Entry Applied and Open = Yes.
If during the bank reconciliation process for July, I do not populate the Cleared Boolean box, wouldn't the Statement Status stay at Open?
What is the logic to designate the uncleared entry as Bank Acc. Entry Applied? And if it is a straight forward user is selecting the checks/deposits that cleared, why does it get that designation? It seems this is preventing it from showing in the current month's bank reconciliation.
What would happen if I changed the status on those entries to Open? What would I be breaking?
When my client is preparing their Bank Reconciliation for the current month (August), some deposits that did not clear the bank last month (July) but were recorded as deposits in NAV2017 for July, are not showing the deposit lines of the reconciliation to select to be cleared. When the bank reconciliation was done for July they did not populate the Cleared Boolean on the deposit lines.
Looking into the Bank Account Ledger Entry table I see the deposits there but the Statement Status = Bank Acc. Entry Applied and Open = Yes.
If during the bank reconciliation process for July, I do not populate the Cleared Boolean box, wouldn't the Statement Status stay at Open?
What is the logic to designate the uncleared entry as Bank Acc. Entry Applied? And if it is a straight forward user is selecting the checks/deposits that cleared, why does it get that designation? It seems this is preventing it from showing in the current month's bank reconciliation.
What would happen if I changed the status on those entries to Open? What would I be breaking?
0
Answers
When the Bank Account Ledger Entry appears on a Bank Reconciliation (open or posted not cleared) the line will have a Statement Status of Bank Acc. Entry Applied.
To solve the issue for my client, although not ideal, in the Bank Account Ledger Entries I changed the Statement Status to Open. This allowed them to move forward with the bank reconciliation.