Batch Entry
Use this function to enter a set, or a group of journals.
Each batch must balance to zero before it can be validated. Only balanced batches can be posted and the accounting entries generated.
Prerequisites
Refer to documentation Implementation
Screen management
This function is customized to the needs of your organization and your processes. The transaction you select determines the way in which you enter information, and information is displayed and printed.
If only one transaction has been set up you are not offered a choice, the default entry screen is displayed.
The Batch entry function displays a journal header information area and an area into which you add the journal lines.
Entry screen
Type in, or select the journal header information for this batch of journals, including the site at which the postings are to be made.
Then type in the journal lines. Each new journal (field Entry='Yes') can be entered in a different currency from the previous journal.
Block number 1
Batch (field LOT) |
This code is the sole identifier in batch entry mode. |
Transaction (field DACDIA) |
Select the entry transaction that will be used to generate the entries. Parameter SCHSAILOT - Batch entry transaction (chapter CPT, group DEF) can be set to provide the default entry transaction. |
Entry transaction (field DACDIAGAS) |
Select the entry transaction that will be used to generate the entries if a default entry transaction is displayed in the Transaction (field DACDIA) field. |
Posted (field UPDFLG) |
This field is not available for entry. It is selected when the batch has been validated by the batch validation process. |
Block number 2
Site (field FCY) |
The site code for the operation is initialized with the site associated with the user code. It can be modified on the condition that it is chosen in the list of authorized sites. |
Journal (field JOU) |
The batch entry is a single-journal one. Only operations on journal types authorizing the use of this journal can be saved. |
Description (field DESLOT) |
Type in a description for this record (maximum 30 alphanumeric characters). |
Grid Input
No. (field NUMLIG) |
It is the line number. |
Entry (field NEW) |
This field is used to dissociate journals in the batch and to recognize the entry lines of a journal. |
Type (field TYP) |
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. This information comes with management rules relating to VAT, reminders, etc. It is one of the key elements of the journal entry. The setup of the selected journal type determines if you can open or close the propagation to the manual ledgers. The journal type prevails and interrupts the propagation to the other ledgers of the company of the entry site. |
Date (field ACCDAT) |
This date corresponds to the date of the generated accounting postings. It must belong to a fiscal year or period that is open for all the ledger types. |
Currency (field CUR) |
The currency in which the posting will be recorded (called the transaction currency) is, by default, the main general ledger currency for the company to which the site belongs. If the currency is different from the original currency the conversion will be based on the exchange rates recorded in the database for the chosen rate type and the rate date.
All amounts and rates, either entered or imported, are converted and stored in the transaction and ledger currency. Hence, the journal can only be created if both conversion exchange rates relevant to this operation are entered (for all ledgers types included in the posting). |
Site (field FCYLIN) |
You can enter on the entry line a site that is different from the one indicated in the header. |
Ctrl. (field SAC1) |
The account associated to the collective account is displayed by default. The BP is left to specify. In the case of a multi-role BP, the search algorithm is function of:
The initialization of the code for the Control field depends on whether or not the BP/Company tab is present in the BP record (GESBPR). |
field ACC1 |
This field is used to select the accounts recorded on the current chart of accounts. On this ACC field, the user can access the current ledger's accounts only. In the case of a general account that is not attached to a collective account, enter its number or its calling code (of the account file or the journal). |
BP (field BPR) |
Specify the BP code. If the Collective and Account fields are empty, the number of the collective account will be determined by the BP accounting code. Searching this account is carried out in accordance with the priority order in the journal entry transaction, (field BP search),and takes into account the tab BP/Company if it is present. |
Document no. (field NUM) |
This field represents the unique identifier of a journal in a journal type. |
Debit (field DEB) |
If the journal line is a debit, type in the debit amount. The default sign is defined in the account file. If the default account sign is not defined the cursor is positioned on the field that is used to balance the journal. The journal must balance in the transaction currency. A rounding variance line is generated automatically to balance the journal in the ledger currency, if necessary. |
Credit (field CDT) |
If the journal line is a credit, type in the credit amount. The default sign is defined in the account file. If the default account sign is not defined the cursor is positioned on the field that is used to balance the journal. The journal must balance in the transaction currency. A rounding variance line is generated automatically to balance the journal in the ledger currency, if necessary. |
Description (field DES) |
This is a free field, designed to explain the posting of this entry By using " / ", the account title is displayed by default ; and with "=", the previous line description is copied. |
Tax (field TAX) |
When the account on the line is subject to tax, the tax field is accessible for entry. It is initialized with the tax code associated with the account. According to the context, it is necessary to verify that this tax code corresponds to the tax actually applicable, or it should be modified. The tax code defines the rate, the rules, and the terms for the deduction applicable to the operation. If the Control type field is set to Inactive for the Account, you can enter any value on the line. If the Control type field is set to Authorization for the Account, you can only enter a code listed in the Tax control grid on the Management tab in the Account. Otherwise, you receive a blocking message. If the Control type field is set to Restriction for the Account, you can only enter a code that is not listed in Tax control grid. Otherwise, you receive a blocking message. |
Unit (field UOM) |
Upon analytical account setting up, it is determined whether any non-financial units will be entered, and then a unit is assigned to the account by specifying its default value (in common currency). It is this unit that will appear during the entry of the journal. The quantity is automatically calculated by dividing the ex-tax amount by the working unit value. The quantity can be modified. |
Quantity (field QTY) |
Because of the analytical nature of a line, you have to enter a quantity expressed in the indicated non-financial unit.
This information can be processed on the analytical and budgetary reports and be useful for the automatic calculation of the analytical allocations. |
Distribution (field DSP) |
Defined here are the allocation methods for the line amount on the different dimensions of each dimension type. These methods are defined as follows:
For instance: For these two later cases, it is possible to pre-initialize the allocation with an already existing key. The final display will be " $ ". |
field CCE1 |
Indicate in this field the dimensions that should be assigned to the posting line.
If the accounting amount is not distributed over several analytical dimensions, the "allocation" field cannot be assigned. The entry is achieved directly in the following columns, in the dimension concerned, for each of the dimension types. Default dimensions can be specified in the analytical account and taken into account or not, according to the default dimension setup. For the journals automatically generated from other modules, the default dimensions are defined by a process (see the Default dimensions documentation). |
Reference (field REF) |
This field contains the journal reference. |
Source document (field BPRVCR) |
The 'source document' and 'document date' fields respectiveley correspond to the reference (journal number) and date of the BP journal. |
Document date (field BPRDATVCR) |
Entry date (field ENTDAT) |
Due date (field DUDDAT) |
Value date (field VALDAT) |
The default value of the value date is the entry date. |
Totals
Total debit (field TOTDEB) |
Total of the debit lines which compose the posting lines. |
field CURAFF |
Entry currency. |
Total credit (field TOTCDT) |
Total of the credit lines which compose the posting lines. |
field CURAFF2 |
Account
Description (field AFFICHE) |
Balance (field SOLDE) |
This field displays the total sum of debits and credits. |
Account inquiry |
Click Account inquiry from the Actions icon to view the postings to the account. |
Analytical account inquiry |
Click Analytical account inquiry from the Actions icon to view the postings to the analytical dimension. |
Statistical codes |
Click Statistical codes from the Actions icon to view the figures for selected statistical analysis codes. |
Reports
By default, the following reports are associated with this function :
LOT : Print lot list
This can be changed using a different setup.
Barre de menus
Click the Transaction action to view the format of this entry transaction. |
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
"Dimension type ? mandatory"A dimension type is defined as mandatory in the Parameter values (ADPVAL) function.
"Type of journal not authorized"The journal code displayed in the header is not compatible with the journal type entered on the line.