Financials >  Current processes >  Recurring entries >  Balance  

Display all Hide all

Use this function to generate entries with a recurring entry adjustment. You must launch this processing after posting the actual invoice.

The recurring entry adjustment can be performed for:

  • Entries processed in the ledger currency
  • Entries processed in a currency other than the ledger currency

The generated entry completes or decreases the total of recurring amounts based on the amount actually invoiced.

The recurring entry processing is used to balance the recurring entry account in order to determine the cost or the actual revenue.

Example 1:
Let us consider a supplier recurring entry, for an amount of 300 tax excl. over three months.
Actual amount of the invoice: 373.86 tax incl.
The system generates the following entries:

  • Generated recurring journal entries
  • Posted supplier invoice

Example 2:
A recurring entry is created for entries in EURO ledger currency. An intermediate invoice is processed in USD transaction currency. The system simultaneously generates:

  • A recurring adjustment entry in transaction currency (EUR) that will balance the N created recurring entries
  • A recurring adjustment entry in transaction currency (USD) that will balance the intermediate invoice created in USD.

You can manage as many recurring adjustment entries as there are transaction currencies involved.

The partner and flow initialization rules are the same as those that are followed for the generation of journal entries. The same rules also apply to any controls used on the partner and flow fields.

SEEINFO Read the documentation for Partner initialization and Flow initialization.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

The status of entries in the launch screen must be 'Final' when the 'Actual' entry category is selected and when the company:

  • is a French legislation company: the parameter FRADGI - French fiscal regulation (TC chapter, CPT group) is set to 'Yes' and this value cannot be modified,
  • is not a French legislation company but applies French compliance rules ("DGI no. 13L-1-06"): the parameter FRADGI - French fiscal regulation (TC chapter, CPT group) is set to 'Yes' and this value can be modified.

Entry screen

Presentation

The selection criteria are used to limit the selection of the recurring entries to be processed. You do not need to enter all the fields.

The system selects by default all the recurring entries and generates an accounting entry for all those whose total amount of generated recurring entries is different from the related invoice.

Close

 

Fields

The following fields are present on this tab :

Criteria

  • All companies (field TOUSOC)

Select this check box to run the process for all companies. Otherwise, you need to select a company.

Special case

In a multi-legislation environment, this check box is not available. The process can only be run one company at a time because the document type and journal for the posting are likely for a single legislation.

 

This is the code of the assignment company of the entity.
This optional zone makes it possible to specify entities common to several companies.

 

  • All sites (field TOUSIT)

If this check box is selected, all the sites of the current company are affected by this process.

If not selected, you can enter a specific site.

This title is associated with the previous code.

  • All users (field TOUUSR)

No help linked to this field.

 

  • Ledger type (field LEDTYP)

Use this field to define the ledger type concerned by the journal balance. In this function, only Manual ledgers can be accessed.

You can read the balance on the selected ledger and balance the account for that ledger type. The propagation then initializes the accounts for the nonautomatic and nonprohibited ledger types. This initialization process is based on the entry type setup and account setup.

The propagated amount is the one calculated on the main general ledger in transaction currency. This amount is then converted into the currency of the propagated ledgers.

When generating the journal balance, the propagation is depends on the selected entry type.

The entry type used during the journal generation and the entry type used during the balance generation (actual mode) must be consistent.

If the two entry types are not consistent, the balance process must be launched on each non-propagated manual ledger where the account needs to be balanced.

Examples

Entry type

Authorized ledgers

Social

Analytical

IAS

Journal generation FRODG

SOC

ANA

IAS

Balance generation FRODG

SOC

ANA

IAS

Selected ledger type = Social, Generation type = Actual

In this case, when generating the balance, the propagation is global.

Entry type

Authorized ledgers

Social

Analytical

IAS

Journal generation FRODG

SOC

ANA

IAS

Balance generation FRODI

SOC

ANA

Selected ledger type = Social; Generation type = Actual

Here, the propagation is incomplete. The IAS ledger is not propagated. If you want to balance the account on the IAS ledger, relaunch the balance process for this ledger type using an entry type that only authorizes IAS ledgers.

For an automatic ledger type, the amounts in the currency transaction are not calculated from the balance.

They are the same as the currency amounts calculated for the origin manual ledger. The ledger amounts for the automatic ledger are calculated by converting its currency amounts according to the journal entry rates.

The selection criteria of the recurring tasks to be closed must be defined.

 

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

Generation

  • Generation type (field TYPGEN)

This field can be used to specify the generation type:

  • Actual: The actual accounting document is a document that can always be viewed and printed (GL, Balance, etc.).
  • Active or inactive simulation.
    SEEREFERTTO See the documentation on the simulation for further information.

It is possible to generate first the journal entry in simulation mode, then, after verification, to restart the processing in actual mode.
In this case, the simulation journal is automatically cancelled and replaced by the real journal which will take into account the new non-invoiced receipts if they exist.

  • Entry status (field ECTSTA)

In the event of an actual generation, the status of the journal can be:

  • Temporary
  • Final

The entry status for entries must be Final when the requested generation type is Actual and the company meets one of the following criteria:

SEEINFO The status defines your ability to modify the document. Once final, the modifications of the journal are only for information purposes or concern the analytical postings. The date, amounts, accounts, VAT code, and other purely accounting information can no longer be modified.

In temporary mode, most of the information displayed on the journal can be modified. The modification options can vary based on:

  • The nature and the origin of the accounting document:
    • Temporary payment document: bank line that cannot be deleted
    • Purchase invoice document: BP line that cannot be deleted, purchase account and VAT that cannot be modified
  • The management events that have an impact on the account document are:
    • Charge account with a declared VAT amount
    • Matched VAT account or not

Each accounting journal entered is linked to a given type. The notion of journal type is used to regroup accounting journals based on their common use principles.

SEEINFO You can specify the entry type, knowing that it will prevail on the default one defined in the GAFTYPACC - Default recurring doc type parameter (CPT chapter, DEF group).

The journal can be initialized by default according to the journal type that has been chosen.
It corresponds to the accounting journal in which the entry will be recorded.

  • Entry date (field DATPCE)

This field identifies the due date.

  • Log file (field TRACE)

Select this check box to generate a log file after running the process.

Close

 

Batch task

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

Specific Actions

The following fields are included on the window opened through this button :

  • Memo code (field CODE)

You use a memo code to save the criteria applied to an entry screen. Use this field to find out if a memo code has already been saved for the current screen values.

Use the following buttons to manage memos:

Recall: Recall a previously defined and saved memo.

Memo: Save the current values of the screen in a memo file with a code to be specified.

Del. Memo: Delete a previously saved memo.

If a memo named STD (standard) is associated with the screen, it is loaded when opening the function.

Close

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

If a memo code entitled STD is associated with the screen, it is loaded immediately on entering the corresponding function.

For further 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 previously saved and change the setup.

Click this action to delete a Memo code.

Limitation

The management and generation of accounting documents using the double-entry method is not available for this function because it does not use an automatic journal process. Only functions that use an automatic journal process can use the double-entry method for a company.

The KRU - Russian legislation activity code must be active to use the double-entry method for a company.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Active simulation entries

There still are simulation entries for this recurring entry that have not been turned into actual ones. The balance cannot be carried out.

The posted documents will have the 'Final' status for the company

If the processing is launched for a given company and this company has selected the French compliance rules (the parameter FRADGI - French fiscal regulation - TC chapter, CPT group is set to 'Yes'), then the documents generated by the processing will have the status 'Final'.

The posted documents will have the 'Final' status for one or more companies

The processing is launched for all companies or group of companies and if at least one of the companies chose French compliance rules (i.e. the parameter FRADGI - French fiscal regulation - TC chapter, CPT group - is set to 'Yes'), the documents generated by the processing will have the status 'Final'.

Tables used

SEEREFERTTO Refer to documentation Implementation