Howdy, Stranger!
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
- 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
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Problem in Revaluation
meh
Member Posts: 50
I have many issues regarding the revaluation and i am not able to tackle them.
1) The first thing is that even if i have kept no adjustment in Reporting tab of Exchange rate adjustment the transactions are revalued for few specific g/l a/c. Is there any way to stop revaluation entries for multicurrency transactions passing from vendor and customer ledger entries.
2) Secondly we do provision on FCY and payment in equivalent LCY.Because the payment were not applied against the provision revaluation is done in all open FCY ledger and customer entries so we are not able to generate the report to see the actual payables and receivables. Even if we are trying to apply the posted transaction due to revaluation the partial amount is only applied. It is creating a big problem for us to handle as we might have to pass manual entries to adjust the receivables and payables.And we have more than 15000 lines so it might give a big trouble
.Please suggest as our implementing partner couldnt provide any solution in regards and that too we cannot reverse the system generated revaluation entries.
3)In some cases the provision are made in diff exchange rate in FCY then that in the actual rate of the month so in this case there will be definately revaluation in the open ledger entries and as the payment is done in LCY there is no point of realisation , here too we have a problem in revaluation. Even we try to apply and post the transaction the transactions are not fully applies and there will be unapplied amount remaining in customer and vendor ledger entries.
Does navision has any alternate solution for revaluation ?? Or this is a huge mess dont know whether its because of the set up or any process error but it is making a big confusion to generate report from the payable and receivable module.
HOpe to hear back
1) The first thing is that even if i have kept no adjustment in Reporting tab of Exchange rate adjustment the transactions are revalued for few specific g/l a/c. Is there any way to stop revaluation entries for multicurrency transactions passing from vendor and customer ledger entries.
2) Secondly we do provision on FCY and payment in equivalent LCY.Because the payment were not applied against the provision revaluation is done in all open FCY ledger and customer entries so we are not able to generate the report to see the actual payables and receivables. Even if we are trying to apply the posted transaction due to revaluation the partial amount is only applied. It is creating a big problem for us to handle as we might have to pass manual entries to adjust the receivables and payables.And we have more than 15000 lines so it might give a big trouble
.Please suggest as our implementing partner couldnt provide any solution in regards and that too we cannot reverse the system generated revaluation entries.3)In some cases the provision are made in diff exchange rate in FCY then that in the actual rate of the month so in this case there will be definately revaluation in the open ledger entries and as the payment is done in LCY there is no point of realisation , here too we have a problem in revaluation. Even we try to apply and post the transaction the transactions are not fully applies and there will be unapplied amount remaining in customer and vendor ledger entries.
Does navision has any alternate solution for revaluation ?? Or this is a huge mess dont know whether its because of the set up or any process error but it is making a big confusion to generate report from the payable and receivable module.
HOpe to hear back
0
Comments
Now as this has been done if not too many entries have been posted after this batch job I would have restored the last backup and would have ran this again without checking this boolean and then complete the backlog. If it is not too late.
Another way would be (which again is going to create good enough no. of entries ) is make the exchange rate as 1:1 and it would bring everything equal to ur LCY. This time u shud keep the boolean checked and then decide on what u want.
I would suggest you to catch ur partner and ask them to help u as they would be in better position to analyze ur db.
I am passing on manual entries to adjust the payables. But dont know what accounts shall i adjust because there any many entries passed by system while running adjust exchange rates batch.