Allocation Schedule
Allocation schedules transfer balances from expense accounts into one or more other accounts.
The internal ID for this record is allocationschedule.
The allocation schedule record is available only when the Accounting Periods and Expense Allocation features are enabled. An administrator can enable these features at Setup > Company > Enable Features under the Accounting subtab. For information about expense allocation, see Expense Allocation Overview.
For help working with this record in the UI, see Creating Expense Allocation Schedules.
If the Statistical Accounting feature is enabled, the allocation schedule record includes fields that enable you to base the weight for the allocation on the balance of a statistical account through statistical journals or as an absolute value. If the Dynamic Allocation feature is also enabled, the weight is dynamically calculated when the allocation journal is generated. An administrator can enable these features at Setup > Company > Enable Features and select Accounting under Advanced Features. For information about statistical allocation schedules, see Working with Allocation Schedules Weighted by the Balance of a Statistical Account.
See the SuiteScript Records Browser for all internal IDs associated with this record.
For information about using the SuiteScript Records Browser, see Working with the SuiteScript Records Browser in the NetSuite Help Center.
For information about scripting with this record in SuiteScript, see the following help topics:
Supported Script Types
This record is scriptable in both client and server SuiteScript.
If the Dynamic Allocation feature is enabled, the currency field is not scriptable. None of the fields from the History subtab on the allocation schedule record in the UI are not scriptable.
Supported Operations
This record is partially scriptable — it can be read, created, deleted, copied, and updated. It cannot be transformed.
Code Samples
The following samples show how to create a statistical allocation schedule that divides the balance of one account and transfers the amounts into two other accounts.
var myAllocSched = record.create({
type: record.Type.ALLOCATION_SCHEDULE,
defaultValues: false
});
myAllocSched.setValue({
fieldId: 'name',
value: 'Allocation Schedule A'
});
myAllocSched.setValue({
fieldId: 'subsidiary',
value: '1'
});
myAllocSched.setSublistValue({
sublistId: 'allocationsource',
fieldId: 'account',
line: 1,
value: '24'
});
myAllocSched.setSublistValue({
sublistId: 'allocationdestination',
fieldId: 'account',
line: 1,
value: '6'
});
myAllocSched.setSublistValue({
sublistId: 'allocationdestination',
fieldId: 'weight',
line: 1,
value: '50.00'
});
myAllocSched.setSublistValue({
sublistId: 'allocationdestination',
fieldId: 'account',
line: 1,
value: '32'
});
myAllocSched.setSublistValue({
sublistId: 'allocationdestination',
fieldId: 'weight',
line: 1,
value: '50.00'
});
recordId = myAllocSched.save();