Fair Value Price

Internal ID: fairvalueprice

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
currency select false Currency true Select a currency. If you use multiple currencies, the fair value for other currencies is derived using the transaction exchange rate.
customform select false Custom Form false
enddate date false End Date false The End Date is the date that this fair value price expires. When a revenue arrangement is created, its date is checked against this date to determine if this fair value price should be used. You can leave this date blank. If you enter a date here, you must also enter a Start Date. The Start Date must be before the End Date.
externalid text false ExternalId false
fairvalue float false Base Fair Value true Enter the base fair value for a unit of the item. This value is used in fair value range checking.
fairvalueformula select false Fair Value Formula true Select a formula to determine the calculated fair value. If the Item Revenue Category you select includes a fair value formula, that formula is selected by default. If the formula you want is not listed, you can create it without leaving this page. Click the New icon to the right of the field to open a new Fair Value Formula record in a popup window.
fairvaluerangepolicy select false Fair Value Range Checking Policy false A fair value range checking policy compares the discounted sales price of an item with the calculated fair value and determines what to use as the calculated fair value in the allocation ratio. If the Item Revenue Category you select includes a value for fair value range checking policy, that value is selected by default. Select one of the following options to use fair value range checking. * Boundary – If the discounted sales amount is between the high and low values of the range, it is used as the calculated fair value amount. If it is outside the range, either the high or low value is used, whichever is closer to the discounted sales amount. * Fair Value – If the discounted sales amount is outside the range, the calculated fair value is used. * High – If the discounted sales amount is outside the range, the high value is used. * Low – If the discounted sales amount is outside the range, the low value is used.
highvalue float false High Value false If you enter a number here, the High Value Percent is calculated automatically. Leave this field blank to calculate the value based on the High Value Percent you enter.
highvaluepercent percent false High Value Percent false Enter a percent of the base fair value to set the high end of the range. A percent sign is not required. The High Value is automatically calculated.
isvsoeprice checkbox false Is VSOE Price? false Check this box to indicate that the fair value is based on VSOE. If the box is not checked, the fair value is considered an estimate.
item select false Item false Select an item for this fair value price. You can leave this field blank if you select an item revenue category. If you select an item that belongs to an item revenue category, that field is automatically populated.
itemrevenuecategory select false Item Revenue Category false Select an item revenue category. If you select a category, you can leave the Item field blank.
lowvalue float false Low Value false If you enter a number here, the Low Value Percent is calculated automatically. Leave this field blank to calculate the value based on the Low Value Percent you enter.
lowvaluepercent percent false Low Value Percent false Enter a percent of the base fair value to set the low end of the range. A percent sign is not required. The Low Value is automatically calculated.
startdate date false Start Date false The Start Date is the date that this fair value price becomes effective. When a revenue arrangement is created, its date is checked against this date to determine if this fair value price should be used. You can leave this date blank if the End Date is also blank. If you enter a date here, you can leave the End Date blank. If you also enter an End Date, it must be later than the Start Date.
units text false Units false Select a value. When the fair value price includes a value for units and a revenue element includes an alternate quantity, fair value formulas that include {quantity} use the alternate quantity.
unitstype select false Units Type false Select a type of unit.

Search Filters

Internal ID Type Label
currency select Currency
enddate date End Date
externalid select External ID
externalidstring text External ID (Text)
fairvalue float Base Fair Value
fairvalueformula select Fair Value Formula
fairvaluerangepolicy select Fair Value Range Checking Policy
highvalue float High Value
highvaluepercent percent High Value Percent
internalid select Internal ID
internalidnumber integer Internal ID (Number)
isvsoeprice checkbox Is VSOE?
item select Item
itemrevenuecategory select Item Revenue Category
lowvalue float Low Value
lowvaluepercent percent Low Value Percent
startdate date Start Date
unitstype select Units Type

Search Columns

Internal ID Type Label
currency select Currency
enddate date End Date
externalid select External ID
fairvalue float Base Fair Value
fairvalueformula select Fair Value Formula
fairvaluerangepolicy select Fair Value Range Checking Policy
highvalue float High Value
highvaluepercent percent High Value Percent
internalid select Internal ID
isvsoeprice checkbox Is VSOE?
item select Item
itemrevenuecategory select Item Revenue Category
lowvalue float Low Value
lowvaluepercent percent Low Value Percent
startdate date Start Date
units select Units
unitstype select Units Type