Payment entry transactions

Single code identifying the payment transaction.

Common title of the current record.

This access code is used to restrict access to data by user or group of users.
If this field is entered, only users with this access code in their profile can use this transaction.
If several transactions are available, you can choose the transaction you want to use to open the function. If only one transaction is available, there is no selection to be made: the default entry screen opens directly.

Select the payment sign.

If you select Expense or Revenue, this field does not display in the payment header screen in payment entry. In this case, the user knows that the payment transaction is always an expense (issued cheque for example) or always a receipt (cheque receipt for example).

If you select Unspecified, you make the selection in the payment header as Expense or Revenue. This makes it possible to create only one payment transaction used for both receipt and expenses as in cash entry for example.

Requiring payment authorization only applies to expenses or unspecified types and when the Remittances and Bank file check boxes are selected. Use the PAYAPP - Payment authorization parameter to grant users the ability to approve payments.

Select Bank for a Bank register and Cash for a Cash register.

You can then select the appropriate Sign: Revenue or Expense.

Defines the payment attribute submitted by default upon entry of a payment for this transaction.
This payment attribute is usually set up with "Payment sense" for the accounting sense.

The Inter-banking code is a coding used by all banks to indicate the bank operation type on the lines of the bank statements that are sent to their customers.
In X3, this code refers to miscellaneous table 306.
The accounting journals also have an inter-bank code. It is use to facilitate (sort, selection) and to control the bank reconciliation (RAPBAN function) between the postings in a bank account with the lines in the bank statements.
The code entered here can be transmitted to the posting documents for the payments via the automatic payment journals.

Specify here the exchange rate type to be used to perform the currency conversions which are being entered or whose payments are being posted.

If this check box is selected for an invoice in a currency different from the company currency, the exchange rate applied between the open item currency for the closing of the BP account (closed during the first posting step) is the same as the rate on the invoice. There is no exchange rate variance journal reported in the company currency. 

If this check box is not selected, the exchange rate applied between the open item currency and the company currency for the closing of the BP account is the exchange rate on the posting date. For an exchange rate variance, an exchange rate variance journal in company currency is generated. 

Note: This check box is also relevant for the reporting currency for which an exchange rate variance journal in the reporting currency can be generated, or not, depending on whether it is selected or not.

This exchange rate is applicable to the Bank or BP payment type attributes and uniquely for the cases where one (or more) invoice is posted. For other payment attributes or non-posted Bank or BP payment attributes, the retained exchange rate is fixed with respect to the exchange rate type previously specified.

At the same time as the application of this original invoice exchange rate, several rates can co-exist. In this case, the accounting journal displays a blank exchange rate and suggests an exchange rate as an inlay on the screen.

If this flag is checked:

• the grouping code is forced to "payment" or "due date" according to the posting stages.
• the automatic propositions generated are grouped by due date item (a open item per payment or a due date by payment).
• the accounting date retained for the bank posting entry of the payment is equal to the payment due date when this is entered upon receipt. When using a remittance advice note, it is possible to confirm the choice made at cash receipt or otherwise to modify this in order that it is a receipt with discount ; in this latter case, the accounting date can be entered.

This flag is displayed only when the KSP activity code is activated.
It indicates that all payments made by this transaction have to be considered as Cash Payment.

This field requires the KSW – Swiss localization activity code to be active.

Use this field to select the generated file type:

Normal: No specific file type. Use this setting if no payment file will be created.

EZAG: Payment files are created in the EZAG format (specific format of the Swiss Postfinance).

DAT: Payment files are created in the DTA format (specific format of the Swiss banks/Swiss interbank clearing SIC).

ISO: Payment files are created in the ISO 20022 format.

Refer to the Swiss legislation guide on the How to tab for more details regarding payment and ISR setup.

This grid is used to specify the payment modes that will be considered for the automatic payment proposal (refer to documentation on the Automatic payment proposal).
In effect, only the open items with a payment mode corresponding to one of those that have been entered will be likely to be paid automatically.

No help linked to this field.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This field is displayed automatically on payment entry. It corresponds to the company which is linked to the site specified in the payment header.

It is possible to enter an internal reference for the payment document.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

The user can enter a description for information. This description will be taken by default in the line texts at payment entry (if the "line text" field has been selected).

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This field is linked to Miscellaneous Table 3.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

Click this check box if the Bank ID number field is to be displayed in the payment entry transaction.

 This field is mandatory if this payment type is used with electronic payments. You must click both this check box and the associated Mandatory check box. Electronic transmission payments have either the check box Bank file or SEPA generation in the Steps tab selected.

The Bank ID number is typically initialized from the payment address code. If the payment entry transaction is for a direct debit however, the Bank ID number is obtained by default from the mandate entered in the header payment (see the How to...manage SEPA mandates in AR processes in Sage X3 document in the 'How to', 'Financials' area of the Sage X3 Online help center).

This checkbox is used to make the corresponding field mandatory upon payment entry
.

Field to specify the bank name. The paying bank is initialized from the payment address code.
If the VII (international bank transfer) activity code is active, activating these fields is also used to make accessible other paying bank references for the intermediate banks.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

Select this check box to directly enter a currency rate at payment entry. This action overrides the default payment currency in the Currency rates table.

This check box is disabled if the Invoice rate application check box on the General tab is selected.

If you select this check box, the Invoice rate application field on the General tab is disabled.

Select this check box to make entering a currency rate at payment entry mandatory.

Defines or not the presence of the "bank amount" field. This field
features the payment amount expressed in the bank account currency.
If this field is not present, the amount will be calculated automatically.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

This checkbox is used to make the corresponding field mandatory upon payment entry
.

Specifies the number of columns that will be frozen on the left
when scrolling the posting entry grid.

Condition the management of the entry lots (Entry lot tab and header fields) in the payment entry.

If parameter PROBALCTL - Progressive balance control (chapter TRS - group PAY) is set to ‘Yes’, the balance control field is displayed. It is enabled if box "Entry batch" is activated.
It is used to define the balance control for the Entry batch. Additional fields in tab "Entry batch” tab are added for the balance control of the batch.
The activation of the balance control has an impact on:

• "Bank or Cash": Bank must be activated in tab "General".
• "Sign" must be "Unspecified" in tab "General".
• Field "Bank" must be "Mandatory" in tab "Input".
• Step "Bank Posting" must be activated. No other steps should be selected in tab "Steps".
  

This field is available if Bank or Cash is selected for the Bank or Cash field on the General tab for a Polish or South African legislation.

For Bank: Select N/A or Bank register. If you select N/A, the payment can only be created through Payment/Receipt entry (GESPAY). To create payment from the Bank register (GESBCREG), select Bank register.

For Cash: Select N/A or Cash register. If you select N/A, the payment can only be created through Payment/Receipt entry (GESPAY). To create payment from the Cash register (GESBCREG), select Bank register.

Bank or Cash register entry types are not available in Payment/Receipt entry (GESPAY).

This grid is comprised of optional fields that may have been added
upon installation. It is used to activate or not these fields in the
payment entry screen
.

This checkbox is used to make mandatory the corresponding field upon payment entry

This checkbox is used to make the corresponding field mandatory upon payment entry
.

Specifies if the payment mode must be taken into account by the
automatic payment proposal function
.

Enter the report code to identify which payment types to include. This code is used for the printing reports relating to checks, drafts, and remittances.

For bank or cash register entry types, use the following codes:

PLKP for cash in

PLKW for cash out

Specifies if the print associated with the code above is a
compulsory step before payment or
note validation.

Specifies if an automatic bank assignment phase is
possible for this type of payment. In the event of this phase not being retained,
the bank will have to be entered manually for each payment.

Specifies whether an approval stage is necessary before the first
payment validation. This approval consists in manually assigning a flag
specifying that the validation is possible.

Select this check box if authorization is required for payments.

Specify if the remittance must be subjected to an intermediate posting before being posted to the bank (for instance, for posting notes payable/receivable on collection or discount).

Specify if notes payable/receivable posting phase is required for this payment transaction. The notes payable/receivable posting consists in individually validating payments on an account different from the bank account.

Use this field to indicate if the payment type is linked to a Notes P/R field on the BP record.

The Notes P/R fields (1, 2, etc.) correspond to a group or "portfolio" of customer notes payable/receivable that are not due.

These notes can then be subject to a risk closing phase in a dedicated function.

Select this check box if payments need to be regrouped onto deposit notes before bank posting.

When payment authorization is required, this check box must be selected.

Specify if payments must be grouped as paying bank notes before bank posting (issued notes payable/receivable).

Select this check box if an electronic transmission of the deposit slip is possible with the bank (transfers, LOC, etc.).

For paying banks, select this check box to trace imported and exported files in payments and paying bank notes monitoring.

When payment authorization is required, this check box must be selected.

For France is it the ETEBAC file. Specify the name of the file to be generated, if the transaction only generates this type of file. Otherwise leave the field blank for the file to be selected at the electronic deposit stage.

This box -when checked- is used to generate bank files with the SEPA format for the current payment entry transaction.
Generating such a file is only possible if the option is activated.
 The SEPA term means SEPA Credit Transfer only.
 This checkbox can be accessed if the box ‘Bank file’ has not been activated.

This field is used to select the 'pivot' text file from Sage X3 sent to Sage Connect for conversion into .xml.

The nature of the payment identifies the bank file formats that can be generated by the payment transaction. According to the bank establishment or the national/international character of the payment, the file format is different. The nature of the payment is used to associate a payment transaction, a group of possible of bank files.

This field is mandatory if the transaction generates a bank file.

Select this check box as a criteria to split bank files from one remittance group by payment method.

File splitting depends on the bank file format and must be evaluated for each type.

This is option is not available when EDI files are created.

Select this check box as a criteria to split bank files from one remittance group by currency.

File splitting depends on the bank file format and must be evaluated for each type. For example, splitting by currency can be applied if a specific format supports multi-currency in general but requires separate files per currency.

Select this check box as a criteria to split bank files from one remittance group by due date.

File splitting depends on the bank file format and must be evaluated for each type.

Used to mention the generating fact for taking into account the payments of a transaction in the payment export file, towards the cash management software (see documentation Payment export to Sage cash management).
The possible values are (local menu 2673):

• None: the payments posted to the transaction are in no way taken into account in the export.
• Draft management posting/Intermediate posting/Bank posting: payments are taken into account for the export whenever the posting phase that has been completed corresponds to the generating fact.
  In case of accounting cancellation, the cancellation is also transmitted from the moment that it took place after the generating fact.

This field points to the miscellaneous table 325 and it represents a grouping/splitting criterion for the payments upon generation of the payment export file(s).
For instance, from the moment that two transactions have the same grouping file code, the payments taken into consideration by the export will be regrouped in a same file whose code will contain the grouping code as the first component of its name.

Code of the field of the payment export file whose content can be set up.
This code corresponds to that identifying the field in the cash management software:

• local menu 2671, for the interface to the Sage Concept Cash Management software,
• local menu 2674, for the interface to the Sage 1000 Cash Management software,
• local menu 2686, for the interface to the Sage FRP Treasury software.

 This code MUST be entered in uppercase letters.

The parameterization formula can be entered with the help of the formula assistant.

By default, the various accessible tables are proposed: 

• payment tables (PAYMENTH, PAYMENTD),
• the payment transaction table (TABPAYTYP),
• the payment slip table (PAYFRM),
• annex tables (TABCUR, BANK, BPARTNER)

As well as the main screens:

• the journal entry screens (GACCENT0, GACCENT1, GACCENT2)
• and the analytical distribution screens (VENTILE and VENTILE2)