Dimensional modifications

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

Prerequisites

See also Refer to documentation Implementation

Screen management

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

Criteria

Select this checkbox to include all companies. To run this process for a single company, do not select this checkbox.

All companies (field TOUSOC)
Company (field SOCIETE)

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

Warning The company code:

  • must necessarily refer to a legal entity,
  • must necessarily be entered if the box "All companies" is not checked.
Legislation (field LEG) All sites (field TOUSIT)

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

Site (field SITE)

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

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

All users (field TOUUSR)

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.

User (field USR)

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.

All ledger types (field TOULED)

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.

Ledger type (field LEDTYP)

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

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

All document types (field TOUTYP)

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

Entry type (field TYP)

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

Warning 

All journal types (field TOUTYPJOU)

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

Journal type (field TYPJOU)

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

Warning 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.

See also 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,
All journals (field TOUJOU)

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

Journal (field JOU)

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.

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

Start date (field DATDEB)

Date from which the records are selected.

End date (field DATFIN)

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

From account (field CPTDEB)

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

To account (field CPTFIN)

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

All dimensions (field TOUSEC)

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

Dimension type filter (field AXE)

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

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

From dimension (field SECDEB)

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

To dimension (field SECFIN)

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

Journal filter (field SAISI)

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.
Dimension type (field DIESAI)

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

Quantity change (field MODQTE)

Check this box if modifications need to be introduced to the quantities.
Log file (field TRACE)

Select this check box to generate a log file.

 

Grid Dimension type

field NBRDIE
No. (field NUMLIG)

It is the line number.
Dimension type (field DIE)

Select the analytical dimension view(s) that need to be modified.
Modification (field MODAXE)

Check the cell for the entered dimension views that need to be modified.

Entry screen

Criteria

Entry (field TYP)

Journal type of the displayed recording.

Each accounting journal entered is linked to a given type. The journal type corresponds to the nature of the entered posting: customer invoice, miscellaneous operations, cash receipt, etc.
Number (field NUM)

Journal number of the recording.
It defines the journal on which the modification is performed.

Line (field LIN)

It is the line number. This number is automatically generated.

Ledger (field LEDTYPNAM)

This field corresponds to the ledger type on which the modification is performed.
Company (field CPY)

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

Company description.
Site (field FCYLIN)

This field defines the site involved in the processing.
field FCYNAM

Site description.
Accounting date (field ACCDAT)

Date on which the transaction is posted.

Journal (field JOU)

This field defines the journal of the displayed recording, impacted by the processing.

field JOUNAM

Description of the displayed journal.
Control (field SAC)

This field mentions the collective account code of the displayed account.
Account (field ACC)

This field displays the account of the journal impacted by the processing.
BPs (field BPR)

This field specifies the code of the BP in the record displayed for the processing.
Amount (field AMTCUR)

Amount expressed in the transaction currency.
field CUR

Transaction currency code.
field SNS

Sense of the entry: Debit or credit.
Reference (field REF)

This field contains the reference of the journal displayed for processing..
Description (field DES)

This field displays the content of the free entry field of the recording.

Nonfinancial units

Nonfinancial unit (field UOM)

On analytical inquiry, this field determines the non-financial unit linked to the displayed account.
The non-financial unit is determined when setting up an account associated with a given value.
This unit is called upon entry.
Quantity (field QTY)

This field is used to display the quantity of non-financial units of the recording displayed for processing.
It can be accessed and modified if the box "Quantity modification" is checked in the criteria screen.
Distribution (field DSP)

Use this field to apply a different analytical allocation key to the selected journals. Analytical allocation keys apportion the journal line across multiple analytical dimensions.

See also See also the Limitations section.

Dimension types

field CCE

Use these fields to apply a different dimension type code to the selected journals.

These fields can be modified if the following conditions are met:

  • The dimension type code has been included in the initial selection criteria.
  • The modification flag has been selected.

 See also the Limitations section.

Specific Buttons

Memo

Click this action to save the current settings to a Memo code to be reused later. The memo is linked to your user profile, not to the function or the screen.

Note:

The STD memo code is associated with the screen and is loaded immediately when you open the function.

For more information on the advanced use of the Memo action, refer to the documentation on the General ergonomics of SAFE X3 software.

Recall memo

Click this action to enter a Memo code to load the settings associated with the code.

Delete Memo

Click this action to delete a Memo code.

Criteria

Click the Criteria action if you need to change the journal selection criteria. You are sent back to the journal selection screen.

Entry

Click the Entry action to display the entry details.

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

The only error messages are the generic ones.

Tables used

See also Refer to documentation Implementation