Adding Exchange Rate to Invoices

Rebecca Cinnamond

I am currently trying to add the exchange rate to the order invoice report. Upon investigating SPs called from the report, it appears that when the invoice is generated, it pulls the exchange rate from the invoice header. 

Where is the invoice header generated when using standard order invoicing? I can't seem to pinpoint a specific SP or script that creates this entry. 

I cannot pull the exchange rate from the exchange rates table as this will have an impact when reprinting older invoices. This is why I want to see the original select statement. 

Rebecca Cinnamond

After further testing it appears that pulling the exchange rate from the invoice header works fine due to it being created before the report is generated, allowing the load collection to work correctly! Hopefully this saves someone else from headache!