Dimensional modifications

Use this function to select and update dimensional accounting journals that require amendment.

Prerequisites

Refer to documentation Implementation

Screen management

• Criteria entry
• Tab Entry screen

The Dimensional modifications function displays an initial screen into which you enter your selection (or filtering) criteria and a screen into which you enter the required changes.

Criteria entry

Enter the company code for which the processing has been started.

 The company code:

• must necessarily refer to a legal entity,
• must necessarily be entered if the box "All companies" is not checked.

Select this check box to include all sites. To run this process for a single site, leave clear.

Enter the site code for which the processing has been started.

 It is mandatory to enter this field if the box "All sites" is not checked.

Select this check box to include all users. To run this process for a single user group, leave clear.

The current user will be used if the user/group code is blank.

If a user code is entered in this field, the process only includes accounting documents entered by the user. If left blank, only accounting documents for the current user are included.

If this box is checked, all types of ledgers linked to the selected company, and for which the "Analytical" accounting type is checked, will be impacted by the processing.

This field corresponds to the ledger type on which the processing is started.

 It is mandatory to enter this field if the box "All ledger types" is not checked.

Select this check box to include all types. To run this process for a single type, leave clear.

When a journal type is entered, the processing is only started for the journals for which this type has been used.

If this box is checked, all journal types are taken into account for the operation.

Enter the journal type. It must be of the same type as the journal linked to the selected journal type.

 It is mandatory to enter this field if the box "All journals" is not checked.

The journal type is used to group journals based on common characteristics mainly linked to the nature of the operations that will be recorded in it:

• Sales,
• Purchasing,
• Cash,
• Miscellaneous Operations,
• Analytical MOs,
• Carry forward entries.

Some processings and controls depend on the journal type:

• the "carry forward entries" journals can only record journals associated with the "Carry forward entries" period",
• the "ana. MO" type journals can only record journals assigned to the "analytical" category.
• a cash account must be attached to each "cash" type journal so that the entries posted in this journal have an automatic counterpart. A cash-type journal is used:
• in the A/P-A/R accounting module on payment posting,
• in the automatic journals.

 The setup of the cash journals is specified in the Definition of the journals, journal types and accounts on payments documentation.

Six journal types have been allocated to the miscellaneous operations:

• values 4 and 5 for the General Accounting,
• values 8, 9 and 10 for the Analytical Accounting,

If the box "All journals" is checked, all types of journals are taken into account for the operation.

Here, indicate the journal code comprised of one to five alphanumeric characters.
Upon creation, the journal is automatically open for all the specified periods.
The journal selected here must be of the same type as the journal linked to the journal type kept in the previous selection criteria.

It is mandatory to enter this field if the box 'All journals' is not checked.

Date from which the records are selected.

Date until which the records are selected. This date can only correspond to the end of a period.

This field is used to further specify the selection by defining an account range.
Specify here the first account to be selected.

This field is used to further specify the selection by defining an account range.
Specify here the last account to be selected.

If the box "All dimensions" is checked, the processing involves all the dimensions linked to the selected dimension view(s).

Enter the dimension view for which the dimension ra nges need to be entered.

 This field is mandatory if the box "All dimensions" is not checked.

Enter a start range to limit the processing to some dimensions of the filtered dimension view.

Enter an end range to limit the processing to some dimensions of the filtered dimension view.

It is possible to further specify the selection to:

• All documents,
• No dimension view entered,
• One dimension view not entered,
• No entry on the dimension view.

This field is activated if the option "No entry on the dimension view" has been selected.
Enter the dimension view onto which the condition should be applied.

Selection

Grid Dimension type

Entry screen

Specific Buttons

• Memo
• Recall memo
• Delete Memo
• Criteria
• Entry

Limitations

• You cannot modify the analytical allocation key (defined in the Distribution field) if the allocation key defined on the entry line updates several analytical ledgers.
  
  
• You cannot modify a dimension type if the dimension type defined on the entry line is common to all the analytical ledgers.
  
  

Example (applicable to the two limitations mentioned above)

A company has three ledgers:

• A 'legal' ledger (a general ledger).
• An 'analytical' ledger.
  This ledger has two dimension types:
• CCT (Cost centers)
• PRO (Projects)
• A 'group' ledger (a combined general and analytical ledger)
  This ledger has two dimension types:
• CCT (Cost centers)
• CUS (Customers)
  

A journal line on my supplier account updates the legal and the group ledgers.

• The analytical allocation key can be updated.
• The CCT dimension type can be updated.

Reason:

• The analytical allocation key defined on the entry line in this example only distributes the amount onto a single analytical ledger (the grouped analytical ledger).
• The CCT dimension type affected by the entry line in this example is common to only a single analytical ledger – the group analytical ledger.
  
  

An entry line on the purchase account updates the legal, analytical and grouped ledgers.

• The analytical allocation key cannot be updated.
• The CCT dimension type cannot be updated.
  

Reason:

• In this example, the analytical allocation key defined on the entry line distributes the amount onto several analytical ledgers (the analytical and grouped ledgers).
• The CCT dimension type associated with the entry line is common to several analytical ledgers (the analytical and grouped ledgers).

Error messages

• Generic messages

The only error messages are the generic ones.

Tables used

Refer to documentation Implementation