Automatic journals
Use this function to define the structure for journals that must be posted for all modules. This includes posting a sales or purchase invoice entry, a depreciation charge, a payment, an automatic reversal, etc.
Each module generates entries for accounting validation in this way. This transfer is done by a standard subprogram by transferring a code for the operation. For example, the BPCIN code is called when validating a customer business partner invoice.
The application programs control the code used and the time of the call to the generation subprogram.
Setup basics and grouping lines
To set up automatic journals you need to define:
- The header code on the journal entry screen
- The detailed characteristics for the entry set to be transferred
You can also set up automatic journal groups to define automatic journals generated simultaneously by identifying which entries to match.
The definition of an automatic entry is made by defining
- The entry header characteristics
- The line characteristics by means of a series of associated line definitions
Defining a line can lead to the creation of a group of entry lines. Indeed, the type of the lines can be unique, repetitive, or in linked table. The latter two cases can potentially lead to the creation of a group of lines.
Conversely, the lines can be automatically grouped, provided the following criteria are identical on the lines concerned:
- The general ledger
- The business partner (if the general ledger is a control account)
- The site
- The nature
- The label for the line
- The tax code
- The distribution key if a distribution key exists on the line; if it is a dimension, having different dimensions does not prevent grouping lines, an analytical distribution is created.
- The sign if the debit/credit compensation check box is not selected
Defining journals by currencies
You can define a journal by currency by indicating the posting currency in the header fields.
At this stage, managing the currency exchange rates to determine the amounts in accounting and reporting currency is made as follows:
- The amounts in the currency and those in other the currencies are set for all the entry lines by defining the formulas for the Company amount and Reporting amount fields.
This supposes that the calculated amounts are actually balanced in all the currencies. If not, a "Journal not balanced in currency..." error displays.
In all other cases, (i.e., if at least one company and reporting amount is calculated), there is an automatic transfer of the conversion variance lines if not all are balanced in the reporting or company currencies. - If the reporting and company currencies are not defined for certain lines, the formulas defined for the Exchange rate and Reporting exchange rate fields defined in the document header are used: The non-defined amounts are then calculated by applying the rates.
- If the previous case is found, but without the formula for the Exchange rate and/or Reporting exchange rate fields, the exchange rate type is used to determine the exchange rate on the accounting date for the entry posting. Finally, failing this, it is possible to use the exchange rate type associated with the document type to determine the exchange rate to be applied to calculate the missing amounts.
Pure analytical entries
Defining an analytical general ledger is made in the same way as a general document, but imposes an adapted document type and only entering the natures and dimensions concerned, which then becomes mandatory.
Prerequisites
Refer to documentation Implementation
Screen management
Click Lines to open a screen where you can define the journal entry lines to generate.
Header
Entry code (field COD) |
Enter a unique code to identify the entry structure used to validate a document in accounting. |
Description (field DESTRA) |
Short description (field SHOTRA) |
Entry screen
Linked table list
Define the tables linked the triggering table. You can use the fields in these tables in the calculation formula for the previous grid.
Example: Information linked to the business partner record (BPSUPPLIER) for the journal entries can be linked to the invoice.
The second column in this grid defines the field in the triggering table whose value defines the linked record to be read. There are several possibilities: For an invoice, this can be the invoicing BP or the paying BP. Click the Selection icon for a list of possible fields.
Formulas associated with the header fields
In this grid, you can define the calculation formulas used to calculate the value of the fields in the journal entry header. The calculation formulas in this grid must be of the correct type. For example, if the amounts must be numeric, the journal code must be alphanumeric.
These calculation formulas can simply be constants in the most simple case. For example, the sales journals can be constant and called SAL: In this case, a calculation formula "SAL" is sufficient to define the journal. They can also be more complicated and include fields extracted either from the triggering table or from the links tables defined by the Linked table list explained above. In certain cases, a default value is assigned to the field if no calculation formula has been defined.
The VAT date defaults from the accounting date or the document date, depending on the DCLVATDAT – Date for tax declaration parameter (CPT chapter, VAT group) setting. However, you can enter a formula to use a custom date. This date must comply the legislation rules for the declaration.
Key fields in the header:
- Category: a local menu field for which a numeric value must be returned: 1= Actual, 2 = Active simulation, 3 = Inactive simulation, 4 = Off balance sheet, 5= Template. The default value is 1.
- Status: 1=Temporary, 2 = Final. The default value is 1.
- Journal entry type: Mandatory, the journal entry number, which is assigned automatically if it is not set, and the accounting journal. If it is not assigned, the journal associated by default with this journal entry type is used.
- Site: The default site for the user if another site it not entered.
- Different dates: The accounting date is the current date by default. The open item date is the accounting date by default.
- Currency: The site currency is the default. The type of exchange rate, by default, is the one associated with the journal entry type, 1 if not entered.
Selection
Module (field MODULE) |
Select the module where the posting originates. |
Activity code (field CODACT) |
Triggering table (field TBL) |
Enter the table code where the current records triggering the accounting structure are found. For example, to validate the sales invoices, enter the table storing the invoice headers. |
field TBLDES |
Index (field KEYTBL) |
Enter the database table where the master record or records are found with respect to the posting transfer. For example:
This table is covered in the order of a given index. By default, it is the first index. This parameter can be modified. |
Grouping (field GRPFLG) |
Select 1 Journal per line or Grouped journal to process a group of lines in the triggering table. You can choose an accounting document by line or a single global document. 1 Journal per line: This option generates one accounting journal entry when recording the triggering table. Example: When generating invoice account posts, for each record in the invoice file, an accounting journal entry is generated. The current record in the table at this time defines the invoice to be posted. Grouped journal: This option includes all the records in the triggering table. In this case, the table possesses a principal key in N sections and all the records are covered with the first P sections of the given key (P < N). Example: For open item statements (SOI automatic journal, GACCDUDATE table), the DUD2 key is used in three parts (the statement number, the internal identifier of the open item and the line number). One post is generated per open item statement. The table with the first part of the constant key (statement number) is browsed, exploring all its open items, to generate a single accounting document per note for all the open items browsed. |
Entry split table (field REITBL) |
You can generate several documents based on a defined break in a detail table linked to the triggering table. Enter the name of the field where the break must be made. In the next field, you can enter the name of the break field. The lines in this type of journal entry are inevitably all Linked table lines corresponding to table in which the break criteria are found. Example 1
Example 2
|
Field code (field REIFLD) |
You can generate several documents based on a defined break in a detail table linked to the triggering table. Enter the name of the field in which the break occurs. The Entry split table field specifies the name of the table in which the break should be made. |
Link subprogram (field ACTLIK) |
You can intervene in the posting process in some places by calling subprograms. The action name corresponds to the label name defined in the process run when generating the automatic journal. You can intervene at two stages in the posting process:
|
Processing (field PRGLIK) |
Journal subprogram (field ACTAFTVCR) |
Processing (field PRGAFTVCR) |
Grid Linked table list
Linked table (field LIKTBL) |
Enter the name of the tables that must be on the line during the accounting validation of the documents. |
Field (field LIKFLD) |
Enter the name of the field in the principal table whose value is used to identify the key for the linked table. For example, in the case of an invoice, if access to the customer is required, you need to provide the field that is used to identify the customer code. In this example, there is a choice between several codes: bill-to customer, paying customer, statistical customer, etc. |
Grid Legislations
Active (field ACT) |
This check box is selected if the automatic journal is active for the corresponding legislation set up in the folder. |
Legislation (field LEG) |
This field displays the legislation set up in the folder.
|
Block number 5
Negative amounts (field NEGAMT) |
Select this check box to authorize negative amounts in a posting. If it is not selected, a line containing a negative amount to the credit of an account becomes a line with a positive amount to the debit of this same account and a negative amount to the debit of an account becomes a positive amount to the credit of this same account. |
First date (field DATFLG) |
Select this check box to accept entries that fall within a closed period that are then posted on the first date of the first open period. If it is not selected, the automatic posting is not created and an error is generated in the log file. |
Reference (field TYPVCR) |
Select the internal naming structure when the triggering table is PAYMENTH:
The selection triggers automatic processes such as doubtful receipt entry, storage of intermediary treasury accounts, etc. The value is stored in the PAYACCNUM table and is also used to define the stages in payment entry. |
Special features
Filter (field FORCND) |
Use this field to define the filter carried out on the triggering table. The posting is generated only if the value of the expression is verified. The fields of the triggering table and the different linked tables can be used in this expression. Example of expression : [TABLE]FIELD = VALUE where [TABLE] is the header triggering table. Only the recordings of the triggering table for which the FIELD = VALUE is used. If VGLOBALE = VALUE, the table will be used only if VGLOBALE = VALUE |
Condition (field FORCND2) |
Use this field to enter a formula such as AFNC.PARAM("FRAVAT",[F:SIH]CPY)="2". If a recording is not verified by the specified condition, it is not taken into account. The recordings must be filtered before the condition is tested on each one of them. |
Grid Formulas
Description (field INTIT) |
Formula (field FORCLC) |
The evaluation of this expression is used to enter the value of the corresponding field in the accounting document header that will be generated by the structure. Two formulas specific to fixed asset automatic journalsThe two following functions can be used to retrieve the label of an automatic journal or that of its automatic journal lines. This information is then used in the setup of the journal to fill the label, the description, etc. of the posting.
|
Select all |
De-select all |
Inverse selection |
Tab Traceability
Use these fields to link grouped accounting documents to related original transactions in the main general ledger only. This in turn enables a direct link (Tracking/Payments) to related documents from the journal entry lines.
This is only possible for automatic journal groups and where auto journals are used in the payment process.
There are two tracking options:
1. Data linked to an accounting document such as an invoice or a payment.
Upstream traceability is automatic when you select the Traceability check box. Then, you select the Triggering table and Index.
This enables the following option on the accounting document line:
Payments: Provides direct access to each original payment.
Tracking: Opens the Follow-up of an accounting line screen to view a summary of original triggering documents. This screen displays a summary line for each payment and a total for all lines based on the fields entered in the Parameters grid. You can click the Payment line action for each payment to see details.
2. Data not linked to an accounting document such as open items, stock, fixed assets, etc.
Upstream traceability is not automatic and a detailed set up is required. In addition to the steps above, you need to enter an Action and set up the Parameters to display accurate data from the triggering table.
Block number 1
Traceability (field TRCFLG) |
Select this check box to enable tracking. When you select this check box, the remaining fields for traceability become available. |
Trigger element table (field TRCTBL) |
Enter the table that represents the link between the original document and the accounting entry. For example, between payments or stock movements and the accounting entry. |
Index (field TRCKEY) |
Enter the index code from the triggering table to include that data on the accounting entry lines. |
Block number 2
Action (field TRCACT) |
Enter the generic action GASACCNUM1 to trigger the link. You also have the option to enter standard actions such as Object management, Inquiry, or Window entry. The action you enter affects the fields entered in the Parameters grid. |
Grid Parameters
field TRCCODPAR |
This field displays the code for the field. |
field TRCVALPAR |
Enter fields from the triggering table to display data when you select Tracking to open the Follow-up of an accounting line screen. This is required when setting up traceability for data not linked to an object. These fields maintain the link between the source data and the related accounting document lines. |
Reports
By default, the following reports are associated with this function :
GAUTACE : Automatic journals
This can be changed using a different setup.
Menu Bar
Lines
The definition of the characteristics of the entry lines is is triggered by the corresponding button. There is the possibility to select the different lines with the help of a left list, or to create new ones. These entry lines are characterized by a type, general conditions and a list of formulas so as to evaluate the various fields of the lines. The link gridThis grid is used to define the tables where the contents must be on-line for the determination of the posting line characteristics. The defined characteristics are the table name and the field that will give the value of the principal key. Only the tables directly linked either to the principal table of the automatic journal or to the general table (for the lines of the type Linked table) can be selected. The accounting code gridThis table is used to: define the links between the table of the lines and the annex tables (for example the products on the invoice line), in order to use the fields in the tables linked in this way in the field expressions for each line of the entry. determine the General account field (if it not determined completely by an expression, or if the expression is not defined) and Nature field (if it is not defined) by successively applying accounting codes (with respect to the order of the table declaration). An accounting code is an alphanumeric code present in the database records of the software, which is used to influence the entries generated from the information coming from the corresponding record. The accounting code table is characterized by the code type and the alphanumeric code defined for the user (for example FRANCE, EXPORT in the case of the codes linked to the customers, SERVICES, PRODUCTS in the case of the codes linked to the products). There are numerous accounting code types: Product, Customer, Supplier, Commercial, Buyer, Document, Company, Site, Currency, Tax, Footer, Discount, Bank, Payment, Fixed asset etc. For a given type, a group of definition lines characterized by a title is attached. For example, Purchase modifier, Sales modifier, Fixed asset modifier… in the case of a Product code type. Each of these lines is used to define either a general account, or a general account section (the non-defined characters being represented by x) and an analytical nature. The setup that is used to define the lines associated with an accounting code is defined in a dedicated function. During the automatic generation of the journal entries, the determination of the general account is made by successive searches of the accounting codes in the order declared, by looking to assigned only the portions of the account not yet determined. The analytical nature is successively searched for by passing through the accounting codes which only stops when a nature is defined. For instance: For a sales line, the accounting code is defined by the expression " 7xxxxxxx" and the following elements are present in the table of modifiers:
the accounting code is determined by 6 successive passes:
If the nature is not defined by a formula, searches are performed successively in:
the link to the product table is defined by an account code line. List of the fields to be completed in the accounting code grid.1. the accounting code type, the line number, which are used for the search for the account and the nature (the number is entered and the title is displayed, the selection window displays the title directly). 2. An expression is entered where the value corresponds to the key in the table linked (product, customer, supplier). 3. An optional logical expression. If this expression exists, the link to the table and the application of the accounting code are only implemented if the result of the expression evaluation returns the results equal to true. In the group of entered expressions, it is possible to use fields extracted from the on-line tables, which are:
|
This button is used to copy an automatic journal to another folder.
Block number 1
field OBJET |
field CLES |
Block number 2
From folder (field DOSORG) |
Use this field to define the folder from which the record will be copied. The possible syntaxes are described in the Dedicated appendix. |
All folders (field TOUDOS) |
Use this option to copy the record to all the folders defined in the dictionary (ADOSSIER table of the current solution). |
To folder (field DOSDES) |
Use this field to define the folder to which the record will be copied. The possible syntaxes are described in the Dedicated appendix. |