Billing Schedule

Internal ID: billingschedule

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
applytosubtotal checkbox false Apply To Subtotal false Check this box to create a billing schedule applied to the pre-tax, pre-discount subtotal of a transaction. To create a billing schedule applied to a transaction subtotal, Type must be set to Standard and Recurrence Frequency must be set to Custom.
billforactuals checkbox false Invoice Actual Time Only false Check the box to invoice only actual time worked and recorded in Time Tracking in each interval. If checked, you cannot enter an initial amount. Clear the box to invoice planned time and actual time worked.
externalid text false ExternalId false
frequency select false Recurrence Frequency true Select the frequency for bills to recur. Select Daily to create bills once per day. Select Weekly to create bills once per week. Select Monthly to create bills once per month. Select Quarterly to create bills once per quarter. Select Twice a Year to create bills twice per year. Select Annually to create bills once per year. Select One Time to create a one-time bill. Select End of Period to create a bill at the end of a calendar period. Select Start of Period to create a bill at the beginning of a calendar period. Select Custom to create a new frequency.
inarrears checkbox false In Arrears false Check this box to bill at the end of each period, instead of the beginning. For example, on a billing schedule with no initial amount, standard monthly frequency, in arrears, the first invoice is created one month from one day after the sales order date. Note: When this box is not checked, the first invoice bills for the initial amount plus the first recurring amount.
initialamount ratehighprecision false Initial Amount true Enter the initial bill amount generated by this billing schedule. This can be entered as a percentage or a set currency amount if you use line-level billing schedules. You can only use percentage initial amounts if you apply billing schedules on the transaction level.
initialterms select false Initial Payment Terms false Choose the terms applied to the initial payment amount.
isinactive checkbox false Inactive false Check this box to inactivate this billing schedule. You cannot apply inactive schedules to orders.
ispublic checkbox false Public false Check this box to make this billing schedule public. You can select a public schedule on any estimate, sales order or item record. If you do not check the Public box, this schedule is Private. A private billing schedule shows only in the transaction it is created from. If you create a private billing schedule from a transaction, that schedule is attached to items on the resulting sales order. Note: This check box is available only for schedules created on-the-fly. If you create a regular schedule, it defaults to Public and cannot be changed.
name text false Name true Enter the name of this billing schedule.
numberremaining integer false Recurrence Count true Enter the number of subsequent payments you want the order amount divided into.
project select false Project false
recurrencepattern select false Recurrence Pattern false
recurrenceterms select false Recurrence Payment Terms false Select the terms to be used on all invoices subsequent to the initial invoice. To add new payment terms, go to Setup > Accounting > Accounting Lists > New and click Terms.
repeatevery select false Repeat Every false Choose how often the recurring invoices are generated.
scheduletype select false Type false The kind of billing schedule. The types available depend on the features enabled in your account. For example, the Fixed Bid Interval billing schedule type is only available when the Project Management feature is enabled. * Charge-Based – Lets you create charges, based on charge rules, which you can bill to customers. * Fixed Bid, Interval – Lets you bill customers for work completed at set intervals. * Standard – Lets you create a standard billing schedule based on an initial amount, recurrence frequency, and recurrence count. * Time and Materials – Bill customers based on actual expenses incurred in a project, such as raw materials and work hours.
seriesstartdate date false Start Date false
transaction select false Transaction false This field shows the associated transaction for this schedule.
weekfriday checkbox false Friday false
weekmonday checkbox false Monday false
weeksaturday checkbox false Saturday false
weeksunday checkbox false Sunday false
weekthursday checkbox false Thursday false
weektuesday checkbox false Tuesday false
weekwednesday checkbox false Wednesday false

Sublists

milestone - Milestones

Internal ID Type Label Required Help
comments text Comment false
milestoneactualcompletiondate date Actual Completion Date false
milestoneamount percent Amount true
milestonecompleted checkbox Completed false
milestonedate date Estimated Completion Date true
milestoneterms select Payment Terms false
projecttask select Task/Milestone false

recurrence - Custom Recurrence Pattern

Internal ID Type Label Required Help
amount ratehighprecision Amount true
count integer Count true
paymentterms select Payment Terms false
recurrencedate date Date true
relativetoprevious checkbox Relative to Previous false
units select Units true

Search Filters

Internal ID Type Label
externalid select External ID
externalidstring text External ID (Text)
formuladate date Formula (Date)
formulanumeric float Formula (Numeric)
formulatext text Formula (Text)
frequency select Recurring Frequency
id integer Billing Schedule ID
inarrears checkbox In Arrears
initialamount currency Initial Amount
initialterms select Initial Payment Terms
internalid select Internal ID
internalidnumber integer Internal ID (Number)
isinactive checkbox Inactive
ispublic checkbox Public
name text Name
recurrencecount integer Recurrence Count
recurrenceterms select Recurrence Payment Terms
repeatevery integer Repeat Every
type select Type

Search Columns

Internal ID Type Label
externalid select External ID
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)
frequency select Recurring Frequency
id integer BillingSchedule ID
inarrears checkbox In Arrears
initialamount currency Initial Amount
initialterms text Initial Payment Terms
internalid select Internal ID
isinactive checkbox Inactive
ispublic checkbox Public
name text Name
recurrencecount integer Recurrence Count
recurrencepattern select Recurrence Pattern
recurrenceterms text Recurrence Payment Terms
repeatevery integer Repeat Every
type select Type