Navigation:  Budget > Budget Account Allocation >

Resource Account Allocation Function

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic

This function requires the profile Budget Div Account Allocation and the Budget CC Account Allocation Profile. The use of this tab also requires that the user be either the div manager, div accountant, the responsible person, cost centre manager or their acting for, to entitle them to update various budgets.

The Resource account allocation gets its values from contract budgets only and order entities only (in the budget resource allocation table).

Only budget records are used and created.

The division on the budget entity table per order entity determines the division of the cost budgets.

It allocates Cost of sales to the various Divisional COS accounts or the accounts on the node (where an order line is linked to a non recoverable node and it has accounts specified - these may be cc/div accounts) for the credit entry and it allocates the corresponding debit entries to either the Division WIP Customer Order accounts OR the WIP project management accounts (if a recoverable milestone node exists on the order line)

These are the accounts available for selection in the 'Available Accounts' list box.

The total amounts in the contract budgets for the baseline selected are summed per account and entered as account entities within the division (budget) selected or the appropriate cost centre budget.

The budget which is selected is based on the entity. If the entity is a cost centre account - the cost centre budget will be created/updated, if it is a division account, the division budget will be created/updated.

 

 

Another way of stating this is as follows: Select all budget records from the budget resource allocation tables where the budget type is contract, the baseline is the baseline for which you are preparing budgets, the entity type is an order and the resource is either labour, material or both depending on the selection made. The budget (amount type) records will be summed per the COS or node accounts and the  WIP customer order or project management accounts to which they belong. Determine the account entities to be created in the Division budget by selecting the COS accounts for the division within which the order entities exist or use the accounts linked to the node on the order line if it is a non recoverable milestone node (these may be cc/div accounts). This is the credit entry. The debit entry uses either the Division WIP Customer Order accounts OR the WIP project management accounts if a recoverable milestone node exists on the order line.

 

The total_amounts are calculated as follows: For resource type 'L' :-The sum of the units multiplied by the hours multiplied by either the labour, overhead or fixed overhead rates (depending on whether the calculation is for Labour COS/Node labour account/WIP project management/WIP labour customer order etc) OR for resource type 'M':- the sum of  total_amount.

 

The accounts entities created are determined as follows:

 

Select from budget_resource_allocation

Where budget_type_id = 'Contract'

And budget_entity_type = 'Order'

And budget_order_type = 'Cust'

And budget_amount_type = 'Budget'

And node = spaces

         Dr COS material/labour/overhead/fixed overhead account

with total_amount or (units * hours * lab/oh/fix oh)

Cr WIP_ mat/lab/var_over/fix_over _cust_ord_account_

with total_amount or (units * hours * lab/oh/fix oh) *-

 

Select from budget_resource_order_line_nodes

Where budget_type_id = 'Contract'

And budget_entity_type = 'Order'

And budget_order_type = 'Cust'

And budget_amount_type = 'Budget'

And order_line.line type = 'Nstk'

And node > spaces

And node's recovery = 'Y'

And node's accounts = ''

And ol.node's milestone = 'Y'

Sum these amounts

         Dr COS material/labour/overhead/fixed overhead account

with total_amount or (units * hours * lab/oh/fix oh)

Cr WIP_project_management_account

with total_amount or (units * hours * lab/oh/fix oh) *-1

 

Select from budget_resource_order_line_nodes

Where budget_type_id = 'Contract'

And budget_entity_type = 'Order'

And budget_order_type = 'Cust'

And budget_amount_type = 'Budget'

And order_line.line type = 'Nstk'

And node > spaces

And node's recovery = 'Y'

And node's accounts > ''

And ol.node's milestone = 'Y'

Sum these amounts

         Dr COS material/labour/overhead/fixed overhead account

with total_amount or (units * hours * lab/oh/fix oh)

Cr Node's material/labour/overhead/fixed overhead account

with total_amount or (units * hours * lab/oh/fix oh) *-1

 

These last two selects are creating a purchase order plan for non recoverable nodes)

 

Select from budget_resource_order_line_nodes

Where budget_type_id = 'Contract'

And budget_entity_type = 'Order'

And budget_order_type = 'Cust'

And budget_amount_type = 'Budget'

And order_line.line type = 'Nstk'

And node > spaces

And node's recovery = 'N'

(And  node's accounts > spaces)

And ol.node's milestone = 'Y'

Sum these amounts per the different material accounts

         Dr Node's material account

         with total_amount

         Cr Div.Creditors_provisioning account

with total_amount * -1

 

 

Select from budget_resource_allocationWhere budget_type_id = 'Project' and 'Own Funded'

And budget_entity_type = 'Node'

And budget_amount_type = 'Budget'

And node > spaces

And node's recovery = 'N'

(And  node's accounts > spaces)

         Dr Node's material account

         with total_amount

         Cr Div.Creditors_provisioning account

with total_amount * -1

 

Account allocation takes place for the periods between the applicable start and end dates (the default) unless different financial periods are selected.

 

Note that if the applicable dates are moved forward and new entities are created during this period, their start dates will correspond with the applicable date's start date. Should the applicable dates be moved back (for some reason), the downloads will not have downloaded data for these entities for periods prior to their start dates.

Consequently, data that is expected in the account allocation may not exist.

The user must just be aware that moving the application dates back has implications although it is allowed.

 

On this tab the following fields can be viewed:

 

hmtoggle_plus0Acc Setup

hmtoggle_plus0Allocation ID

hmtoggle_plus0Allocation Criteria

hmtoggle_plus0Baseline

This field displays the valid baselines available for selection and is enabled. Selection of this field is mandatory.

hmtoggle_plus0Budget ID

This field is determined by the division selected. There is a single division budget per division. It is disabled. Note that cost centre budgets will also be updated if the orderline is linked to a non recoverable milestone node and the accounts on this node are cc accounts.

hmtoggle_plus0Company Specific Baseline

This field indicates which baselines are required. If the field is checked, only formal company specified baselines will be available for selection. If the field is unchecked, only non company specific baselines will be available for selection.

hmtoggle_plus0Delete

hmtoggle_plus0Display

hmtoggle_plus0Division

This field is populated with the division budgets that exist.

This field is enabled and mandatory.

hmtoggle_plus0Fin Period From and To

These default to the financial periods of the applicable start and applicable end dates of the division budget that exists for the selected baseline. These fields are enabled and may be changed within the initial range. They are mandatory.

hmtoggle_plus0Grid

hmtoggle_plus0Resource

This field is populated with either material or labour.

It is enabled and not mandatory.

hmtoggle_plus0Simulate Results

hmtoggle_plus0Simulate Source