Financials > Journals > 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

SEEREFERTTO 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

Presentation

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.

Close

 

Fields

The following fields are present on this tab :

Block number 1

  • Batch (field LOT)

This code is the sole identifier in batch entry mode.
The journal batches are recorded under a code having an automatic numbering.

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.

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

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.
The site must be a financial one.
It can be modified on the line and the record of the journal will generate line postings (on the accounts defined in the chart of accounts).

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.
For each new journal, enter "Y" ("New journal = Yes") on the first entry line and "N" for the following entries about the same journal. The type, date, currency and site information of the previous line will be displayed again by default.
It is not necessary for the journals to be balanced in order to save a batch. On the other hand, they need to be for the batch to be validated.

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.

SEEWARNINGThe 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.
It is the reference date by default.

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.

SEEINFO 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).
For conversions between IN currencies, the conversion exchange rates are automatically defined in the currency table. For other conversions, a
rate must have been defined for the date of the journal or for an earlier date.

You can enter on the entry line a site that is different from the one indicated in the header.
Both sites must belong to the same company. Depending on the situation, link postings will be automatically generated on the link accounts previously set up.

  • 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 transaction used,
  • and the presence or not of the "Company BP" tab.

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

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.
The ACC1 field can be entered 'In line' and 'In column'. ACC2 fields and above can be accessed only for the 'In column' entry.
In 'In column' entry mode, the column's name is the one that has been parametrized in the chart of accounts.

SEEWARNING 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).

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.
The journal number is generated automatically via a counter linked to the journal type. This number can also be entered manually, if such an option has been defined when creating each journal type.
If the entry of the journal number is authorized and this number is blank, the journal number is generated according to the setup of the sequence number counter associated with this type of journal.

  • 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.
The offset is generated automatically for a cash journal.

  • 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.
The offset is generated automatically for a cash journal.

  • Description (field DES)

This is a free field, designed to explain the posting of this entry
The default value of this field is the Description field entered in the journal header.

By using " / ", the account title is displayed by default ; and with "=", the previous line description is copied.

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 Restrictionfor the Account, you can only enter a code that is not listed in Tax control grid. Otherwise, you receive a blocking message.

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.
The default value of this field is calculated based on the amount of the entry line and the "Unit value" line of the analytical account, by dividing the ex-tax amount (converted into devise commune) by the value of the non-financial unit. The quantity can be modified.

SEEINFO 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:

  • the entry of an analytical allocation key previously configured,
  • in amount: it is then possible to allocate the amount to as many dimensions as required.
  • in percentge: a calculation is performed based on the sum of the coefficients used in the allocation.

For instance:
On a basis of 100, a coefficient of 10 will be read as 10%. But, on a basis of 50, a coefficient of 10 will be equivalent to 20%.

For these two later cases, it is possible to pre-initialize the allocation with an already existing key. The final display will be " $ ". 

Indicate in this field the dimensions that should be assigned to the posting line.
The entry of this field:

  • can be mandatory for a dimension type. (see the company record setup)
  • is controlled according to the setup of the prohibited account-dimension and dimension-dimension codes.

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.
Entry of this field is free and not controlled, but it can be useful when looking for a journal whose number is unknown, or to match accounts.

  • Source document (field BPRVCR)

The 'source document' and 'document date' fields respectiveley correspond to the reference (journal number) and date of the BP journal.
For example:
for the supplier, it is the number and date of the supplier invoice.

  • Document date (field BPRDATVCR)

 

  • Entry date (field ENTDAT)

The default value for this field is the entry date.

  • Due date (field DUDDAT)

Indicate the journal due date.
This field can be used for the printing of reminders, as a due date schedule etc.

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

Entry currency.

  • Total credit (field TOTCDT)

Total of the credit lines which compose the posting lines.

 

Account

  • Description (field AFFICHE)

 

  • Balance (field SOLDE)

This field displays the total sum of debits and credits.

Close

 

Action icon

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.

 

Close

 

Reports

By default, the following reports are associated with this function :

 LOT : Print lot list

This can be changed using a different setup.

Actions menu

Zooms / Transaction

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.

Tables used

SEEREFERTTO Refer to documentation Implementation