We have maximum procurement in Foreign Currency (FCY). The payment entries application against invoices in foreign currency makes incorrect impact in Gain & Loss General Ledger. Some impact goes to to Gain and Loss General Ledger and some impact goes to Purchase Rounding General Ledger. This should not have gone to Purchase Rounding, it should be Gain and Loss GL codes.
We are on MS Dynamics Nav 2013 R2 - India version.
You need to check your setups for the same and check whether account code are correctly selected in currency setup
Thanks Amol. The setup is correct but the allocation goes in respective GL is incorrect. Also the entries goes to Purchase Rounding GL also, which should not have.
It works fine with our earlier version 4.0
Is there anu customization or have ypu recently update any hot fix?
Hi ShirishKalamkar ,
This is no an issue , Its a feature of the system, don't make misunderstand because it should be there , because Costumer/You usually didn't pay for cents
If "A" Item price is 55.99 customer will pay 60 he will never request the balance of 0.01 from them because its impossible to pay by cash or you may get from customer only
55.00 then your lost is 0.99
This are adjust by roundup Rounding General Ledger. Don't do any thing it should be there
Specifies the size of the interval to be used when rounding amounts in your local currency. You can also specify invoice rounding for each currency in the Currency table.
1.00 Round to whole numbers (no decimals - divisible by 1.00)
0.05 Round to a number divisible by 0.05
0.01 No rounding (ordinary currency decimals)
When an invoice amount is rounded, the program creates an invoice line that includes the rounded amount. The invoice amount after rounding can be seen before posting the invoice in the Sales Statistics or Purchase Statistics window.
To specify invoice rounding for a foreign currency, fill in the fields as follows:
Specifies whether an invoice amount will be rounded up or down. The program uses this information together with the interval for rounding that you have specified in the Inv. Rounding Precision (LCY) field.
You can use this field if your program is set up to round invoice amounts. The contents of this field determine whether the invoice amount to be rounded will be rounded up or down to the nearest interval as specified in the Invoice Rounding Precision field.
To see the available options, choose the field.
The program will round up digits that are >=5. Otherwise, the program will round down.
The program will round the amount up.
The program will round the amount down.
See the following examples for rounding types:
If you have inserted 1.00 in the Invoice Rounding Precision field, the amounts 1.25 and 1.75 will be rounded for the various options as follows:
1.25 will be rounded down to 1.00.
1.75 will be rounded up to 2.00.
1.25 will be rounded up to 2.00.
1.75 will be rounded down to 1.00.
I'm facing the same problem, when the payment is applied, an entry is made to foreign Gain/loss account when it shouldn't when the payment and invoice are recorded on the same date and at the same exchange rate.
Business Applications communities