Working with Allocation Schedules Weighted by the Balance of a Statistical Account

If you have enabled the Statistical Accounts and Dynamic Allocation features (Setup > Company > Enable Features > Accounting under Advanced Features), you can assign any statistical account to any allocation schedule. You create an allocation schedule for a statistical account the same way you create any allocation schedule, except that the weight for the allocation, based on the balance of that statistical account through statistical journals or as an absolute value, is dynamically calculated when the allocation journal is generated. This is useful in advanced costing such as Activity Based Costing and Usage Based Costing, and when you are running cost centers and profit centers. To calculate statistical weight, NetSuite uses the flat amount for each destination line in the allocation schedule, rather than dividing by the total amount entered in all of the destination lines.

You can control the period of time that NetSuite uses to calculate the balance (weight timeline) by specifying the timeline end date through the Next Date field. This end date can be the date on which the schedule runs (system date), or a past or future date. When you select the weight basis (specific date, period to date, quarter to date, or year to date), your weight timeline is relative to the date you enter in the Next Date field. This is useful when you want an allocation schedule to calculate a statistical account balance for a period of time prior to or after the run date. For example, you want to run your allocation schedule on March 3, 2015 (system date) for the February previous period, February 1 through 28, 2015. You also specify the Next Date field as February 28, 2015 to synchronize the source and weight basis timeline to February 1 – 28, 2015. With the new synchronized weight enhancement, the source timeline, created journals, AND the weight timeline are driven by the value in the Next Date field. For more information about allocation schedules, see Creating Expense Allocation Schedules.

Note:

To create allocation schedules, the Accounting Periods and Expense Allocation features must be enabled. An administrator can enable these features at Setup > Company > Enable Features > Accounting under Basic Features and Advanced Features, respectively. For more information about expense allocation, see Expense Allocation Overview.

For information about creating intercompany allocation schedules, see Creating Intercompany Allocation Schedules.

For information about running allocation schedules in a sequence, see Creating an Allocation Batch.

Related Topics:

General Notices