RevPro currently only stores data in entered currency; functional currency amounts are displayed on screen and calculated for that display only. It would be great if RevPro would store data in functional currency in order to remediate rounding discrepancies seen in functional currency. Not doing causes several reconciliation issues, including the following:
Lines within the accounting detail of a single Revenue transaction may not zero out at the end of a contract because of rounding issues (i.e. the Contract Liability and Unbilled account balances related to that transaction may not clear once the revenue contract has ended).
RevPro reports in functional currency may not tie to one another due to how functional currency is being calculated. For example, the Accounting Detail functional currency columns do not tie to the monthly waterfall in functional currency.
Totals in a single report may not tie to the other columns in that same report. For example, if you sum up the revenue waterfall in functional currency by each month, it does not tie to the total column in that same report.
At the least, there should be a catch up at the end of any revenue contract to fix any rounding issues caused by the way RevPro calculates functional currency, otherwise all companies who post from RevPro to their GL in functional currency will have account balances that may never clear (or will clear beyond what was originally put into account) – all due to rounding. This is a frustrating issue that will likely affect every company that does business in more than one currency.
Currently, Zuora has it setup so that the Primary checkbox is only available in certain Field Sets (in Salesforce). Since this is a managed package customers cannot add the field to additional Field Sets (ie: zqu_Amend_Edit_Quote_Details). We run our business differently than Zuora assumes so this is required for us to keep quotes up to date and working properly.