SBX - Search With Button

SBX - Forum Post Title

Foreign Currency Payment Application Entries.

Microsoft Dynamics NAV Forum

ShirishKalamkar asked a question on 2 Feb 2017 5:44 AM

Question Status

Suggested Answer

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.

Reply
Ammolh Saallvi responded on 2 Feb 2017 5:48 AM
My Badges
Suggested Answer

You need to check your setups for the same and check  whether account code are correctly selected in currency setup

Reply
ShirishKalamkar responded on 2 Feb 2017 6:40 AM

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

Reply
Ammolh Saallvi responded on 2 Feb 2017 9:53 AM
My Badges
Suggested Answer

Is there anu customization or have ypu recently update any hot fix?

Reply
Maneesha De Silva responded on 2 Feb 2017 10:40 AM
My Badges
Suggested Answer

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.

For example:

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.

Nearest

The program will round up digits that are >=5. Otherwise, the program will round down.

Up

The program will round the amount up.

Down

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:

Nearest:

1.25 will be rounded down to 1.00.

1.75 will be rounded up to 2.00.

Up:

1.25 will be rounded up to 2.00.

1.75 will be rounded up to 2.00.

Down:

1.25 will be rounded down to 1.00.

1.75 will be rounded down to 1.00.

Ref :

Reply
Ahmed Al Wadiya responded on 14 Apr 2019 4:47 PM

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.

Reply
Ammolh Saallvi responded on 2 Feb 2017 5:48 AM
My Badges
Suggested Answer

You need to check your setups for the same and check  whether account code are correctly selected in currency setup

Reply
Ammolh Saallvi responded on 2 Feb 2017 9:53 AM
My Badges
Suggested Answer

Is there anu customization or have ypu recently update any hot fix?

Reply
Maneesha De Silva responded on 2 Feb 2017 10:40 AM
My Badges
Suggested Answer

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.

For example:

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.

Nearest

The program will round up digits that are >=5. Otherwise, the program will round down.

Up

The program will round the amount up.

Down

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:

Nearest:

1.25 will be rounded down to 1.00.

1.75 will be rounded up to 2.00.

Up:

1.25 will be rounded up to 2.00.

1.75 will be rounded up to 2.00.

Down:

1.25 will be rounded down to 1.00.

1.75 will be rounded down to 1.00.

Ref :

Reply

SBX - Two Col Forum

SBX - Migrated JS