Fail to reverse payment journal lines due to out of balance
howareyou
Member Posts: 2
Dear all,
My company is using Navision 4.0. We have a strange issue today that our account tries to reverse some payment journal lines. She unapplied them, then she reverse vendor ledger entries firstly. ALL of them were unapplied successfully.
Then she performed "Reversal" by clicking button "Function\Reverse Transaction.. against those unapplied entries". Some payment journal lines were reversed but few failed, and got the error message "You cannot reverse the transaction because it is out of balance"
I took long time to check those entries which were unapplied successfully but failed to reversed as well as their original payment journal lines. Then I find, those unapplied entries were balanced, the amount of G/L entries of original payment journal lines were balanced, too, but the additional-currency amount of G/L entries of original payment journal lines WERE NOT. There is 0.0001 difference in it. Please see highlights in pictures fore more detail.
G/L entries for payment journal lines
G/L entries after unapplying
I have some questions about this:
1. Is it the reason we cannot reverse those payment journal transactions? By Exchange loss/gain?
2. Why we could post payment journal successfully but have problem to reverse them?
3. How should we do to reverse successfully those entrie?
I really appreciate your kind advice!
Best Regards,
SH
PS: I supplement pictures about reverse transaction entries, hope this can provide more information.
My company is using Navision 4.0. We have a strange issue today that our account tries to reverse some payment journal lines. She unapplied them, then she reverse vendor ledger entries firstly. ALL of them were unapplied successfully.
Then she performed "Reversal" by clicking button "Function\Reverse Transaction.. against those unapplied entries". Some payment journal lines were reversed but few failed, and got the error message "You cannot reverse the transaction because it is out of balance"
I took long time to check those entries which were unapplied successfully but failed to reversed as well as their original payment journal lines. Then I find, those unapplied entries were balanced, the amount of G/L entries of original payment journal lines were balanced, too, but the additional-currency amount of G/L entries of original payment journal lines WERE NOT. There is 0.0001 difference in it. Please see highlights in pictures fore more detail.
G/L entries for payment journal lines
G/L entries after unapplying
I have some questions about this:
1. Is it the reason we cannot reverse those payment journal transactions? By Exchange loss/gain?
2. Why we could post payment journal successfully but have problem to reverse them?
3. How should we do to reverse successfully those entrie?
I really appreciate your kind advice!
Best Regards,
SH
PS: I supplement pictures about reverse transaction entries, hope this can provide more information.
0
Categories
- All Categories
- 75 General
- 75 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions