Happy Business Starts Here

Re: Can we add the exchange rate on an invoice report?

Nigel
Master

Can we add the exchange rate on an invoice report?

On an invoice item report it lists in local currency for the deal - but I can't see a way to add the exchange rate used on that day, or a way to add the ammount in Home currency as well.  Is there a way to get those added?

7 REPLIES 7
Yong
Support SME

Re: Can we add the exchange rate on an invoice report?

The first method is If the exchange rate does not change frequently, you can use 'Display Custom Fields on the Invoice' and assign the rate to a custom field. When the exchange rate needs to be updated, you can update the custom field value.  https://knowledgecenter.zuora.com/CB_Billing/IA_Invoices/Creating_a_Custom_Invoice_Template/E_Displa...

 

The second one needs development. You can write your own logic that receives a call-out when the invoice is generated. Calculates the conversion to a local currency and populates a custom field on the Invoice object that is shown on the Invoice Template.

 

The third one is you can try to add a custom field on the Invoice object that is shown on the Invoice Template. There then is a manual process to populate this field when it is required. We have customers that have automated this using our Workflow (https://community.zuora.com/t5/Integrations-Extensions/Workflow/td-p/23777) application, it is an extra paid app and needs customization. 

Nigel
Master

Re: Can we add the exchange rate on an invoice report?

Hi @Yong,

The question was about reporting, not about adding it to the invoice template.  Is it possible to get the home currency and/or exchange rate in an invoice item report?

Yong
Support SME

Re: Can we add the exchange rate on an invoice report?

The feature Currency Conversion will satisfy your requirement probably. "If your tenant has the Currency Conversion feature enabled, you can include foreign currency conversion data in data source exports."

Reference: https://knowledgecenter.zuora.com/CD_Reporting/AB_Reporting_Quick_Reference/D_Currency_Conversion

https://knowledgecenter.zuora.com/CC_Finance/D_Finance_Settings/F_Foreign_Currency_Conversion

Nigel
Master

Re: Can we add the exchange rate on an invoice report?

@Yong Thanks - we have that turned on but it's not working it seems. But that option is supposed to work for Reports as well? (and not just data source exports?)

Yong
Support SME

Re: Can we add the exchange rate on an invoice report?

that option is supposed to work for Reports as well. If still no luck, please submit a support ticket at support.zuora.com

Nigel
Master

Re: Can we add the exchange rate on an invoice report?

Thanks 🙂

Eva
Zuora Support
Zuora Support

Re: Can we add the exchange rate on an invoice report?

Hi, @Nigel

 

Foreign currency conversion data can be included in data source exports. Unfortunately, foreign currency conversion data is unavailable in Zuora Reporting as you can refer to https://knowledgecenter.zuora.com/Zuora_Central/Reporting_and_Analytics/AB_Reporting_Quick_Reference... .

One suggestion, you are able to get the foreign currency conversion data from financial reports, such as "Accounting Period Revenue Detail" or journal entry



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √