Fixed exchange rate on product receipt and invoice

I have a requirement to set a fixed exchange rate on product receipt and invoice on posting. I have managed to do this on invoice but I’m having challenges to have this on product receipt. I did set the values on fields FixedExchRate, ExchRate, ReportingCurrencyExchangeRate and ExchRateSecondary on the PurchParmTable but it is not using anything from these values. It is still picking the exchange rate from General Ledger.

Anyone who can assist?

1 Like

Hi Huggins,

This is a pretty common challenge. In D365, product receipts usually pull the exchange rate straight from the General Ledger, which is why the values you set in PurchParmTable aren’t being used.

A couple of things you could try:

  • Add a small extension to override how the rate is picked during receipt posting.

  • Double-check posting profiles or currency setups, since they can force the GL rate.

  • Some teams handle this with an event handler to update the exchange rate fields right before posting.

We had a client face something similar; fixed rate worked on invoices, but not receipts, and a light customization solved it. Might work for you as well. If not, happy to help further. You can always reach me at hardik.gupta@allgrowtech.com