Reversals

Use this function to launch an automatic reversal processing on a set of journals selected by the user depending on a number of criteria.

Use this function, especially at the beginning of the fiscal year, to globally reverse all the stock count MO of the previous fiscal year.

All journals, either simulation or actual journals, can be reversed. The "Reversal" field in the journal entry function only needs to be set to "Yes", and a reversal date, added.
See also See the documentation on journal entry for further information.

For each reversal, a journal will be generated. The journal thus dealt with will have their "Reversal" fields set to the "Reversed" value.

 When a journal is processed, all the ledgers containing this journal will be impacted.

When the Fixed assets are managed, the journal reversal will result in the Expenses automatic generation, provided that the required setup is implemented (see the Journal entrydocumentation for further information). The list of expenses then created is included in the log file generated at the end of the reversal processing.

Pre-requisites

See also Refer to documentation Implementation

Screen management

Entry screen

Selection criteria

The selection of journals to be reversed is made according to several criteria:

These criteria can be used to restrict the selection of journals to be reversed. It is not however mandatory to enter all these fields. By default, the system selects all the journals having the "Yes" status.

Date ranges are used to refine the selection. The reversal date specified on journal entry is the date that is taken into account. Note that the operation will only be valid if the relevant fiscal year and accounting period are open.

Generation

The accounting journal type generated during this processing is the same as the type of the original journal.

At processing level itself, it is possible to select the reversal method to use:

The "Log file" flag can be selected to display a summary of all the generated journals at the end of the processing.

Field descriptions

Criteria

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

All companies (field ALLCPY)
Company (field CPY)

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

Warning The company code:

Legislation (field LEG) All sites (field ALLFCY)

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

Site (field FCY)

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 document types (field ALLTYP)

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

Entry type (field TYP)

it is possible to enter a specific journal type in this field when the box "All journal types" is unchecked.

All journal types (field ALLTYPJOU)

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:

Some processings and controls depend on the journal type:

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:

All journals (field ALLJOU)

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.

All users (field ALLUSR)

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)

Ccode of the operator that carried out the process.

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

Date range

Start date (field STRDAT)

Start of the selected period representing the reversal date entered on journal entry.

Warning The operation will only be valid if the fiscal year and accounting period concerned are open.

End date (field ENDDAT)

End of the selected period representing the reversal date entered on journal entry.

Warning The operation will only be valid if the fiscal year and accounting period concerned are open.

Generation

Generation type (field EXTSNS)

This field is used to generate automatic reversals. The journals having their "Reversal" flag set to Yes and meeting the criteria defined below will be reversed on the reversal date defined in the journal.
Generation types:

  • Debit/Credit: it matches the standard accounting reversal for which an accounting journal is cancelled and replaced with another by inverting the debit and credit amounts.
  • Negative Amount: this method cancels the entries of a journal by using the same journal but with negative amounts.
    This way, the accounts totals are not incorrect.
Log file (field TRC)

Select this check box to generate a log file.

 

Batch task

This function can be run in batch mode. The standard task ACCRVS is provided for that purpose.

Specific buttons