"Relational Adjmt Exch Rate Amt must not be 0.0 in Currency Exchange Rate Currency Code XXXX"

lee_d_clar · December 14, 2012, 4:43am

Hi,

Can anybody help figure out how to solve this warning message?

“Relational Adjmt Exch Rate Amt must not be 0.0 in Currency Exchange Rate Currency Code XXXX”

I’m just adding a new rate on the Currency Exchange Rate and the system automatically fills up the “Adjustment Exch. Rate Amount” & “Relational Adjmt Exch Rate Amt” by copying the values of the “Exchange Rate Amount” and “Relational Exch Rate Amt.”.

I have tested using 2 different databases. The earlier database has no error like that but that latest database is now experiencing that error.

Thanks in advance.

mohana_cse06 · December 14, 2012, 4:50am

May I know which version are you using?

and what steps are you following?

lee_d_clar · December 14, 2012, 4:56am

Version SG Dynamics NAV 5.0 SP1 (6.00.29626)

I’m adding new exchange rate for today’s date, 14,12,12, on Currency then Exchange Rate.

I filled up the field Starting Date … etc. then the system automatically fills up the “Adjustment Exch. Rate Amount” & “Relational Adjmt Exch Rate Amt” by copying the values of the “Exchange Rate Amount” and “Relational Exch Rate Amt.”.

I want to be those 2 fields I meantioned to be zero. Then when I changed it to zero, the error appears.

Thanks for the reply

mohana_cse06 · December 14, 2012, 4:58am

And the steps you are following please…

lee_d_clar · December 14, 2012, 5:02am

Version SG Dynamics NAV 5.0 SP1 (6.00.29626)

I’m adding new exchange rate for today’s date, 14,12,12, on Currency then Exchange Rate.

I filled up the field Starting Date … etc. then the system automatically fills up the “Adjustment Exch. Rate Amount” & “Relational Adjmt Exch Rate Amt” by copying the values of the “Exchange Rate Amount” and “Relational Exch Rate Amt.”.

I want to be those 2 fields I meantioned to be zero. Then when I changed it to zero, the error appears.

Thanks for the reply

mohana_cse06 · December 14, 2012, 5:06am

The system will no allow you to set 0 values in above fields.

The OnValidate tirgger has check for this

TESTFIELD(“Relational Adjmt Exch Rate Amt”);

I guess this behaviour is same in NAV5.0SP1 also…

lee_d_clar · December 14, 2012, 5:53am

I have 2 sample database using for this issue. The database with an earlier backup works fine, I can add new exchange rate and the system does not copy the values I mentioned above.

But on the latest database back-up, this error occurs.

What to do next?

Thanks,

mohana_cse06 · December 14, 2012, 6:00am

May be you have done some customization on the first database…

lee_d_clar · December 20, 2012, 3:53am

The table was not modified. on the first and two database.

Table ID: 330 - Currency Exchange Rate; Version List: NAVW16.00,NAVAP4.00.01

Is there any set-up that can relate on Currency Exchange Rate Table?

Thanks…

mohana_cse06 · December 20, 2012, 3:56am

I dont think so…

amol_salvi · December 20, 2012, 7:39am

Hi lee

You use this field and the Adjustment Exch. Rate Amount field to enter amounts that the program uses to calculate exchange rates that will be used by the Adjust exchange rates batch job. This batch job uses the adjustment exchange rate to make exchange rate adjustments (gain and loss entries) to G/L, customer, vendor and bank entries. The amount you enter in this field is related to the currency in the Relational Currency Code field.

Due to this you can set this field to zero.

lee_d_clar · December 21, 2012, 2:08am

I noticed that every time I’m adding new date for exchange rate the system copy the all values on the abaove line. Meaning it copies all the values prior date.

If the Adjustment Exchange Rate Amount and the Relational Adj. Exch.Rate Amount has value that is not equal to zero, then it will be copied by the next exchange rate line when I created a new one.

My database was not yet modified so I suspect this is still a standard function of teh system.

How can I make Adjustment Exchange Rate Amount and the Relational Adj. Exch.Rate Amount to become zero without any error message?

Thanks in advance…

mohana_cse06 · December 21, 2012, 4:32am

Yes, its standard functionality…

The previous rec values are copied in Form - OnInsertRecord trigger.

But why do you want to set them to 0?

amol_salvi · December 21, 2012, 4:57am

Hi Lee,

It is better you consult with Partner rather than changing the functionality …

All the best

lee_d_clar · December 21, 2012, 9:46am

The user wants it to be zero because she used to see those fields (the adjustment rate fields) equal to zero.

I know that it has no effect if there is no adjustment will be done. But I’m thinking now of the ways how to address it to the user that may able them to understand that it is standard function and has no bearing at all.

Thanks for all the inputs…

mohana_cse06 · December 21, 2012, 9:49am

Lets try

All the Best

lee_d_clar · December 24, 2012, 2:45am

The user wants it to be zero because she used to see those fields (the adjustment rate fields) equal to zero.

I know that it has no effect if there is no adjustment will be done. But I’m thinking now of the ways how to address it to the user that may able them to understand that it is standard function and has no bearing at all.

Thanks for all the inputs…

mohana_cse06 · December 24, 2012, 4:30am

You can hide those fields from Form so that she cannot be able to see them