Navigation:  Budget > Budget Payment Shipment >

Budget Payment Shipment Header

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

On this tab the following fields can be viewed:

 

hmtoggle_plus1Add

This button allows a new schedule line to be added to an entity. It may be added here when creating a manual schedule line or if an existing schedule line has been selected and the user double-clicked on the line in the grid displaying that entity's information, the information would be filled in the fields on the budget payment shipment header tab and the schedule line could be added here.

 

On the creation of a budget payment record for an account entity for a capital budget, the depreciation and tax depreciation models are automatically linked. The system looks at the account code rules table to determine which models apply to a specific account code and apply these by matching to the account entity of the budget record.

 

On creation of a new schedule line, a record is also automatically created in the Order Line Rules table. This table maintains the realization percentages per order (schedule) line. Zero's  are inserted. The percentages are updated via the Order Line Rules function. If a record exists for a particular order line, it is  not changed here.

 

Once a manual add has taken place, the 'Add' button remains available to allow further manual additions. The key of the record added is retained including defaults () and the rest of the data is cleared.

 

Once a delete has been done via the 'Delete' button here, all the data is retained in order for the user to make a change to the completion date and then the 'changed' record may be added. This retains the original cross reference number. The add works like a change.  Should any other fields be altered, the original data is lost and it is considered a new addition and requires the 'New schedule line' checkbox to be selected prior to adding new schedules.

hmtoggle_plus1Account

Populate Rules for Account field

Note that the division is determined by the division to which the copied records already belong (orders or nodes). For manually created entities, the division is determined by the division on the Budget entity table (when the entity was created).

 

The account field is mandatory. Where a record from an existing order does not have an account, it will not be added (in the copy functionality)

 

Copied Records :

Account, Node and Order Entities :-

 

SALES                                        The account field is populated with the account on the order line

 

Account Entities :-

PURCHASES                        Where order line  line type is 'non stock' :

         If requisition has an account :

                               ol.key = non_stock_purchase_requisition.key

and non_stock_purchase_requisition.req_no. = requisition.req_no.

Use Requisition.account

(which should be the same as the be. budget_entity_id)

IF NOT

then give message and disallow the copying

 

Where order line  line type is NOT 'non stock' :

Then give message and disallow the copying

 

Node Entities :-

PURCHASES                        Where node > '' and order line  line type is 'non stock' :

         If requisition has a non recov node :

ol.key = non_stock_purchase_requisition.key

and non_stock_purchase_requisition.req_no. = requisition.req_no.

and node.node = requisition.node

and ( node.recoverable = 'N' OR node.material_account > '' )

Use Node.material_account                        

         If requisition has a recov node :

ol.key = non_stock_purchase_requisition.key

And non_stock_purchase_requisition.req_no. = requisition.req_no.

and node.node = requisition.node and

and node.recoverable = 'Y' AND node.material_account  = ''

Use Div.Wip_project_management_account

 

Where node > '' and order line  line type is NOT 'non stock' :

Not valid, give message and disallow allow copying

Order Entities :-

PURCHASES        Where the part number > '' and fixed account part = 'Y' :

Use the store account

(ol.part_no. = part_master.part_no.

and part_master.controlling_store = store.store_code

and part_master.controlling_div = be.div = om.div

and part_master.fixed_account = 'Y'

         

                                         Where the part number > '' and fixed account part = 'N'  and order line status in ('Q', 'P', 'F') :

Use the div.creditors provisioning

(be.div = om.div

and part_master.fixed_account = 'N'

and ol.status in ('Q', 'P', 'F')

 

Where the part number > '' and fixed account part = 'N'  and order line status in ('R', 'C') :

If requisition has an account :

ol.key = stock_purchase_requisition.key

and stock_purchase_requisition.req_no. = requisition.req_no.

Use requisition.account

         If requisition has a non recov node :

ol.key = stock_purchase_requisition.key

and stock_purchase_requisition.req_no. = requisition.req_no.

and node.node = requisition.node

and ( node.recoverable = 'N' OR node.material_account > '' )                        

Use Node.material_account

If requisition has a recov node :

ol.key = stock_purchase_requisition.key

and stock_purchase_requisition.req_no. = requisition.req_no.

and node.node = requisition.node

and node.recoverable = 'Y'         AND node.material_account  = ''

Use Div.Wip_project_management_account

 

Where the part number = '' and node > '' and order line  line type is 'non stock' :

         If requisition has a non recov node :

ol.key = non_stock_purchase_requisition.key

and non_stock_purchase_requisition.req_no. = requisition.req_no.

and node.node = requisition.node

and ( node.recoverable = 'N' OR node.material_account > '' )

Use Node.material_account                        

         If requisition has a recov node :

ol.key = non_stock_purchase_requisition.key

and non_stock_purchase_requisition.req_no. = requisition.req_no.

and node.node = requisition.node

and node.recoverable = 'Y' AND node.material_account  = ''

        Use Div.Wip_project_management_account

         

Manually Created Records :

 

Account Entities                :-

SALES        If budgeted credit sales :

                                                         Allow the user to select from the list of accounts open for debtors credit (negative value)

                                                         Else                

The account entity itself is defaulted in the account field.

 

 

PURCHASES        If budgeted credit purchases :

         Allow the user to select from the list of accounts open for creditors credit (negative value)

                                         Else

         The account entity itself is defaulted in the account field.

 

Node Entities        :-
SALES        If budgeted credit sales :

                                                         Allow the user to select from the list of accounts open for debtors credit (negative value)

                                         Else

Where a material account exists on the node that is non recoverable,

it will be defaulted in the account field,

if recoverable

wip project management acc from div

 

PURCHASES        If budgeted credit purchases :

         Allow the user to select from the list of accounts open for creditors credit (negative value)

                                         Else

Where a material account exists on the node that is non recoverable,

it will be defaulted in the account field,

if recoverable

wip project management acc from div

Order entities        :-
SALES        If budgeted credit sales :

                                                         Allow the user to select from the list of accounts open for debtors credit (negative value)

                                         Else

For budgeted sales :                                

allow the user to select from the list of accounts open for sales

For budgeted additional cost sales :        

allow the user to select from the list of accounts open for additional cost debtors

         

 

PURCHASES        If budgeted credit purchases :

         Allow the user to select from the list of accounts open for creditors credit (negative value)

                                         Else

If ol.node                > ''

and n.node        = non recoverable

                                         use n.accounts

Else

For budgeted purchases :        

allow users to select either the Creditors Provisioning or Creditors Suspense

For budgeted additional cost purchases :

allow the user to select from the list of accounts open for additional cost creditors

 

NOTE : For all entity types

For new manually entered orders : Should the user make any changes to the budget type pay delivery field by selecting pre payments or advance payments,

the account field will then populate with accounts open for advance payment creditors and advance payment debtors respectively.

If the budget type pay delivery field is changed to something else, the original defaults will be lost.

The record must be added from scratch by reselecting the 'New Schedule Line' check box again.

 

Note that these are the defaults as per initial entry.

For new manually entered orders : Should the user make any changes to the budget type pay delivery field by selecting pre payments or advance payments, the account field will then populate with accounts open for advance payment creditors and advance payment debtors respectively. If the budget type pay delivery field is changed to something else, the original defaults will be lost. The record must be added from scratch by reselecting the 'New Schedule Line check box again.

hmtoggle_plus1Amount Type

This field displays the valid amount types available namely : Budget additional cost purchases, budget additional cost sales, budgeted purchases, budgeted credit purchases, budgeted sales, budgeted credit sales, actual advance payments, actual advance payment credits, actual prepayments, actual additional cost purchases, actual additional cost sales, actual credit purchases, actual credit sales, actual purchases and actual sales. The actual amount types for which there is data will display here as well as all the budget amount types.  Schedules may only be created for budgeted amount types, actuals are for display purposes only.  This field is enabled and mandatory.

hmtoggle_plus1Baseline

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

 

The GO TO / F7 jumps to Baseline on the Baseline tab of the Budget Administration function from the Baseline field.

hmtoggle_plus1Budget Type

This field displays the budget type of the budget id selected and is disabled.

 

The GO TO / F7 jumps to Budget type on the Budget Types tab of the Budget Maintenance function from the budget type field.

hmtoggle_plus1Budget Id

This field populates with all existing budget id's, is enabled and mandatory.

 

The GO TO / F7 jumps to Budget id on the Budget header tab of the Budget function from the budget id field.

hmtoggle_plus1Base Amount Per Unit

This field is populated with the unit price on the order line for copied records. Manually created records where the budget line type is payment or payment and shipment should require that a unit price be entered, but many records on the order line have no price and this rule cannot be enforced. Where the budget line type is shipment, a unit price may not be greater than zero.

hmtoggle_plus1Budget Line Type

This field displays the valid budget line types namely, payment, payment and shipment and shipment. It is always enabled and is mandatory.

hmtoggle_plus1Change

This button allows the details of the schedule line to be changed. All fields on manually created schedule line may be changed with the exception of the schedule line key itself. Copied (existing) schedule lines allow only the budget line type, payment type, units and motivation/notes to be changed.

hmtoggle_plus1Company Specific

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_plus1Completion Date

The Completion Date field is enabled for 'order' type entities only. It is populated in three different ways, dependant on the checking / unchecking of the MRP check box and the External Org check box. This field is also dependant upon the selection of entries in the other 5 fields namely, Supplier, Part number, Order Number, Order Type and Line Number. It is a lookup field when the copy option was selected and is an entry field for manual schedule creation. It is enabled for purchase order and customer order manual creation / linking.

 

If 'advance'  is selected, the completion date (bottom) may not be after budget completion date of the entity (top).

hmtoggle_plus1Contract Line Number

This field is populated from the invoice lead time on the order master for copied records. It may be entered for manually created records. It is enabled but not mandatory.

hmtoggle_plus1Currency Code

This field is populated from the payment currency on the order master for copied records. It is selected from the currency code table for manually created records.

hmtoggle_plus1Delete

This button allows the schedule line to be deleted.  Once a delete has been done here, all the data is retained in order for the user to make a change to the completion date and then the 'changed' record may be added. This retains the original cross reference number. The add works like a change. Should any other fields be altered, the original data is lost and it is considered a new addition and requires the 'New schedule line' checkbox to be selected prior to adding new schedules. A delete of a schedule record deletes the linked records in the budget asset dep model table and the Order Line Rules table. Note that the system will not allow the delete of a schedule if it is cross referenced in the same baseline. For example : schedule 'a' is cross referenced to 'b' and 'c'. The schedule 'a' record may not be deleted as it has schedules cross-reference to it. Schedule 'c' or 'b' may not be deleted as they are used in a cross reference .

Furthermore a user may not delete any schedule record for capital if that reference exists for any other baseline except if you have the "super administration profile". In the latter case, 'across baseline cross referenced' records may be deleted.

hmtoggle_plus1Depreciation

hmtoggle_plus1Depreciation Function

This button is enabled for capital budgets only. Once clicked, a new screen is opened that displays the entity key (disabled) and allows the entry /change of  tax depreciation and depreciation models. These are populated from the depreciation model table. These models are then linked to this entity and entity schedule line.  On the creation of a budget payment record for an account entity for a capital budget, the depreciation and tax depreciation models are automatically linked. The system looks at the account code rules table to determine which models apply to a specific account code and apply these by matching to the account entity of the budget record.

hmtoggle_plus1Description

This field displays the description of the budget id selected and is disabled.

hmtoggle_plus1Entity Id

This field is enabled when the entity type has been selected. Selection of this field is mandatory. On initial Entity Id selection, the Completion Date defaults to today's date.

hmtoggle_plus1Entity Type

Once the baseline has been selected, this field becomes enabled. The user may select the valid entity types as per the budget type selected. Nodes and accounts are linked to Capital and Own funded budgets. Order and accounts are linked to Contract budgets. Only accounts are linked to cost centre and division budgets. Only nodes are linked to Project budgets. Selection of this field is mandatory.

 

The GO TO / F7 jumps to Node / Order Master / Accounts functions from the budget entity type field  where this is either, node, order or account.

hmtoggle_plus1Ext Org Check Box

The External Org check box determines the method in which the Supplier, Part number, Order Number, Order Type, Line Number and Completion Date fields are populated.

If checked, these fields are populated by orders for external organization that exist on the external organization table. If unchecked and the External Org check box is also unchecked, these fields are populated by requirement orders. The user is required, once filling in the parameter(s), to click on the elipse button and then to (multi) select from a list of orders that satisfy the parameter(s) selected.

hmtoggle_plus1Financial Period

The financial period field defaults to the current financial period, but once a completion date has been entered, the financial period of the completion date is displayed here. It is disabled.

hmtoggle_plus1Invoice Lead Time Days

This field is populated from the invoice lead time on the order line for copied records. It may be entered for manually created records. It is enabled but not mandatory.

hmtoggle_plus1Line Number

The Line Number field is enabled for 'order' type entities only. It is populated in three different ways, dependant on the checking / unchecking of the MRP check box and the External Org check box. This field is also dependant upon the selection of entries in the other 5 fields namely, Supplier, Part number, Order Number, Order Type and Completion Date. It is a lookup field when the copy option was selected and is an entry field for manual schedule creation. It is also only enabled for purchase order linking.

hmtoggle_plus1Line Type

This field is populated with valid order line types. For 'purchases' amount types the values are : Mod, Nstk, Rep, Rew, Stck and Sub. For 'sales' amount types the values are : Nstk, Prod, Rep, Spar and Spec.  The line types 'stck','prod', 'spar' and 'rep' require the selection of a part number.  It is enabled for manual order line creation.

hmtoggle_plus1Motivation

This field is available for the motivation of capital items in capital budgets and notes for other budget types. It is always enabled and is not mandatory.

hmtoggle_plus1Mrp Check Box

The MRP check box determines the method in which the Supplier, Part number, Order Number, Order Type, Line Number and Completion Date fields are populated. If checked, these fields

are populated by orders involved in a simulation run. If unchecked and the External Org check box is also unchecked,these fields are populated by requirement orders.  The user is required, once filling in the parameter(s), to click on the ellipse button and then to (multi) select from a list of orders that satisfy the parameter(s) selected.  The user is required, once filling in the parameter(s), to click on the elipse button and then to (multi) select from a list of orders that satisfy the parameter(s) selected.

hmtoggle_plus1New Schedule Line

This check box may be checked when a new schedule line is to be created. It is enabled , checked  on initial entry and mandatory for the purpose of adding a new schedule.

 

When doing manual creations, the completion date is retained and the latest line number is displayed. This enables the user to continue to create additional manual entries easily - being able to view the latest completion date allocated. Should the user select a schedule from the summary tab, the key data (order number, order type, line number and completion date) will be retained if the 'New Schedule Line' is checked. For manual schedule creations the line type defaults to 'payment and shipment'. For manual schedule creations the payment type defaults to 'final'

hmtoggle_plus1Node

This field is populated with valid nodes from the nodes table where manual creation is done or displays the node on the order for copied records for order entities.  The node itself is saved here in the case of node entities. It is enabled and is not mandatory.

hmtoggle_plus1Order Type

The Order Type field is enabled for 'order' type entities only. It is populated in three different ways, dependant on the checking / unchecking of the MRP check box and the External Org check box. This field is also dependant upon the selection of entries in the other 5 fields namely, Supplier, Part number, Order Number, Line Number and Completion Date. It is a lookup field when the copy option was selected and is an entry field for manual schedule creation. It is also only enabled for purchase order linking.

hmtoggle_plus1Order Number

The Order Number field is enabled for 'order' type entities only. It is populated in three different ways, dependant on the checking / unchecking of the MRP check box and the External Org check box. This field is also dependant upon the selection of entries in the other 5 fields namely, Supplier, Part number, Order Type, Line Number and Completion Date. It is a lookup field when the copy option was selected and is an entry field for manual schedule creation. It is also only enabled for purchase order linking.

hmtoggle_plus1Order Cross Reference Check Box

The Order Cross Reference field is enabled for 'order' type entities only. It is disabled for manual schedule creation. It is also only relevant for purchase order linking. The user is required, once filling in the parameters, to click on the elipse button and then to (multi) select from a list of purchase orders cross referenced to the order entity selected.

hmtoggle_plus1Organisation Code

This field is populated with the organisation code on the order master for copied records. Manually created records require that an org code be selected. These are populated from the external organization table. Sales schedules will populate with organizations defined in the external org debtors account. Purchase schedules will populate with organizations defined in the external org creditors account.  It is mandatory for contract type budgets.

hmtoggle_plus1Part Number

This field is populated with valid part numbers from the Part master table for manual order creation or displays the part number on the order line. It is enabled and is not mandatory unless the line type is 'stck', 'prod', 'spar' and 'rep'. It is disabled when the line type is 'nstk' and 'spec' for customer orders and 'nstk' for purchase orders.

hmtoggle_plus1Radio Buttons

These radio buttons must be selected on the basis of the schedule to be created. If the schedule (purchase or customer order) exists and must effectively be linked to the entity (above), click on 'Copy'. If it does not exist (in the ERP system) and must be created from scratch, click on 'Manual'. Copied records may not be changed with the exception of the following fields' values : budget line type, the payment type, units and notes.

hmtoggle_plus1Rate Of Exchange

This field is calculated from the foreign, base amounts on the order line and the payment currency on the order master for copied records. It is entered for manually created records.

hmtoggle_plus1Reference No

This field is automatically created when a schedule line is created for a capital budget. A unique number is allocated and may not be used again. The field and access to the cross reference screen/functionality is disabled for other  budget types.

hmtoggle_plus1Requisition

This field is populated with valid requisitions from the Requisition table for manual order creation. Users may select the requisition here in order that the 'real' purchase order (connected to this requisition) be linked to the budget record. It is enabled and is not mandatory.

hmtoggle_plus1Settlement

This field is populated with valid settlement terms from the settlement term table. It is enabled and is mandatory.

hmtoggle_plus1Source

This button allows the user to enter either a hand journal number or a bank transaction code and bank transaction date in order that the budgeted purchase order be linked to an actual purchase record.

Note that the bank code / hand journal number is stored in the source_budget_id field. The bank transaction date will be stored in the source_budget_entity_id field.

These fields will be greater than spaces only if the record was initially created by copying the data in the Budget Extraction function (Copy tab). This data will be lost if a hand journal or bank reference is entered.

The comments/motivation column will display the words 'Hand Journal' or Bank' if either of these has been entered/linked to the purchase order.

Either a hand journal or bank details may be linked to a budgeted purchase order record.

Take care to click on 'Apply' to save the hand journal or bank code and transaction date details OR 'Cancel' to undo any changes. Note that a new record requires that the add button be clicked before any data is saved and this includes the source data. On a change, however, the Apply button is sufficient to save the source changes made to the existing record.

hmtoggle_plus1Start Date

Start date This field is populated with the start date on the order line for copied records. Manually created records require that a date be selected. The current date is defaulted. It is mandatory.

hmtoggle_plus1Supplier

The Supplier field is enabled for 'order' type entities only. It is populated in three different ways, dependant on the checking / unchecking of the MRP check box and the External Org check box. This field is also dependant upon the selection of entries in the other 6 fields namely, Part number, Order Number, Order Type, Line Number and Completion Date. It is a lookup field when the copy option was selected and is disabled for manual schedule creation. It is also only enabled for purchase order linking.

hmtoggle_plus1Total Base Amount

This field is populated with the unit price multiplied by the (quantity ordered) on the order line for copied records. It is disabled.

hmtoggle_plus1Total Foreign Amount

This field is populated with the contractual unit price multiplied by the (contractual quantity ordered) on the order line for copied records. It is disabled. This amount defaults to the base amount if the currency is the base currency.

hmtoggle_plus1Units Rejected

This field is populated from the quantity rejected on the order line for copied records. It defaults to 0 for  manually created records. It is disabled.

hmtoggle_plus1Units In Insp

This field is populated from the quantity in inspection on the order line for copied records. It defaults to 0 for manually created records. It is disabled.

hmtoggle_plus1Units Completed

This field is populated from the quantity complete on the order line for copied records. It defaults to 0 for manually created records. It is disabled.

hmtoggle_plus1Units Ordered

This field is populated from the (quantity ordered) on the order line for copied records. It defaults to the units field's value for manually created records. It is disabled.

hmtoggle_plus1Units

This field is populated from the (quantity ordered) on the order line for copied records. It is entered for manually created records. It must be greater than zero, is mandatory and is always enabled.