Reconciliation statement balance with payment ledger entries

MrTE
Member Posts: 4
Hi all,
I'm currenly using Nav5 with GB localisation. When I print out a bank statement of the previous day, the beginning and ending balance of the statement is shown on it. When I''m entering all the statement receivements and payments in the payment ledger, the total of the entries should reconcile to the change in balance shown on the statement. I would like to have 3 fields in the header (to be created) of the payment ledger with beginning balance, ending balance and the mutation between these. This mutation should reconcile to the total of the mutations which are entered in the payment ledger subform. If this doesn't reconcile, then the payment ledger entries can't be booked. Is there some kind of standard functionality or add on which makes this possible?
Thanks,
MrTE
I'm currenly using Nav5 with GB localisation. When I print out a bank statement of the previous day, the beginning and ending balance of the statement is shown on it. When I''m entering all the statement receivements and payments in the payment ledger, the total of the entries should reconcile to the change in balance shown on the statement. I would like to have 3 fields in the header (to be created) of the payment ledger with beginning balance, ending balance and the mutation between these. This mutation should reconcile to the total of the mutations which are entered in the payment ledger subform. If this doesn't reconcile, then the payment ledger entries can't be booked. Is there some kind of standard functionality or add on which makes this possible?
Thanks,
MrTE
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