CPTLET script: Matching

MAJLET: Before rewriting the line

The MAJLET entry point is used to intervene during the update of the matching code in the file of the accounting document lines.

Context and operating method

Transaction

There is one transaction in progress

Log file

If the TRACE variable is set to 1, it means that a log file is open. If TRACE is set to 0, there is no open log file.

Call case

The entry point is located just before the rewrite in the GACCENTRYD file (accounting document lines). It is possible, for example, to update a file in the file containing the entries.

Available variables and masks

Open tables

DIFC: Before generating a variance entry

The DIFC entry point is used to intervene right before generating an exchange rate variance entry or a rounding variance entry.

Context and operating mode

Transaction

There is one transaction in progress

Log file

If the TRACE variable is set to 1, it means that a log file is open. If TRACE is set to 0, there is no open log file.

Call case

The entry point is located just before the call to the program used for the generation of an exchange rate variance entry or a rounding variance entry.

After exiting this entry point, the GPE variable is tested and used to generate (or not) the exchange rate or rounding variance entry.

Available variables and masks

The REFERENTIEL variable contains the ledger type on which the variance is detected.

The MONTDEV and MONTDIF variables respectively include the variance amounts in transaction currency and ledger currency.

The XTBECR (entry line number), XTBECH (open item number), XTBIPT (amount of the open item in main general ledger currency) and XTBIPT2 (open item amount in open item currency) tables contain the data from the open items that belong to the matching group for which variances have been identified. The number of open items in the group is in the XNBECH variable.

The GPE variable set to 1 is used to stop the generation of the variance entry.

Open tables

BEFHISDUD: Before updating the open item history

The BEFHISDUD entry point is used to intervene right before calling the subprogram that updates the open item history table so as to modify the event date of the record created in the HISTODUD table for the open item being matched.

Context and operating method

Transaction

There is one transaction in progress.

Log file

If the TRACE variable is set to 1, it means that a log file is open. If TRACE is set to 0, there is no open log file.

Call case

The entry point is located just before calling the HISTOECH subprogram used to update the open item history table. The [L]EVTDAT local variable is set as a parameter in the HISTOECH subprogram and is used to initialize the event date of the record in the HISTODUD table. 

Available variables and masks

By default, the [L]EVTDAT local variable is initialized at the most recent accounting date of the entries included in the group. Nevertheless, it can be changed for specific purposes if the event date of the HISTODUD table needs to be initialized differently.

Open tables

AFTCREVCR: After generating the profit and loss or exchange rate variance entry

The AFTCREVCR entry point is used to intervene after generating a profit and loss entry, or an exchange rate/rounding variance entry. The objective is to update a field in these entries or to populate a specific table.

Context and operating mode

Transaction

There is one transaction in progress

Log file

If the TRACE variable is set to 1, it means that a log file is open. If TRACE is set to 0, there is no open log file.

Call case

The entry point is located right after the call to the GEN_PIECE subprogram which generates a profit and loss entry. It is also located after the second call to the GEN_PIECE subprogram used either to generate an exchange rate variance entry (EUR currency in one case and another currency in the other) or a rounding variance entry (if EUR currency used everywhere).

Available variables and masks

The PCETYP sized variable includes the type of the generated entry. IPCE is the current index of the variable

The PCENUM sized variable contains the number of the generated entry. IPCE is the current index of the variable

The REFERENTIEL variable contains the ledger type for which the variance is detected.

The MONTDEV and MONTDIF variables respectively include the variance amounts in transaction currency and ledger currency.

The XTBECR (entry line number), XTBECH (open item number), XTBIPT (amount of the open item in main general ledger currency) and XTBIPT2 (open item amount in open item currency) tables contain the data from the open items that belong to the matching group for which variances have been identified. The number of open items in the group is contained in the XNBECH variable.

Open tables

BEFWRIMTB: Before writing in the MTCBATCH table

The BEFWRIMTB entry point is used to intervene right before writing in the MTCBATCH batch matching table, to update one or several fields in the table.

Context and operating mode

Transaction

There is one transaction in progress.

Log file

No open log file.

Call context

The entry point is located in the CPTLET script right before the WRITE in the MTCBATCH table. The purpose is to update one or several fields before writing a record in this table.

Available variables and masks

Open tables