Logic for Fair Value Price Selection with Fair Value Dimensions
When fair value dimensions are used on a fair value price record, the values you can select include Any or Unassigned. These values are in addition to specific values for the dimension. When you select Any, the fair value price applies to all items regardless of their dimension value, unless another fair value price matches exactly. Unassigned equates to null, and when selected, the fair value price applies to items with no value selected for the dimension.
For example, you add a fair value dimension for Location. Your account includes the following values for Location on the fair value price record:
-
Any
-
Unassigned
-
Americas
-
Asia
-
EMEA
You add Location as a fair value dimension and set up three fair value price records for an item as follows:
|
Record |
Item |
Base Fair Value |
Currency |
Fair Value Formula |
Location |
|---|---|---|---|---|---|
|
1 |
Service |
300 |
USD |
{FAIRVALUE}*0.8 |
Americas |
|
2 |
Service |
400 |
USD |
{FAIRVALUE}*0.8 |
- Any - |
|
3 |
Service |
500 |
USD |
{FAIRVALUE}*0.8 |
- Unassigned - |
The service item is included in various transactions with different locations. The fair value price list logic selects fair value prices for the locations as follows:
|
Location |
Fair Value Record |
|---|---|
|
Americas |
1 |
|
Asia |
2 |
|
EMEA |
2 |
|
no value |
3 |
If no fair value price record had been created with a Location value of Unassigned, the results would be different. In that case, the revenue element with no value for its location would also use fair value record 2.