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.
Inactivated templates no longer appear in lists and cannot be used to create schedules.
To view inactivated templates or to reactivate them, check the Show Inactives box on the Revenue Recognition Templates list. |
ispublic |
checkbox
|
false |
Public |
false |
|
job |
select
|
false |
Project |
false |
|
name |
text
|
false |
Name |
true |
Enter a name for this template.
The name you enter here appears in the Revenue Recognition Template dropdown on item records. |
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:
1. 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.
2. 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.
3. Straight-line, using exact days – Amortizes amounts individually for each period based on the number of days in each period.
4. 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.
5. 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 |
|