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
-
.
-3 -
-
no it's not0
-
Hi @alihh ,
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/220874Best Regards
Rehan Satti
Microsoft Dynamics NAV Technical Consultant
Please verify the answer if it satisfy your question. This will help other members of community.2
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