Example 3 - Allocation in reporting currency
In the following example, the different transaction currencies depict a multi-currency contract. The reporting currency is USD, according to the REPORTING_CURRENCY profile. The MULTI_CURR_FV_REPORT_LEVEL profile is set to Lowest Common Currency.
|
Line No |
SO Book Date |
Company Code |
Amount |
T.Curr |
F.Ex.Rate |
F.Ex.Date |
F.Curr |
G.Ex.Rate |
G.Ex.Date |
G.Curr |
|---|---|---|---|---|---|---|---|---|---|---|
|
1 |
01/01/2019 |
100 |
1000 |
EUR |
1.0 |
01/01/2019 |
EUR |
.80 |
01/01/2019 |
USD |
|
2 |
01/02/2019 |
200 |
2000 |
GBP |
1.0 |
01/02/2019 |
GBP |
.70 |
01/02/2019 |
USD |
|
3 |
01/03/2019 |
300 |
3000 |
USD |
1.0 |
01/03/2019 |
USD |
1.0 |
01/03/2019 |
USD |
|
4 |
01/04/2019 |
400 |
4000 |
GBP |
1.0 |
01/04/2019 |
GBP |
.72 |
01/04/2019 |
USD |
The functional currencies of all the lines are different, so allocations happen in the reporting currency (USD). The reporting exchange rate, used to calculate allocations, is based on the line-level exchange rates. When allocations are posted, Zuora Revenue derives the functional exchange rate based on the 1/reporting exchange rate at the line level. The reporting currency exchange rate for posting is the line-level reporting exchange rate.