Unable to change Exchange Rate on PL invoice

Good morning all,

I'm pulling my hair out here quite literally and hoping someone can give me some guidance.

Just recently turned on Multi-Currency for a customer and I have a training company which is mirror image of their live company. In the training company when going through posting an invoice to a new EURO supplier (their base currency is sterling), we can adjust the exchange rate at entry of the invoice, HOWEVER when we try to do it in the live company the exchange rate is greyed out……
I've gone through and checked the setup of the supplier, the pl set options, exchange rate setup. I'm logged in using same user id for both companies…

Just hoping somebody has come across this before and I've just missed something?

Example snips - able to edit Exchange Rate

Not able to edit exchange rate, it's greyed out?

Ta Claire

Find more posts tagged with

Comments

alan-bourke

As far as I can see the criteria for that being editable are:

The currency dropdown above has a value.

The applicable bank account or supplier are foreign currency

"EUR" is set up as a currency which it obviously is there.

lenw

Hi Claire

I don't have the full answer for you, but I think it may have something to do with 'Euro Triangulation'

This is what the Help says in 'Purchase Transaction Entries':

Exch. Rate:

The exchange rate for the currency. This defaults to the exchange rate defined on the System Exchange Rates form. In the case of Euro triangulation, exchange rates are calculated using special rules where more than one Euro zone currency is involved in the transaction.

So it may be something to do with the default Vat Code you may have set on this supplier. If the Vat Code has EC Sales Listing (ESL) - Triangulation ticked ON, then this may have to do with it.

So as a suggestion, try clearing out the Default Vat Code on this supplier (in Action - Options) and see if that helps at all.

Thanks

Len

claire-craig

Hi Len, you were on the money :-) and had just found it before your message came through.
The customer doesn't have any VAT codes with triangulation ticked on however, I had used a piece of bespoke to copy the live company to the training company and on comparing the ZXCHG.dbf's noticed that the fields "Triangulation Date", "EMU SL Exch.Rate", "EMU SL Exch.Rate" and "EMU PL Exch.Rate" where all populated but shouldn't have been and once I cleared the fields cleared out, we were able to edit the exchange rate again.
Thank you so much for taking the time to come back to me, very much appreciated.
Regards
Claire

Copyright © 2025 Infor. All rights reserved.