FILTRE: Additional filter on conversion variances

Use this entry point to add an extra filter to conversion variances of balance sheet type only.

Context and operating mode

Transaction

There is no transaction.

Log file

There is an open log file.

Different call cases

This entry point is called just after the initialization of the FILECT standard filter.

It is used to add an extra filter to variances of valance sheet type only.

Available variables and masks

The variable to use is the FILTRE_SPE variable with a length of 250.

The standard filter is contained in the FILECT variable. Its content is:

Variable

Definition

[F:DAEB]LEDTYP

 Ledger type

[F:DAEB]CPY

 Company

[F:DAEB]FCYLIN

 Site

[F:DAEB]ACC

 Account

[F:DAEB]BPR

 BP

[F:DAEB]MTC

 Matching

[F:DAEB]MTCDATMAX

 Maximum group date

Open tables

Table

Significant content

Table Title

 COMPANY [CPY]

 Yes

 Company

 GACM [GCM]

 Yes

 Account core model

 GLED [LED]

 Yes

 Ledger

 GCOA [COA]

 Yes

 Chart of accounts

 FACILITY [FCY]

 Yes

 Site

 GACCOUNT [GAC]

 

 Account

 GACCOUNT [GACC]

 Yes

 Account

 FISCALYEAR [FIY]

 

 Fiscal years

 FACGROUP [FGR]

 

 Site grouping

 ADOVAL [ADW]

 

 Parameter values

 TABCUR [TCU]

 

 Currency table

 PERIOD [PER]

 

 Periods

 GRPSAC [GSC]

 

 Analytical allocations

 BALANCE [BAL]

 

 General balance

 GRPSAC[GSC]

 

 Control account groups

 GTYPACCENT [GTE]

 

 Entry type

 GACCENTRYD [DAEA]

 

 Accounting document lines

 GACCENTRYD [DAEB]

  

 Accounting document lines

 GACCENTRYD [DAEC]

 

 Accounting document lines

 GACCENTRY [HAE]

 

 Accounting documents

 GACCENTRY [HAE1]

 

 Accounting documents

 GJOURNAL [JOU]

 

 Accounting journals

 TMPCNVECAR [TCE]

 

 Conversion variance temporary table

 

AFTCALCNV: After calculation of conversion variances

Use this entry point to take over after each conversion variance of an account is generated, regardless of the variance type, in order to update the specific fields or tables.

Context and operating mode

Transaction

There is a transaction.

Log file

There is an open log file.

Different call cases

The entry point is called just after the calculation and generation of the conversion variance entries.

Available variables and masks

The GOK variable is tested after the call to the entry point to stop (GOK=0) or redo (GOK<1) the transaction.

Open tables

Table

Significant content

Table Title

 COMPANY [CPY]

 Yes

 Company

 GACM [GCM]

 Yes

 Account core model

 GLED [LED]

 Yes

 Ledger

 GCOA [COA]

 Yes

 Chart of accounts

 FACILITY [FCY]

 Yes

 Site

 GACCOUNT [GAC]

 

 Account

 GACCOUNT [GACC]

 Yes

 Account

 FISCALYEAR [FIY]

 

 Fiscal years

 FACGROUP [FGR]

 

 Site grouping

 ADOVAL [ADW]

 

 Parameter values

 TABCUR [TCU]

 

 Currency table

 PERIOD [PER]

 

 Periods

 GRPSAC [GSC]

 

 Analytical allocations

 BALANCE [BAL]

 

 General balance

 GRPSAC[GSC]

 

 Control account groups

 GTYPACCENT [GTE]

 

 Entry type

 GACCENTRYD [DAEA]

 

 Accounting document lines

 GACCENTRYD [DAEB]

  

 Accounting document lines

 GACCENTRYD [DAEC]

 

 Accounting document lines

 GACCENTRY [HAE]

 

 Accounting documents

 GACCENTRY [HAE1]

 

 Accounting documents

 GJOURNAL [JOU]

 

 Accounting journals

 TMPCNVECAR [TCE]

 

 Conversion variance temporary table

 

CALBSEDIF: Calculation of conversion variances of balance sheet type

Use this entry point to reroute the calculation of conversion variances of balance sheet type, for example, to populate a specific table that can potentially be the triggering table of the automatic entry. This entry point is called during the read of accounts to process.

Context and operating mode

Transaction

There is a transaction.

Log file

There is an open log file.

Different call cases

This entry point is called in the account read loop to reroute the standard calculation of conversion variances of balanche sheet type.

Available variables and masks

The GPE variable is used to reroute the standard calculation if the variable is set to 1. The GPE variable is set to 0 by default.

Open tables

Table

Significant content

Table Title

 COMPANY [CPY]

 Yes

 Company

 GACM [GCM]

 Yes

 Account core model

 GLED [LED]

 Yes

 Ledger

 GCOA [COA]

 Yes

 Chart of accounts

 FACILITY [FCY]

 Yes

 Site

 GACCOUNT [GAC]

 

 Account

 GACCOUNT [GACC]

 Yes

 Account

 FISCALYEAR [FIY]

 

 Fiscal years

 FACGROUP [FGR]

 

 Site grouping

 ADOVAL [ADW]

 

 Parameter values

 TABCUR [TCU]

 

 Currency table

 PERIOD [PER]

 

 Periods

 GRPSAC [GSC]

 

 Analytical allocations

 BALANCE [BAL]

 

 General balance

 GRPSAC[GSC]

 

 Control account groups

 GTYPACCENT [GTE]

 

 Entry type

 GACCENTRYD [DAEA]

 

 Accounting document lines

 GACCENTRYD [DAEB]

  

 Accounting document lines

 GACCENTRYD [DAEC]

 

 Accounting document lines

 GACCENTRY [HAE]

 

 Accounting documents

 GACCENTRY [HAE1]

 

 Accounting documents

 GJOURNAL [JOU]

 

 Accounting journals

 TMPCNVECAR [TCE]

 

 Conversion variance temporary table