Amortization Template

Internal ID: amortizationtemplate

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
acctcontra select false Contra Account false Select the account that accumulates amortized balances. This is most often used for depreciation schedules.
acctdeferral select false Deferral Account false Select Default to post deferred expense amounts to the deferred expense account on the item or expense line of the transaction. Select a specific GL account to override the account on the item or expense line of the transaction and use the deferred expense account from the template.
accttarget select false Target Account false Select Default to post amortized expenses to the expense account specified on the bill or item record. Select a specific GL account to override the expense account on the item or expense line of a transaction and use the target account from the template.
amortizationperiod integer false Amortization Period false Enter the number of periods over which the amount should be amortized. For example, you can enter 60 to amortize the amount over 60 periods starting from the amortization start date. Note: The starting period is specified by the amortization start date on bills. If no amortization start date is specified, the posting date of the bill is the amortization start date. If an amortization end date is indicated on the bill, you do not need to complete this field.
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 Amortization Templates list.
name text false Name true Enter a name for this template. The name you enter here appears in the Amortization Template dropdown on item records.
periodoffset integer false Period Offset true Specify the number of periods to postpone the start of amortization for the entire schedule. The first period to amortize has an offset of zero. 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 amortizing expenses for this line. You can amortize different amounts to different accounts within the same period when you set several lines to the same period offset value. Setting a period offset does not change the number of periods in the schedule.
recogintervalsrc select false Term Source false The Term Source controls how the amortization period is determined. Select from the folowing: * Transaction Date – Sources the date specified in the originating transaction * Receipt Date – Sources the receipt date on bills associated with a purchase receipt. Then, the receipt date is the amortization start date.
recurrencetype select false Method false Set the terms to post the expense: * Straight-line, by even periods – Amortizes the expense evenly for each period. 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 the expense based on the proportional period amount. * Custom – Enables you to define amortization terms that can include uneven periods, amounts and multiple expense accounts.
residual rate false Residual false Enter an amount or percentage to remain in the deferral account and not be amortized. A residual amount generally represents the salvage value of a fixed asset. Note: A residual amount entered on a transaction overrides a residual amount entered on an item record.
revrecoffset integer false Start Offset true Specify the number of periods to postpone the start of the recognition for a schedule. Note: Setting a start 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 shows the total amortization amount for the schedule, including amounts already recognized and amounts yet to be recognized. If you enabled the Allow Users to Modify Amortization Amount 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 purchase amount.

Sublists

recurrence - Custom Recurrence Pattern

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

Search Joins

Join ID Join Description Actual Join Name
user User Employee

Search Filters

Internal ID Type Label
amormethod select Method
amorperiod integer Amortization Period
amorstartoffset integer Start Offset
amortermsrc select Term Source
amortype select Type
contraaccount select Contra Account
deferralaccount select Deferral Account
formuladate date Formula (Date)
formulanumeric float Formula (Numeric)
formulatext text Formula (Text)
internalid select Internal ID
internalidnumber integer Internal ID (Number)
isinactive checkbox Inactive
name select Name
periodoffset integer Period Offset
targetaccount select Target Account
useforeignamounts checkbox Use Transaction Currency

Search Columns

Internal ID Type Label
amormethod text Method
amorperiod text Amortization Period
amorstartoffset text Start Offset
amortermsrc text Term Source
amortype text Type
contraaccount text Contra Account
deferralaccount text Deferral Account
formulacurrency currency Formula (Currency)
formuladate date Formula (Date)
formuladatetime datetime Formula (Date/Time)
formulanumeric float Formula (Numeric)
formulapercent percent Formula (Percent)
formulatext text Formula (Text)
internalid select Internal ID
isinactive text Inactive
name text Name
periodoffset text Period Offset
targetaccount text Target Account
useforeignamounts checkbox Use Transaction Currency