FILTER: Additional filter on the payments

Use this entry point to add an extra filter to the payments selected during the various steps of payment posting.

Context and operating mode

In the context of the entry point :

  • There is no current transaction
  • A trace file is open

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 payment selection filter, before the payment posting step.

Available variables and masks

The variable available in this entry point is the CRITSPE variable with a length of 250. It is reinitialized before the entry point is called. 

According to the posting stage in process, the following masks are on line in the processing:

Variable or mask

Definition

 Mask PAYMEP [DIA]

 Bank receipt posting

 Mask PAYREMCPT [DIA]

 Intermediate deposit transfer

 Mask PAYREMBAN [DIA]

 Bank posting

 Variable char CRITSPE(250)

 Entry of additional criteria
 Open tables

Table

Significant content

Table Title

 TABPAYTYP [TPY]

 

 Payment transaction

 PAYMENTH [PYH]

 

 Payment header

 BANK [BAN]

 

 Bank account

MAJPYH: Additions to the payment header after posting

This entry point is used to carry out additional processings on the payment header, for each payment posted by the processing.

Context and operating mode

In the context of the entry point :

  • There is no current transaction
  • A trace file is open

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point intervenes after the generation of the accounting entries, before the update of the status and the status flags in the [F:PYH] class that precedes the rewrite of the payment header in the table.

Available variables and masks

According to the posting stage in process, the PAYMEP, PAYREMCPT or PAYREMBAN mask is on line in the processing, as well as the PAY3, GACCENT0, GACCENT1, GACCENT2, VENTILE and VENTILE2 masks, containing respectively the detail of the payment (PAY3), the generated document (GACCENT0, GACCENT1, GACCENT2) and its analytical breakdown (VENTILE, VENTILE2).

Variable or mask

Definition

 Mask PAYMEP [DIA]

 Cash criteria

 Mask PAYREMCPT [DIA]

 Intermediate deposit transfer criteria

 Mask PAYREMBAN [DIA]

 Bank posting criteria

 Mask PAY3  [PAYL]

 Payment lines

 Mask GACCENT0 [HAE0]

 Accounting document header

 Mask GACCENT1 [HAE1]

 Accounting document header

 Mask GACCENT2 [HAE2]

 Accounting document lines

 Mask VENTILE [VTL]

 Analytical breakdowns

 Mask VENTILE2 [VT2]

 Analytical breakdowns
 Open tables

The classes of the Payment [PYH] and Automatic journals [GAD] files are on line in this entry point.

From the intermediate posting, the class of the paying bank slip or notice file [FRM] is available.

Table

Significant content

Table Title

 ATABDIV [ADI]

 

 Miscellaneous tables

 GRPCUR [GCU]

 

 Currency groups

 TABCUR [TCU]

 

 Currencies

 TABPAYTYP [TPY]

 

 Payment transaction

 PAYMENTH [PYH]

 

 Payment header

 PAYMENTH [PYH2]

 

 Payment header

 PAYMENTH [PYH3]

 

 Payment header

 PAYMENTD [PYD]

 

 Payment detail

 PAYMENTA [PYA]

 

 Payment analysis

 PAYFRM [FRM]

 

 Paying bank slip or notice

 BANK [BAN]

 

 Bank account

 PAYACCNUM [PAN]

 

 Payment account postings

 PAYACCNUM [PAN2]

 

 Payment account postings

 TABCHANGE [TCH]

 

 Currency rate

 ADOVAL [ADO]

 

 Parameter values

 MTCBATCH [MTB]

 

 Batch matching

 COMPANY [CPY]

 

 Companies

 FACILITY [FCY]

 

 Sites

 GACCDENCOD [CDA]

 

 Payment

 BPARTNER [BPR]

 

 BP

 TABVAT [TVT]

 

 Taxes

 GACCCODE [CAC]

 

 Accounting codes

 GAUTACE [GAU]

 

 Automatic journals

 GAUTACED [GAD]

 

 Automatic journals (lines)

 GAUTACEF [GAG]

 

 Automatic journals (formulas)

 GTYPACCENT [GTE]

 

 Entry type

 GACCOUNT [GAC]

 

 Accounts

 PERIOD [PER]

 

 Periods

 CACNA [CNA]

 

 Analytical natures

 GJOURNAL [JOU]

 

 Accounting journals

 GACCDUDATE [DUD]

 

 Open items

 PAYORDER [PYO]

 

 Prepayments

 BPSUPPMVT [MVS]

 

 Supplier transactions

 BPCUSTMVT [MVC]

 

 Customer transactions

 ACCESS [ACC]

 

 Access by user

 GACCTMP [HAE]

 

 Accounting documents on hold (header)

 GACCTMPD [DAE]

 

 Accounting documents on hold (lines)

 GACCTMPA [DAA]

 

 Accounting documents on hold (analytical)

 GACCENTRYD [DAE2]

 

 Accounting documents (lines)

UPDMVT: Update of BP transactions

This entry point is used to perform or not the update of the amounts in the customer/supplier transactions table when posting a payment.

Context and operating mode

In the context of the entry point :

  • There is no current transaction
  • A trace file is open

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Different call cases

If documents are entered for the same BP, this entry point is used to avoid the deadlocks that can occur on the customer and supplier transaction table records (BPCUSTMVT/BPSUPPMVT) during the payment postings. This entry point is called before the transaction update, in the action after "APLIGBAN" line creation which is set in the PRINC, BKACC, EFFPO, PYDVN, PYODH and STEPN automatic journals.

If the OKUPDMVT variable is set to 0, the update is not performed.

Available variables and masks

According to the posting stage in process, the PAYMEP, PAYREMCPT or PAYREMBAN mask is on line in the processing, as well as the PAY3, GACCENT0, GACCENT1, GACCENT2, VENTILE and VENTILE2 masks, containing respectively the detail of the payment (PAY3), the generated document (GACCENT0, GACCENT1, GACCENT2) and its analytical breakdown (VENTILE, VENTILE2).

Variable or mask

Definition

 Mask PAYMEP [DIA]

 Cash criteria

 Mask PAYREMCPT [DIA]

 Intermediate deposit transfer criteria

 Mask PAYREMBAN [DIA]

 Criteria for the remittance to bank

 Mask PAY3  [PAYL]

 Payment lines

 Mask GACCENT0 [HAE0]

 Accounting document header

 Mask GACCENT1 [HAE1]

 Accounting document header

 Mask GACCENT2 [HAE2]

 Accounting document lines

 Mask VENTILE [VTL]

 Analytical breakdowns

 Mask VENTILE2 [VT2]

 Analytical breakdowns
 Open tables

The tables of the Payments [TB0] and Automatic journals [GAD] [GAU] files are on line in this entry point, as well as the BP table [BPR] which contains the BP being posted and the payment entry transaction table [TPY].

From the intermediate posting, the class of the paying bank slip or notice file [FRM] is available.

Table

Significant content

Table Title

PAYMENTH [TB0]

 Yes

 Payment header

 TABPAYTYP [TPY]

 Yes

 Payment transaction

 PAYMENTD [TB1]

 Yes

 Payment detail

 PAYMENTA [TB2]

 Yes

 Payment analysis

 BPARTNER [BPR]

 Yes

 BP

 GAUTACE [GAU]

 Yes

 Automatic journals

 GAUTACED [GAD]

 Yes

 Automatic journals (lines)

CRITUPDPAN: Selection criteria in PAYACCNUM

Use this entry point to manage bank posting with STEPN automatic journal modified compared with the standard to generate on the treasury account as many lines as there are payments on the slip. The automatic journal detail criterion contains the check number of the payment.

Context and operating mode

In the context of the entry point :

  • There is no current transaction
  • A trace file is open

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point is called in the AP_PIECE action, upon generation of the payment automatic journal. It is called before the update of the PAYACCNUM table, linking the payments and accounting entries. It is used to refine the treasury account entry number search when the document contains this treasury account several times. 

Available variables and masks

The CRITSPE1 and CRITSPE2 variables are used to select in the bank posting document the line of the treasury account corresponding to the payment.
CRITSPE1 contains the condition that differentiates the line of the treasury account from the one from the
payment. CRITSPE2 is not empty and contains the selection condition for the treasury account line.
Use example of the entry point when the detail criteria entered in line 10 of the STEPN automatic journal is the check number.
CRITSPE1 = ([M:HAEW]FCYLIN(W-1)<>[F:PYH3]FCY | (GLIGTRES2="STEPN/10" & [M:HAEW]DES(W-1)<>[F:PYH3]CHQNUM) )
CRITSPE2 -= ' & (GLIGTRES2<>"STEPN/10" | [M:HAEW]DES(W+W_STR-1)=[F:PYH3]CHQNUM)'

Variable or mask

Definition

 Mask GACCENTW  [HAEW]

 Payment lines

 Mask GACCENT0 [HAE0]

 Accounting document header

 Mask GACCENT1 [HAE1]

 Accounting document header

 Mask GACCENT2 [HAE2]

 Accounting document lines

 Mask VENTILE [VTL]

 Analytical breakdowns

 Mask VENTILE2 [VT2]

 Analytical breakdowns
 Open tables

Table

Significant content

Table Title

PAYMENTH [PYH3]

 Yes

 Payment header

 GAUTACE [GAU]

 Yes

 Automatic journals

 GAUTACED [GAD]

 Yes

 Automatic journals (lines)

BEFGNRVCR: Before the generation of a payment automatic journal

Use this entry point to take over just before the generation of a payment automatic journal.

Context and operating mode

In the context of the entry point :

  • There is no current transaction
  • A trace file is open

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Different call cases

This entry point intervenes in the read of the automatic journals linked to the automatic journal group used for the payment validation and is located just before the call to the sub-program used to generate the payment automatic journal.

Available variables and masks

According to the posting stage in process, the PAYMEP, PAYREMCPT or PAYREMBAN mask is on line in the processing.

Variable or mask

Definition

 Mask PAYMEP [DIA]

 Cash criteria

 Mask PAYREMCPT [DIA]

 Intermediate deposit transfer criteria

 Mask PAYREMBAN [DIA]

 Criteria for the remittance to bank
 
Open tables

The tables of the Automatic journal groups [GRA] and Automatic journals [GAU] are on line in this entry point.

FLTUSR: Specific filter on user instead of standard

Use this entry point to replace the standard filter on a user for payments selection.

Context and operating mode

In the context of the entry point :

  • There is no current transaction
  • A trace file is open

 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 payment selection filter, before the payment posting step. It should be used to replace the standard filter on a user.

If the CRITSPE variable is returned with a value other than empty, the value of CRITSPE replaces the filter on a user for payment selection.

If the CRITSPE variable is returned with an empty value, the standard filter on a user is used for payment selection.

Available variables and masks

The variable available in this entry point is the CRITSPE variable with a length of 250. It is reinitialized before the entry point is called. 

According to the posting stage in process, the following masks are on line in the processing:

Variable or mask

Definition

 Mask PAYMEP [DIA]

 Bank receipt posting

 Mask PAYREMCPT [DIA]

 Intermediate deposit transfer

 Mask PAYREMBAN [DIA]

 Bank posting

 Variable char CRITSPE(250)

 Entry of additional criteria

 Open tables

Table

Significant content

Table Title

 TABPAYTYP [TPY]

 Payment transaction

 PAYMENTH [PYH]

 Payment header

 BANK [BAN]

 Bank account