PAYCPTA processing: PAYCPTA
FILTRE: 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
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 online 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 | 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
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 masks,
-
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), are online in the processing.
| 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 online in this entry point.
From the intermediate posting, the class of the paying bank slip or notice file [FRM] is available.
| Table | 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 Business Partner transactions
This entry point is used to perform, or not, the update of the amounts in the customer or supplier transactions table, when posting a payment.
Context and operating mode
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 Business Partner, 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 the 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 masks,
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) are online 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 |
|
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] and [GAU] files, are online in this entry point, as well as the Business Partner 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 |
Business Partner |
|
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 the STEPN automatic journal modified, compared to the standard one, 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
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
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 masks are online 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 online 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
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 online 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 | Table title |
|---|---|
|
TABPAYTYP [TPY] |
Payment transaction |
|
PAYMENTH [PYH] |
Payment header |
|
BANK [BAN] |
Bank account |
BEFTRANSAC: Before entry generation transaction
Context and operating method
Transaction
There is no transaction in progress.
Log file
There is no open log file.
Code context
This entry point allows the customer to add a last control before the generation of the accounting entries (in $GENER_PCE before Gosub TRANSAC).
The GOK variable is set to 1 before calling the entry point. If the GOK global variable is set to 0 in the dedicated processing, the generation procedure will not be run.
Available variables and masks
According to the posting stage in process, the PAYMEP, PAYREMCPT or PAYREMBAN masks are online 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 |
| Local Integer GCAS | Journal generation type local menu 657 |
| Local char CRIT(100), SAVCRIT(100) | Criteria |
| Global integer GOK |
GOK has to be assigned to 0 to return before executing the generation GOK = 1 = correct GOK < 1 = not correct |
| Local Char GRPPCE (GLONGRA) | Automatic journal group code |
| Local Char NUMDOC (GLONVCR) | Payment no |
| Local Char NUMREG (GLONVCR) | Payment no |
| Local Integer TYPCLE | Type of key: 1,2 or 3 |
| Local Integer TYPREG |
Discount form type: 1,2 or 3 local menu 685 |
| Local Integer VALGRP |
Grouped validation: 0 = no, 1 = yes : 1 Entry for X payments |
Open tables
| Table | Significant content | Table title |
|---|---|---|
| PAYMENTH [PYH2] | Yes, when TYPCLE = 1 or 2 | Payment header |
| PAYMENTH [PYH5] | Yes, when TYPCLE = 3 | Payment header |
| GRPAUTACE [GRA] | Yes | Automatic journal group |
| TABPAYTYP [TPY] | Yes | Payment transactions |