Payment Reconciliation Journal not Mapping the correct Text to relevant Sub-ledger Account

AntonyNgorora7
Member Posts: 18
Hi All,
Please may you kindly assist,
The Payment Reconciliation Journal is not Mapping the correct Text to the relevant Account.
When the CSV file (Bank Statement is uploaded) the transactions are populated.
But only the G/L Accounts Map the text to the relevant account.
All Sub-ledger accounts, Vendor and Customer are not populated, but All the Accounts are defined on the Table 1251 (Text-to-Account Mapping table) .
Perhaps something is causing this in the background.
Please advise.
Regards
Antony
Please may you kindly assist,
The Payment Reconciliation Journal is not Mapping the correct Text to the relevant Account.
When the CSV file (Bank Statement is uploaded) the transactions are populated.
But only the G/L Accounts Map the text to the relevant account.
All Sub-ledger accounts, Vendor and Customer are not populated, but All the Accounts are defined on the Table 1251 (Text-to-Account Mapping table) .
Perhaps something is causing this in the background.
Please advise.
Regards
Antony
0
Answers
-
Hi - The answer to this was fairly simple. There were Open Bank Account Ledger Entries in the System that had not been Reconciled. So the System quickly mapped these entries that have similar transaction texts and transaction amounts to the new Entries brought in on the new Payment Reconciliation Journal.
The issue has been resolved.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 320 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