× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi
I am having a problem.
1. The base currency is Mexican Pesos.
2. The Order is in USD.
3. The exchange rate is 9.5037000.
4. The amounts in the two lines in the order are US$ 1417.00 and US$ 1625.00.
5. Invoiced it.

Now there is a difference in the Base Debit (LHDRAM) and Base Credit fields 
(LHCRAM) in GLH, because
while converting the transaction amounts (in USD) to base amounts (in Mexican 
Pesos), it is doing the following calculations

Transaction       Rate           Base

1417.00            9.5037        13466.7429  rounded to 13466.74
1625.00            9.5037        15443.5125  rounded to 15443.51
--------------                              -------------------
 3042.00           9.5037        28910.2554  rounded to 28910.26

So there is a differece of .01 between the debit and credit (since the total of 
credit is 13466.74 + 15443.51 = 28910.25  and the debit column has 28910.26).
How can I solve this?
TIA
Amitava




As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.