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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 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
Applying Entries in Different Currencies
alihh
Member Posts: 3
Hello,
I have an invoice in AED, I want to pay it in USD.
I created a payment line in the journal with a USD currency, I applied it to an Invoice in AED, I set the amount to apply field to 2000 AED, it automatically calculated it in USD to 544.57$.
Now when I post the payment and go to vendor ledger entry, in the invoice I applied to, the application amount appears as 1999.99 AED !!!
After some investigations, I found the below :
2000 AED = 820,346.00 LCY
2000 AED = 544.5738..... USD
Navision rounded the 544.5738.. to 544.57 $
So now the Payment is
544.57 USD = 820,340.25 LCY instead of 820,346.00 LCY due to the rounding, and 820,340.25 LCY = 1999.99 AED not 2000 AED.
I don't want to modify the rounding precision for the USD, as it will not always solve the problem.
how should I solve this issue ? I need the Payment Amount on the Application to be the same as the one I set in the "Amount to Apply".
Thank You
I have an invoice in AED, I want to pay it in USD.
I created a payment line in the journal with a USD currency, I applied it to an Invoice in AED, I set the amount to apply field to 2000 AED, it automatically calculated it in USD to 544.57$.
Now when I post the payment and go to vendor ledger entry, in the invoice I applied to, the application amount appears as 1999.99 AED !!!
After some investigations, I found the below :
2000 AED = 820,346.00 LCY
2000 AED = 544.5738..... USD
Navision rounded the 544.5738.. to 544.57 $
So now the Payment is
544.57 USD = 820,340.25 LCY instead of 820,346.00 LCY due to the rounding, and 820,340.25 LCY = 1999.99 AED not 2000 AED.
I don't want to modify the rounding precision for the USD, as it will not always solve the problem.
how should I solve this issue ? I need the Payment Amount on the Application to be the same as the one I set in the "Amount to Apply".
Thank You
0
Answers
Your issue is more related to the functional side. I think One should be frustrated on such small things. This is not professionalism. All the folks working on this forum are contributing their valuable time & money. Such comments can spoil their spirits. So if you have a very urgent kind of problem, Go to Microsoft, generate the ticket and your problem will be resolved. I would recommend try to go through this circle once to understand the worth of the people who are working freely for the community.
However following link might help you.
https://community.dynamics.com/nav/f/34/t/220874
Rehan Satti
Microsoft Dynamics NAV Technical Consultant
Please verify the answer if it satisfy your question. This will help other members of community.