Field help (GAUREITBL)

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

In the group of automatic journals linked to a payment, there is an inter-currency general ledger journal that defines the variance postings linked to the payment in a given currency of a debt issued in another currency:

This journal entry is created from the PAYMENTH table (payment header), with or without grouping, to determine whether to create one journal entry per payment or, if necessary, by note.

Independent of the group, the journal entry is created by using the payment details, and if necessary a set of lines balanced by payment line: each journal entry line is a Linked table type, and the table in question is the PAYMENTD table. A "natural" grouping of lines that can be aggregated can do this. In this way, if the accounts used by the inter-currency general ledgers do not depend on the currency, there is a set of single lines even if several currencies are concerned in the note. If this is not the case, there is a single journal entry containing a set of lines per currency concerned.

Example 2

If you want to create a different inter-currency general ledger document, you need to set up in the Journal breakdown sections the name of the PAYMENTD table and the currency field name (CURLIN). The simple fact of carrying out this setup is enough to split the groups of lines created in the different journal entries.

This process can work only if all the journal lines are Linked table types based on PAYMENTD. It would not be possible to "cut" a single line on which criterion the amount of each line should be determined.