Financials > Current processes > Dimensional modifications 

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

Prerequisites

SEEREFERTTO 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

Fields

The following fields are present on this tab :

Criteria

  • All companies (field TOUSOC)

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

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

SEEWARNING The company code:

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

 

  • All sites (field TOUSIT)

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.

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

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.

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

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

SEEWARNING It is mandatory to assign this field if the box "All journal types" is not checked.

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

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

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

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.

SEEWARNINGIt 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).

Enter the dimension view for which the dimension ranges need to be entered.

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

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.

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.

Close

 

Entry screen

Fields

The following fields are present on this tab :

Criteria

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.

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

  • field CPYNAM

Company description.

This field defines the site involved in the processing.

  • field FCYNAM

Site description.

  • Accounting date (field ACCDAT)

Date on which the transaction is posted.

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.

This field displays the account of the journal impacted by the processing.

This field specifies the code of the BP in the record displayed for the processing.

  • Amount (field AMTCUR)

Amount expressed in the transaction currency.

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

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 the Limitations section.

Dimension types

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.

Close

 

Specific Buttons

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.

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.

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

Click this action to delete a Memo code.

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

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

SEEREFERTTO Refer to documentation Implementation