Subject: Rounding of Debit and Credit Amounts in GLH From: "Amitava Banerjee" Date: Fri, 15 Feb 2002 16:06:46 -0600 List-archive: List-help: List-id: SSA's BPCS ERP System List-post: List-subscribe: , List-unsubscribe: ,

```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.