“Null” was returned in ”AmountHomeCurrency“ from Zuora UI, SOAP API, and AQuA API
“Null” was returned in ”AmountHomeCurrency“ or other currency conversion fields, such as below, from AOQL export, AQUA or DSE report.
Please check Mass Updater history, or use Get Custom Foreign Currency Exchange Rates REST API to query and double-check if the exchanges rate against "ProviderExchangeRateDate" was not uploaded.
- If yes, then please upload the missing foreign exchange rate and run the export again.
- If no, please compare the uploading and export time. Please upload the exchange rate first, then export.
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √