DCLCUSVATBEL script: DCLCUSVATBEL
FILTER_FCY: Filter on the sites
Use this entry point to filter the site(s) of the launching company before generating the list.
Context and operating method
Transaction
There is one transaction in progress.
Log file
There could be an open log file depending on the launch criterion.
Different call cases
The "FILTER_FCY" entry point is set just before the loop on the legal sites of the company.
It is used to exclude or limit to one or several sites.
Available variables and masks
The [L]SPE_CRITERE variable is used to enter the selection criterion. The condition is evaluated in the loop on the sites of the launching company.
The DCLCUSVATBEL mask is available and contains the release parameters of the function.
Variable or mask | Definition |
DCLCUSVATBEL [DIA] mask | Annual customer listing |
Char SPE_CRITERE (250) | |
Open tables
Only tables with a significant content in the context are listed.
Table | Significant content | Table title |
BPCUSTOMER [BPC] | Yes | Customers |
BPADDRESS [BPA] | Yes | Addresses |
FACILITY | Yes | Sites |
FILTER_TVA1: Filter by VAT number
Use this entry point to filter invoices by VAT number for the annual customer listing (DCLCUSVATBEL).
Context and operating mode
Transaction
There is a transaction opened.
Log file
There is one log file opened.
Call cases
The entry point is called before writing the required data as a line to the DATEV export file.
Available variables and masks
[M:DTE] mask is available.
| Variable or mask |
Definition |
|
Mask DCLCUSVATBEL [M:DIA] |
Annual customer listing |
|
Local Char
|
Char variable to create additional filter criteria |
Example
When the entry point is called, it can be defined as an additional filter on the table for lines that should be exported or not.
$ACTION
Case ACTION
When " FILTER_TVA1 " : Gosub FILTER_TVA1
When Default
Endcase
RETURN
$ FILTER_TVA
#filter by company
FILTER_TVA = "COMPANY = "Belgian Company""
RETURN
Open tables
| Table |
Significant content |
Table Title |
|
DCLCUSVATBE |
Yes |
Annual customer listing |
|
DCLCUSVATBED |
Annual customer listing |
|
|
FACILITY |
No |
Sites |
|
COMPANY |
No |
Company |
|
TABCOUAFF |
No |
Sequence no. assignments |
|
GTYPACCENT |
No |
Document types |
|
TABVAT |
No |
Tax code table |
|
TABVACBPR |
No |
BP tax rule table |
|
TABRATVAT |
No |
Tax rates |
|
TABCUR |
No |
Currency table |
|
GACCENTRY |
No |
Accounting entries |
|
GACCENTRYD |
No |
Accounting entry lines |
|
SINVOICE |
No |
Sales invoices |
|
SINVOICEV |
No |
Costing sales invoice |
|
GACCOUNT |
No |
Accounts |
|
BPARTNER |
No |
Chart of accounts |
|
BPCUSTOMER |
No |
Business partner |
|
BPADDRESS |
No |
Addresses |
|
AOBJEXT |
No |
Import/export templates |
|
AOBJEXTD |
No |
Object import/export lines |
|
AOBJEXTR |
No |
Transcribe import/export |
|
ATABLE |
No |
Table dictionary |
FILTER_TVA2: Modify BP account data
Use this entry point to filter invoices by VAT number for the annual customer listing (DCLCUSVATBEL).
Context and operating mode
Transaction
There is a transaction opened.
Log file
There is one log file opened.
Call cases
The entry point is called before writing the required BP account data as a line to the DATEV export file.
Available variables and masks
[M:DTE] mask is available
| Variable or mask |
Definition |
|
Mask DCLCUSVATBEL [M:DIA] |
Annual customer listing |
|
Local Tinyint
|
Numeric variable to indicate if data is taken into account for VAT declaration |
Example
When the entry point is called, it is looped over journal entries taken into account for the VAT declaration. By setting the Tinyint FILTER_TVA2 <> 0, the program can prevent a specific entry from being taken into account.
$ACTION
Case ACTION
When " FILTER_TVA2 " : Gosub FILTER_TVA2
When Default
Endcase
RETURN
$ FILTER_TVA2
#check if valid
If NOTVALID
FILTER_TVA2 = 1
ENDIF
RETURN
Open tables
| Table |
Significant content |
Table Title |
|
DCLCUSVATBE |
Yes |
Annual customer listing |
|
DCLCUSVATBED |
Annual customer listing |
|
|
FACILITY |
No |
Sites |
|
COMPANY |
No |
Company |
|
TABCOUAFF |
No |
Sequence no. assignments |
|
GTYPACCENT |
No |
Document types |
|
TABVAT |
No |
Tax code table |
|
TABVACBPR |
No |
BP tax rule table |
|
TABRATVAT |
No |
Tax rates |
|
TABCUR |
No |
Currency table |
|
GACCENTRY |
Yes |
Accounting entries |
|
GACCENTRYD |
Yes |
Accounting entry lines |
|
SINVOICE |
Yes |
Sales invoices |
|
SINVOICEV |
No |
Costing sales invoice |
|
GACCOUNT |
Yes |
Accounts |
|
BPARTNER |
No |
Chart of accounts |
|
BPCUSTOMER |
No |
Business partner |
|
BPADDRESS |
No |
Addresses |
|
AOBJEXT |
No |
Import/export templates |
|
AOBJEXTD |
No |
Object import/export lines |
|
AOBJEXTR |
No |
Transcribe import/export |
|
ATABLE |
No |
Table dictionary |