Amortization Schedule

Internal ID: amortizationschedule

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
accountingbook select false Accounting Book false Select an accounting book. You may select the primary book or any secondary accounting book to which you have access.
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.
enddate date false End Date false The end date entered for this schedule appears here.
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.
job select false Project false Indicates the project associated with this amortization schedule. The percent of project completion determines the amount of amortize for each period. A project can be associated only with a variable amortization schedule.
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.
parentSched select false Template false
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.
remainingdeferredbalance currency false Remaining Deferred Balance false This field shows the amount on the schedule which has not yet been recognized.
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.
schedulenumber text false Number false This number is automatically generated when you use Auto-Generated Numbering. If the Name field for the schedule is blank, the auto-generated number is used.
sourcetran select false Created From false This field shows the transaction type that the schedule was created from. If you click this link to open the transaction, the line that generated the schedule is highlighted.
startdate date false Start Date false This shows the date expense recogntion begins for this schedule. The starting period is specified by the recognition start date on bills. If no recognition start date is specified, the posting date of the bill is the recognition start date.
status select false Status false The amortization status can be one of the following: * Not Started – No expense has yet been recognized. * In Progress – Some expense has been recognized, but not all. * Complete – All expense is recognized for this schedule.
totalamortized currency false Total Amortized false This field shows the amount on the schedule which has already been recognized to date.
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
id integer false
incomeaccount text false
isrecognized checkbox Is Recognized false
jdate date Date Executed false
journal text Journal false
periodoffset integer Period Offset true
postingperiod text false
recamount rate Amount true
recurdate date Date false

Search Joins

Join ID Join Description Actual Join Name
user User Employee
vendor Vendor Vendor

Search Filters

Internal ID Type Label
accountingbook select Accounting Book
amorstatus select Status
amortizedamount currency Total Amortized
amortype select Type
amount currency Amount
currencyname select Schedule Currency
deferredamount currency Remaining Deferred Balance
destacct select Destination Account
formuladate date Formula (Date)
formulanumeric float Formula (Numeric)
formulatext text Formula (Text)
initialamt currency Initial Amount
internalid select Internal ID
internalidnumber integer Internal ID (Number)
isrecognized checkbox Is Recognized?
name text Schedule Name
pctcomplete float % Complete
pctrecognition float % Recog.
periodoffset integer Period Offset
postperiod select Posting Period
residual currency Residual
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 select Template Name
amortizedamount currency Total Amortized
amortype text Type
amount currency Amount (Schedule Total)
currency select Schedule Currency
deferredamount currency Remaining Deferred Balance
destacct select Destination 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)
initialamt currency Initial Amount
internalid select Internal ID
isrecognized checkbox Is Recognized?
name text Schedule Name
pctcomplete percent % Complete
pctrecognition percent % Recog.
periodoffset integer Period Offset
recuramount currency Amount
recurfxamount currency Amount (Foreign Currency)
residual currency Residual
scheddate date Date
schedulenumber text Number
sourceacct select Source Account
srctran select Source Transaction
srctranpostperiod select Posting Period
startoffset integer Start Offset
useforeignamounts checkbox Use Transaction Currency