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 |
This field shows the name of the template that created this schedule. |
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. |