Recurring Entry Balancing
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.
Read the documentation for Partner initialization and Flow initialization.
Prerequisites
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
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.
Criteria
All companies (field TOUSOC) | ||||||||||||||||||||||||||||||
Select this check box to run the process for all companies. Otherwise, you need to select a company. Specific caseIn 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. |
||||||||||||||||||||||||||||||
Company (field CPY) | ||||||||||||||||||||||||||||||
This is the code of the assignment company of the entity. |
||||||||||||||||||||||||||||||
Legislation (field LEG) | ||||||||||||||||||||||||||||||
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. |
||||||||||||||||||||||||||||||
Site (field FCY) | ||||||||||||||||||||||||||||||
Enter the site code. |
||||||||||||||||||||||||||||||
All users (field TOUUSR) | ||||||||||||||||||||||||||||||
No help linked to this field. |
||||||||||||||||||||||||||||||
User (field USER) | ||||||||||||||||||||||||||||||
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 non automatic and non prohibited 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 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
Selected ledger type = Social, Generation type = Actual In this case, when generating the balance, the propagation is global.
Selected ledger type = Legal; 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 transaction currency are not calculated from the balance. They are the same as the currency amounts calculated for the original manual ledger. The ledger amounts for the automatic ledger are calculated by converting its currency amounts according to the journal entry rates. |
||||||||||||||||||||||||||||||
From recurring entry (field ABTDEB) | ||||||||||||||||||||||||||||||
The selection criteria of the recurring tasks to be closed must be defined. |
||||||||||||||||||||||||||||||
To recurring entry (field ABTFIN) | ||||||||||||||||||||||||||||||
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:
It is possible to generate first the journal entry in simulation mode, then, after verification, to restart the processing in actual mode. |
Entry status (field ECTSTA) |
In the event of an actual generation, the status of the journal can be:
The entry status for entries must be Final when the requested generation type is Actual and the company meets one of the following criteria:
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:
|
Entry type (field TYPPCE) |
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. 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). |
Journal (field JOU) |
The journal can be initialized by default according to the journal type that has been chosen. |
Entry date (field DATPCE) |
This field identifies the due date. |
Log file (field TRACE) |
Select this check box to generate a log file at the end of the run. |