Revenue Recognition Schedule

Internal ID: revrecschedule

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
amortizationperiod integer false Recognition Period false This field sets the number of periods over which the schedule will amortize. For example, if you enter 12, then the schedule runs for 12 periods starting from the Rev Rec Start Date. If both the Rev Rec Start Date and Rev Rec End Date are entered, then those dates override the recognition period set on the template. Note: If either the Rev Rec Start Date or Rev Rec End Date field is empty, NetSuite populates either date based on the recognition period.
amortizationtype select false Type false Select the kind of template you are creating: * Standard – Select this type if you are able to enter a Method and Term Source for the template. * Variable – Select this type to use this template for percent-complete recognition. Variable templates are selected on item records and amortization amounts are determined by job completion amounts. Note: If you select Variable, you cannot set the following template fields: Recognition Method, Recognition Term Source, Recognition Period, Period Offset and Start Offset.
externalid text false ExternalId false
initialamount rate false Initial Amount false Enter a percentage or amount to be recognized in the first recognition period. The remaining amount is then recognized according to the set amortization method.
isinactive checkbox false Inactive false Check this box if you no longer want to use this template or schedule.
ispublic checkbox false Public false This field indicates whether this revenue recognition template is available to other users.
job select false Project false Indicates the project associated with this schedule. The percent of project completion determines the amount of revenue to recognize for each period. A project can be associated only with variable revenue recognition schedules.
name text false Name true Enter a name for this template or schedule.
periodoffset integer false Period Offset true Specify the number of periods to postpone the start of recognition for the entire schedule. For example, if your amortization terms are based on 30-day periods, enter a 2 in this field to wait 60 days before you begin recognizing revenue. This can be useful for services you sell that have a probationary or trial period. Setting a period offset does not change the number of periods in the schedule.
recogintervalsrc select false Term Source false The Recognition Term Source controls how the recognition period is determined. Select from the following: * Rev Rec Dates Specified on Transaction – sources the invoice or cash sale The revenue recognition period is determined by Rev Rec start and end dates entered on the invoice or cash sale. * Rev Rec Dates Specified on Sales Order – sources the sales order The revenue recognition period is determined by Rev Rec start and end dates entered on the sales order. Note: This choice appears only when you use the Sales Order feature. * Billing Schedule, Transaction Date on Sales Order – sources the transaction date of the sales order This term source creates a schedule to recognize revenue based on the sales order transaction date. NetSuite dates subsequent invoices based on the assigned billing schedule. * Billing Schedule, Rev Rec Date on Sales Order - sources the Rev Rec dates from the sales order. This term source creates a schedule to recognize revenue based on the sales order revenue recognition dates, not the transaction dates.
recurrencetype select false Method false Set the terms to post income from the net sales amount: * Straight-line, by even periods – Amortizes income evenly for each period. Currency amounts are not prorated based on the number of days in any period. * Straight-line, prorate first & last period – Amortizes equal amounts for periods other than the first and the final period, regardless of the number of days in each period. Amounts are prorated for the first period and the final period based on the number of days in each period. * Straight-line, using exact days – Amortizes amounts individually for each period based on the number of days in each period. * Straight-line, prorate first & last period (period-rate) – Determines the full number of periods in the schedule and allocates revenue based on the proportional period amount. * Custom – Enables you to define amortization terms that can include uneven periods, amounts and multiple income accounts.
revrecoffset integer false Start Offset true Specify the number of periods to postpone the start of the recognition for a schedule. Setting a period offset changes the number of periods in the schedule because it postpones the beginning, but does not change the final period of the schedule.
totalamount currency2 false Amount false This field displays the total amount to recognize for the schedule, including amounts already recognized. If you enabled the Allow Users to Modify Revenue Recognition Schedule preference, this field can be edited. When you change this amount, the amount of each line of the schedule updates in proportion to the amount change. Only amounts that have not yet been recognized can be changed. The total amount of the schedule must always equal the sales amount or VSOE allocation amount of the related line item.

Sublists

recurrence - Custom Recurrence Pattern

Internal ID Type Label Required Help
incomeaccount select Account false
periodoffset integer Period Offset true
postingperiod text false
recamount rate Amount true

Tabs

Name Label
history System Notes
meta Recurrence

Search Joins

Join ID Join Description Actual Join Name
appliedtotransaction Applied To Transaction Transaction
customer Customer Customer
item Item Item
user User Employee

Search Filters

Internal ID Type Label
accountingbook select Accounting Book
amorstatus select Status
amortizedamount currency Total Recognized
amortype select Type
amount currency Amount
currency select Schedule Currency
deferredamount currency Remaining Deferred Balance
destacct select Destination Account
initialamt currency Initial Amount
internalid select Internal ID
internalidnumber integer Internal ID (Number)
isrecognized checkbox Is Recognized?
jedoc select Journal
name text Schedule Name
pctcomplete float % Complete
pctrecognition float % Recog.
periodoffset integer Period Offset
postperiod select Posting Period
scheddate date Date
schedulenumber integer Number
schedulenumbertext text Number/ID
sourceacct select Source Account
srctranpostperiod select Source Transaction Posting Period
srctrantype select Transaction Type
startoffset integer Start Offset
templatename text Template Name
useforeignamounts checkbox Use Transaction Currency

Search Columns

Internal ID Type Label
accountingbook select Accounting Book
amorstatus text Status
amortemplate text Template Name
amortizedamount currency Total Recognized
amortype text Type
amount currency Amount (Schedule Total)
currency text Schedule Currency
deferredamount currency Remaining Deferred Balance
destacct text Destination Account
initialamt currency Initial Amount
internalid select Internal ID
isrecognized checkbox Is Recognized?
jedoc text Journal
linesequencenumber select Line Sequence Number
name text Schedule Name
pctcomplete percent % Complete
pctrecognition percent % Recog.
periodoffset integer Period Offset
recuramount currency Amount
recurfxamount currency Amount (Foreign Currency)
scheddate date Date
schedulenumber text Number
sourceacct text Source Account
srcdocline text Source Transaction Line
srctran text Source Transaction
srctranpostperiod text Posting Period
startoffset integer Start Offset
useforeignamounts checkbox Use Transaction Currency