FILTRE: Additional filter on the open items

Use this entry point to add a specific filter to the open items to select during the processing of payment automatic proposal processing.

Context and operating mode

The following tables are on line :

Table

Significant content

Table description

GRPSAC [GSC]

No

Control groups

GRPCUR [GCU]

No

Currency groups

BID [BID]

No

Bank ID statement

COMPANY [CPY]

No

Company

GACCOUNT [GAC]

No

Accounts

TABDEPAGIO [TDA]

No

Early discount/late charge table

SOI [SOI]

No

Statement creation

BANK [BAN]

No

Bank accounts

POOL [POO]

No

Banking pool

GACCDUDATE [DUD]

No

Open items

TABCOUAFF [TCA]

No

Sequence No assignments

GACCDENCOD [CDA]

No

Payment attribute

TABPAYTYP [TPY]

No

Payment transactions

PAYMENTH [PYH]

No

Payment header

PAYMENTD [PYD]

No

Payment lines

PAYMENTA [PYA]

No

Analytical payment lines

GACCENTRY [HAE]

No

Accounting entries

GACCENTRYD [DAE]

No

Accounting entry lines

BPARTNER [BPR]

No

Business partner

BPCUSTOMER [BPC]

No

Customers

BPSUPPLIER [BPS]

No

Suppliers

TMPPAYDUD [TPD]

No

Temporary payment proposal

Transaction

There is no transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point is used when creating the selection filters for open items, before the payment creation transaction.

Available variables and masks

The variable that is used to enter the additional criteria is the [L]CRITSPE variable, length 255. It is reinitialized before the entry point is called.

The mask used for the criteria entry is PAYPROPAL, with the abbreviation DIA.

Variable or mask

Definition

PAYPROPAL [DIA]

 Criteria entry mask

Variable char CRITSPE(255)

 Entry of additional criteria

REGROUP: Grouping of items

Use this entry point to add a specific grouping to open items during the processing of payment automatic proposal processing.

Context and operating mode

The following tables are on line :

Table

Significant content

Table description

GRPSAC [GSC]

No

Control groups

GRPCUR [GCU]

No

Currency groups

BID [BID]

No

Bank ID statement

COMPANY [CPY]

No

Company

GACCOUNT [GAC]

No

Accounts

TABDEPAGIO [TDA]

No

Early discount/late charge table

SOI [SOI]

No

Statement creation

BANK [BAN]

No

Bank accounts

POOL [POO]

No

Banking pool

GACCDUDATE [DUD]

No

Open items

TABCOUAFF [TCA]

No

Sequence No assignments

GACCDENCOD [CDA]

No

Payment attribute

TABPAYTYP [TPY]

No

Payment transactions

PAYMENTH [PYH]

No

Payment header

PAYMENTD [PYD]

No

Payment lines

PAYMENTA [PYA]

No

Analytical payment lines

GACCENTRY [HAE]

No

Accounting entries

GACCENTRYD [DAE]

No

Accounting entry lines

BPARTNER [BPR]

No

Business partner

BPCUSTOMER [BPC]

No

Customers

BPSUPPLIER [BPS]

No

Suppliers

TMPPAYDUD [TPD]

No

Temporary payment proposal

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 end of the update of the REGROUP variable in order to add a specific grouping to the outside statement open items. (Variable [L]OK_GRP=1)

This entry point is called at the end of the update of the REGROUP_SOI variable in order to add a specific grouping to the open items on statement. (Variable [L]OK_GRP=0)

This two variables -with a length of 255- are evaluated in order to be stocked in the GRPCRI field in temporary tables TMPPAYDUD and TMPPAYDUD2. This field is used to set up breaks in order to create payments according to the grouping of the open items.

Available variables and masks

To differentiate the two call cases, the [L]OK_GRP variable is initialized just before the call to the entry point.

The [L]REGROUP ([L]OK_GRP=1) variable is used to group the open items outside statements.

The [L]REGROUP_SOI ([L]OK_GRP=0) variable is used to group the open items on statements.

The SEP variable is used to separate the fields from the REGROUP and REGROUP_SOI variables. In standard, the SEP variable is initialized to ";".

The mask used for the criteria entry is PAYPROPAL, with the abbreviation DIA.

Variable or mask

Definition

PAYPROPAL [DIA]

Criteria entry mask

Variable char REGROUP(255)

Grouping of open items outside statements

Variable Char REGROUP_SOI (255)

Grouping of open items on statements

Variable char SEP(5) 

Field separator

Variable OK_GRP

Identifies the entry point call cases

FILTRE_SOI: Additional filter on the open item statements

This entry point is used to add a specific filter on the open item statements to select during the payment automatic proposal processing.

Context and operating mode

The following tables are on line :

Table

Significant content

Table description

GRPSAC [GSC]

No

Control groups

GRPCUR [GCU]

No

Currency groups

BID [BID]

No

Bank ID statement

COMPANY [CPY]

No

Company

GACCOUNT [GAC]

No

Accounts

TABDEPAGIO [TDA]

No

Early discount/late charge table

SOI [SOI]

No

Statement creation

BANK [BAN]

No

Bank accounts

POOL [POO]

No

Banking pool

GACCDUDATE [DUD]

No

Open items

TABCOUAFF [TCA]

No

Sequence No assignments

GACCDENCOD [CDA]

No

Payment attribute

TABPAYTYP [TPY]

No

Payment transactions

PAYMENTH [PYH]

No

Payment header

PAYMENTD [PYD]

No

Payment lines

PAYMENTA [PYA]

No

Analytical payment lines

GACCENTRY [HAE]

No

Accounting entries

GACCENTRYD [DAE]

No

Accounting entry lines

BPARTNER [BPR]

No

Business partner

BPCUSTOMER [BPC]

No

Customers

BPSUPPLIER [BPS]

No

Suppliers

TMPPAYDUD [TPD]

No

Temporary payment proposal

Transaction

There is no transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point is used when creating the selection filters for open item statements, before the payment creation transaction.

Available variables and masks

The variable that is used to enter the additional criteria is the [L]CRITSPE_SOI variable, length 255. It is reinitialized before the entry point is called.

The mask used for the criteria entry is PAYPROPAL, with the abbreviation DIA.

Variable or mask

Definition

PAYPROPAL [DIA]

 Criteria entry mask

Variable Char CRITSPE_SOI (255)

 Entry of additional criteria

VERROU: Locking of the automatic payment proposal function.

This entry point is used to modify the standard lock on the payment automatic proposal.

Context and operating mode

The following tables are on line :

Table

Significant content

Table description

GRPSAC [GSC]

No

Control groups

GRPCUR [GCU]

No

Currency groups

BID [BID]

No

Bank ID statement

COMPANY [CPY]

No

Company

GACCOUNT [GAC]

No

Accounts

TABDEPAGIO [TDA]

No

Early discount/late charge table

SOI [SOI]

No

Statement creation

BANK [BAN]

No

Bank accounts

POOL [POO]

No

Banking pool

GACCDUDATE [DUD]

No

Open items

TABCOUAFF [TCA]

No

Sequence No assignments

GACCDENCOD [CDA]

No

Payment attribute

TABPAYTYP [TPY]

No

Payment transactions

PAYMENTH [PYH]

No

Payment header

PAYMENTD [PYD]

No

Payment lines

PAYMENTA [PYA]

No

Analytical payment lines

GACCENTRY [HAE]

No

Accounting entries

GACCENTRYD [DAE]

No

Accounting entry lines

BPARTNER [BPR]

No

Business partner

BPCUSTOMER [BPC]

No

Customers

BPSUPPLIER [BPS]

No

Suppliers

TMPPAYDUD [TPD]

No

Temporary payment proposal

Transaction

There is no transaction in progress.

Log file

There is an open log file.

Different call cases

In standard mode, launching the payment automatic proposal on two different workstations is possible as long as the program is launched for two different companies or two different sites of a same company. Grids of locked symbols are used to properly lock the function. 

This entry point is called just after the constitution of locked symbol grids. It is used to change the locks if the user wants to refine the management of locks for launching the program on two different workstations, for the same company and with an additional criteria (control account code, payment transaction...).  

NB: Before setting new locks in specific, the locks set in standard must be unlocked.

Available variables and masks

Symbols locked in standard are contained in the TSYMBOLE variable grid. The number of locked symbols is contained in the NBLOCK variable.

The mask used for the criteria entry is PAYPROPAL, with the abbreviation DIA.

Variable or mask

Definition

PAYPROPAL [DIA]

 Criteria entry mask

 

UPDAMTRTZ: Update of the retention amount

Use this entry point to take over to reroute the update of retention amounts in the TMPPAYDUD table used as a temporary table when creating payments in the payment automatic proposal.

Context and operating mode

The following tables are on line :

Table

Significant content

Table description

GRPSAC [GSC]

No

Control groups

GRPCUR [GCU]

No

Currency groups

BID [BID]

No

Bank ID statement

COMPANY [CPY]

No

Company

GACCOUNT [GAC]

No

Accounts

TABDEPAGIO [TDA]

No

Early discount/late charge table

SOI [SOI]

No

Statement creation

BANK [BAN]

No

Bank accounts

POOL [POO]

No

Banking pool

GACCDUDATE [DUD]

No

Open items

TABCOUAFF [TCA]

No

Sequence No assignments

GACCDENCOD [CDA]

No

Payment attribute

TABPAYTYP [TPY]

No

Payment transactions

PAYMENTH [PYH]

No

Payment header

PAYMENTD [PYD]

No

Payment lines

PAYMENTA [PYA]

No

Analytical payment lines

GACCENTRY [HAE]

No

Accounting entries

GACCENTRYD [DAE]

No

Accounting entry lines

BPARTNER [BPR]

No

Business partner

BPCUSTOMER [BPC]

No

Customers

BPSUPPLIER [BPS]

No

Suppliers

TMPPAYDUD [TPD]

No

Temporary payment proposal

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 update of information linked to the retentions and stored in the TMPPAYDUD temporary table. If the GPE variable is set to 1 in the specific processing, the standard update of information linked to retentions is not executed.

Available variables and masks

The mask used for the criteria entry is PAYPROPAL, with the abbreviation DIA.

Variable or mask

Definition

PAYPROPAL [DIA]

 Criteria entry mask

PAY_SORT: payment sort order

Use this entry point to change the standard sort order if you change local menu 871.