Entry points > Module Supervisor > Standard script DCLVAT 

FILTRE: Additional filter on the sites.

This entry point is used to restrict the VAT declaration to certain sites.

Context and operating method

Transaction

There is no transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point is called for each company concerned by the declaration, in the site table.

Available variables and masks

The [L]CRITERE variable is used to enter the selection criterion. The condition is evaluated in the loop on the sites of the company in process.

The DCLVAT mask is available and contains the release setups of the function.

Variable or mask

Definition

 DCLVAT [DIA] Mask

VAT declaration

 CRITERE(250) Char

 

 

 

 

Open tables

Only the Company and Currencies tables have a significant content in this context.

Table

Significant content

Table Title

COMPANY

X

Companies

TABCUR

X

Currency table

FACILITY

 

Sites

DAEFILTRE: Additional filter on the VAT declaration postings.

This entry point is used to complete the standard filter made on the document line table to take into account the postings in the VAT declaration program.

Context and operating method

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point is called at the start of the transaction in the VAT declaration process for a company.

Available variables and masks

The [L]DAEFILTRE variable is used to enter the selection criterion. The condition is evaluated in the company accounting document lines loop for which the VAT declaration is carried out.

The DCLVAT mask is available and contains the release setups of the function.

Variable or mask

Definition

 DCLVAT [DIA] Mask

VAT declaration

 DAEFILTRE(250) char

 

SOC char

Company

 TTYP(1..NBTYP) char

Variables grid containing the document types to be considered in the VAT declaration.

 

Open tables

Table

Significant content

Table Title

COMPANY

X

Companies

TABCUR

X

Currency table

FACILITY

 

Sites

AV_ECRDVP: Before writing in the temporary DCLVATPAY table.

This entry point is used to insert additional logic just before the posting to the temporary DCLVATPAY table in order to modify the value of certain field in the table or to initialize certain specific/custom fields that have been added.

The DCLVATPAY table is used by the VAT declaration report.

Context and operating method

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point is called just before the write to the temporary table DCLVATPAY [DVP]. Four "Write [DVP]" are made in the VAT declaration program corresponding to different types of record postings:

[DVP]TYPREC = 0 record serving to store the selection criteria ; [DVP]TYPREC = 2 for de-matched postings ; [DVP]TYPREC = 3 pre-payment cases ; [DVP]TYPREC = 1 other records.

The [DVP]TYPREC field is initialized just before the call to the entry point.

                                                                                 

Available variables and masks

The DCLVAT mask is available and contains the release setups of the function.

 

Open tables

Table

Significant content

Table Title

COMPANY

X

Companies

TABCUR

X

Currency table

FACILITY

 

Sites

DCLVATPAY

X

Temporary VAT declaration table

NOM_ETAT: Name of the reports to print

This entry point is used to modify the codes of the VAT declaration reports to print.

Context and operating method

Transaction

There is no transaction in progress.

Log file

There is no open log file.

Different call cases

This entry point is called just before printing the VAT declaration Reports (debits and cash receipts), it is also used to modify the codes of the reports to print.

The [L]ETAT_DEB variable contains the name of the VAT declaration on debits Report to print. By default, this variable is initialized at DCLVATDEB1 but its value can be changed via this entry point.

The [L]ETAT_ENC variable contains the name of VAT declaration on cash receipts Report to print. By default this variable is set to DCLVATENC1.

The DCLVAT mask is available and contains the release setups of the function.

Variable or mask

Definition

 DCLVAT [DIA] Mask

VAT declaration

 Char ETAT_DEB (GLONARP)

Name of the VAT declaration on debits

 Char ETAT_ENC (GLONARP)

Name of the VAT declaration on cash receipts

 

FILTREDEB: Additional filter on the VAT declaration on debits postings.

This FILTREDEB entry point is used to complete the standard filter made on the document line table to take into account the postings in the VAT declaration on debits program.

Context and operating method

Call context

There is no transaction in process
There is an open log file.

Available variables and masks

The DCLVAT mask is available and contains the release setups of the function.

The local variable OPT contains the value of the DCLVATDAT parameter.
The local variable CRITBED contains the selection criteria of the documents' headers (GACCENTRY table).
The local variable CRITDEB2 contains the selection criteria of the documents' lines (GACCENTRYD table).

Note:The CRITDEB variable does not contain selection criteria on the GACCENTRYD table anymore. The CRITDEB2 variable is used instead.

The COMPANY [CPY] et TABCUR [TCU] tables are open and contain the company under process and the currency used.