Navigation:  Budget > Budget Account Allocation >

Schedule Account Allocation Function

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

This tab requires the Budget Payment Shipment Account Allocation profile. It is not dependant on the role of the user in the company.
It affects contract, project and own funded budgets (not CC, Div or capital budgets) and affects all entities. The total_base_amounts are summed across all budget schedules (found in the budget payment shipment table) for the selected baseline for the account found on the budget payment delivery table (budget payment shipment record) AND either the division's creditors provisioning or suspense accounts OR the division's debtors suspense account and then inserted as account entities into the relevant Div or Cost

centre type budgets (in the budget resource allocation table), depending on the type of account.

These are material resource account entity records.

 

The accounts entities created are determined as follows :

Select from the budget_payment_delivery table (bpd)

1.        If    bpd.budget_type_id                = 'CONTRACT', 'PROJECT' or 'OWN FUNDED'
and bpd.budget_entity_type                        = 'ORDER'

and bpd.order_type                                  = 'CUST'

and bpd.budget_amount_type                  in ('BS', 'BACS', 'BCS')

 

Cr bpd.sales_account (negative)

Dr ext_org.debtors_account (positive)

 

2.        If     bpd.budget_type_id                = 'CONTRACT', 'PROJECT' or 'OWN FUNDED'
and bpd.budget_entity_type                        = 'ORDER'

and bpd.order_type                                  = 'PUR'

and bpd.budget_amount_type                  in ('BP', 'BACP', 'BCP')

and bpd.part_number                                                  > ''

and part_master.fixed_account                 = 'Y'                

 

Cr ext_org.creditors_account (negative)

Dr bpd.sales_account (positive)  (derived from stores.account_code)

 

3.        If    bpd.budget_type_id                = 'CONTRACT', 'PROJECT' or 'OWN FUNDED'
     and bpd.budget_entity_type                        = 'ORDER'

and bpd.order_type                                   = 'PUR'

and bpd.budget_amount_type                  in ('BP', 'BACP', 'BCP')

and bpd.part_number                                                  > ''

and part_master.fixed_account                = 'N'                

 

Cr ext_org.creditors_account (negative)

 Dr bpd.sales_account (positive)  (derived from req.account_code or node.material_account or div.wip_project_management_account)

 

4.        If    bpd.budget_type_id                = 'CONTRACT', 'PROJECT' or 'OWN FUNDED'
and bpd.budget_entity_type                        = 'ORDER'

and bpd.order_type                                  = 'PUR'

and bpd.budget_amount_type                  in ('BP', 'BACP', 'BCP')

and bpd.part_number                                                  = ''

and bpd.node                                                                  > ''                

and bpd.line_type                                                  = 'Nstk'                

 

Cr ext_org.creditors_account (negative)

Dr bpd.sales_account (positive)  (derived from node.material_account or div. Wip_proj_management_account)

 

5.        If    bpd.budget_type_id                = 'CONTRACT', 'PROJECT' or 'OWN FUNDED'
and bpd.budget_entity_type                        = 'NODE'

and bpd.order_type                                  = 'PUR'

and bpd.budget_amount_type                  in ('BP', 'BACP', 'BCP')

and bpd.part_number                                                  = ''

and bpd.node                                                                  > ''                

and bpd.line_type                                                  = 'Nstk'                

 

Cr ext_org.creditors_account (negative)

Dr bpd.sales_account (positive)  (derived from node.material_account or div. Wip_proj_management_account)

 

6.        If     bpd.budget_type_id                = 'CONTRACT', 'PROJECT' or 'OWN FUNDED'
and bpd.budget_entity_type                        = 'ACCOUNT'

and bpd.order_type                                  = 'PUR'

and bpd.budget_amount_type                  in ('BP', 'BACP', 'BCP')

and bpd.part_number                                                  = ''

and bpd.node                                                                  > ''                

and bpd.line_type                                                  in ('Nstk', 'Stck')                

 

Cr ext_org.creditors_account (negative)

Dr bpd.sales_account (positive)  (derived from be.budget_entity_id / req.account)

 

On this tab the following fields can be viewed:

 

hmtoggle_plus0Add

On the click of this button, the selected rows will be added to the list box on the right hand side. These will be updated.

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_plus0Fin Period From and To

These default to the financial periods of the min applicable start and max applicable end dates of the cost centre / division budgets that exist for the selected baseline. These fields are enabled and may be changed within the initial range.

They are mandatory.

hmtoggle_plus0Remove

On the click of this button, the selected rows will be removed and replaced on the left hand side list box. These will not be updated.