A/P-A/R accounting > Payments > Payment/Receipt entry 

Use this function to post invoice payments from the Purchasing, Sales, or A/P-A/R accounting modules. Or, you can post automatically using the Payment proposals function (PAYPROPAL).

In this function, you can:

  • Save a payment different from zero and link it to an invoice or order for the same company.
  • View all entered payments by payment transaction.
  • Generate a journal entry by payment entered, or view the grouping and posting stages that remain to be completed.
  • View all the payment journal entries already generated with respect to this payment.


For fixed assets invoices, adding a discount line automatically creates a capitalized expense.

If the PAYUNALL - Unalloc. payments considered parameter (TRS chapter, PAY group) is set to Yes, the Selection list displays unallocated payments under Open items and Grouped open items.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

The entry of a payment is made in one to four tabs according to the entry detail level set up at payment transaction level.

Some information to be entered varies according to the transaction. The common fields to be entered are defined below.

It is important to note that it is only possible to enter one payment at a time:

  • The payment can include several payment attributes (cash collection, payment differences, discounts, charges, etc.) and be allocated to several open items
  • Several payments can be grouped to be entered as a batch

Header

Fields

The following fields are present on this tab :

  • Payment no. (field NUM)

The payment number is the unique identifier for a payment. Upon creating a new payment, this number is automatically attributed thanks to the counter defined for payment transactions; this counter can be different for the revenue and the profit. By default, this counter is PY1.

  • Status (field STA2)

The payment status is generated automatically. It will take different values (defined in local menu 689), based on the level of progress of its processing.

Example: For a payment by check.

  • If the payment has been created but not processed, the Status field will have the value Entered.
  • If the check has been posted to the bank, the Status field will have the value In the Bank.

This ensures that the user can see the level of progress of the payment processing. For information, the various stages reached in the payment processing are the following:

Status

Description

1

Entered

2

Accepted

3

Posted notes payable/receivable

5

Slip entered

6

Slip on file

7

Paying Bank entered

8

On intermediate account

9

In the bank

10

Notes P/R risk closing

11

Unpaid

  • Entry batch (field PAYLOT)

 Specify the entry batch the payment is linked to:

  • By default, the payment is attached to the current batch (the value of the field is initialized with the current batch number).
  • Leave this field blank if the payment should not be attached to any entry batch.
  • To assign the payment to a new entry batch, enter "*" in this field. In this case, the payment entry batch sequence number needs to be defined.

Entry batches can be viewed in payment entry in the Entry batch section. Selecting a batch payment automatically updates the Payment section where you can view the selected payment.

You can define a range of entry batches in the functions related to payments: notes payable/receivable posting, bank posting, remittance generation, etc.

 
  • Description (field LOTDES)

 Specify the title of the entry batch.

  • Bank/Cash reg. no. (field REGNUM)

 

  • Approved (field PAYAPPFLG)

This field displays the payment approval status. If a payment has been approved and you make any changes, the status reverts to not approved.

Close

 

Tab General

Presentation

The BP account  balance is calculated based on the Journal entry (GESGAS). The  amount is calculated and displays when the following fields in the General section have been entered or modified: Site, BP, Account, Accounting date, and Currency.

Close

 

Fields

The following fields are present on this tab :

Block number 1

Specify the site to which the payment should be made or from which it should be issued. It is initialized by the site associated with the user code. it can be modified provided it is chosen from the list of authorized sites.
If the payment is assigned to an entry batch, the specified site must belong to the company of the entry batch.

When the payment is posted, entry of the cash account will be made on the site specified here.

The choice for payment posting is made:

  • On a BP: the control account code and the associated account are displayed by default.
  • On a control account: the account that is associated with it is displayed by default, the BP must be specified.
  • On a GL account.

 Specify the BP issuing or receiving the payment. When the payment should be posted to a general account (rent, electricity, etc.), this field should be left blank and the general account subsequently entered.

 

  • Control (field BPRSAC)

Specify the control account associated with the payment BP. By default, the submitted control account is: 

  • the "Purchase" control account of the accounting code of the suppliers, 
  • the "Sales" control account of the accounting code of the customers, 
  • the default control account of the accounting code of the miscellaneous BPs
    not forgetting that a BP being both a customer and a supplier is considered as customer for a transaction of revenue type and as supplier for a transaction of expenditure type.

The initialization of the code for the Control field depends on whether or not the BP/Company tab is present in the BP record (GESBPR).

 This field can only be entered if no BP or control account has been previously entered. It is used to specify the general account (rent, electricity, etc.) to post the payment to.

  • Address code (field BPAINV)

The mandatory field Address code  is used to specify a payment address code.

  • If the BP is specified, the field will be initialized from the address code that has been set up:
    • in the supplier or customer record if the BP is only supplier or customer,
    • if the BP is both customer and supplier: in the customer record if the transaction is of type 'revenue" and in the supplier record if the transaction is of 'expense' type.
  • If the BP is not mentioned, the field will be initialized using the address code set up in the "Address" tab of the account record when the payment is entered on a general account.

This address will be used to initialize field Bank ID number when it is present in a transaction.
If the payment transaction is of 'Unspecified' type, the address code is not initialized.

In the specific case of SDD, after selecting the Mandate reference, the address code associated with the selected mandate is displayed but cannot be modified.




  • field BPRNAM

 

Block number 2

Block number 3

Grid

Block number 5

  • Total allocated to BP (field TOTIMPUT)

Field updated in real time based on the open item selection.

  • Remaining for allocation (field RSTIMPUT)

When the header field "BP amount" is entered, this field is used to identify the progressive amount remaining to be posted to the invoices in real time.

  • Bank amount (field TOTBQE)

Amount passed to the bank account. The latter is determined on payment creation.

  • BP account balance (field SOLDE)

 

Close

 

Tab Allocations

Presentation

The information in this section is merged with the information in the General section. If the amount of information requested for the transaction being restricted, you can enter all needed information on a single page.

The BP account balance is calculated based on the Journal entry (GESGAS). The amount is calculated and displays when the following fields in the General section have been entered or modified: Site, BP, Account, Accounting date, and Currency.

If you modify one of these fields, the BP account balance is recalculated. Also, any changes to the BP journal account recalculates the amount in this field.

Note: The BP account balance displays before the payment is created.

 

Fields

The following fields are present on this tab :

Block number 1

This field is automatically displayed after entry of the operation site. It corresponds to the company containing the site.

  • Accounting date (field ACCDAT)

  • It corresponds to the payment entry date. It is initialized by the system date (current date) and it is modifiable. It is used as the accounting date at the time of the first payment posting.
    As a consequence, all validity checks with respect to the dates of the natures, dimensions, analytical allocations and amount conversions in various currencies on payment management are carried out using this date.
     
    This date corresponds to a period and a fiscal year open for the company mentioned in the payment.
     
  • If the payment transaction is managed by "due date", the accounting date for the deposit to the bank is forced to the payment due date.

The payment method corresponds to the method used to carry out the payment (check, credit card, exchange of goods, etc. The payment methods are defined in miscellaneous table no. 3).
If the payment transaction is set up as having several possible payment methods, it is possible in this field to select the payment method to use. The first payment method assigned to the transaction appears by default.

  • Sign (field SNS)

Specify if the payment is a revenue or an expense. It only appears if the sign is not indicated at payment transaction level.

  • Remittance reference (field FRMREF)

It is possible to enter an internal reference for the discount applied to the payment. 
This reference can be used as grouping criterion for the payments upon generation of the deposit slips.

  • Entry reference (field REF)

 An internal reference can be entered for the payment document.
This information is used to elaborate bank deduction and transfer files, and to select payments via the extension and doubtful receipt functions. It can also be used in the payment posting journals via the "Journal reference" formula of the automatic journals.

  • Payment reason (field EPARENPAY)

A payment reason code is used when generating bank files in SEPA Credit Transfer and SEPA Direct Debit formats.
It corresponds to the 'Remittance information' data from the ISO 20022 standard messages.
This field can be entered provided the payment entry is associated with a payment transaction accepting SEPA format. It can be used to enter a reason for each payment (maximum length = 140 characters).

  • Description (field DES)

 It is possible to enter a formula : This information is used by default as the titles of the payment lines and postponement lines (if the "line description" field has been selected at the time of setup of the payment transaction). It is also used upon setup of the bank files.

The entry transaction used will determine if cash operations apply to bank or cash funds. The entry transaction also defines if it is mandatory or optional.

  • When the information is mandatory, it is initialized based on the following order of priority: the customer or supplier bank/cash funds, the bank entered on the site, the value of the user parameter BANKDEF - Bank by default, for banks, and of the user parameter CAISDEF - Default cash (chapter TRS, group DEF) for cash funds.
  • When the entry is optional, you can allocate a bank to a payment later, using the bank entry or allocation functions.

Each bank or cash fund is linked to a general ledger account (see the Bank accounts documentation).

The cash account to be posted is determined with respect to this field: each bank includes a set of journals (bank, notes payable/receivable, intermediary posting, etc.), which is used to locate the cash account to be used according to the posting phase. Each cash fund includes a journal and an account used to generate the associated entry.

Specify the payment currency. By default, it is the business partner currency. A few cases to be highlighted:

  • The payment currency is different from the invoice currency (payment lines): other that the main posting (automatic journals PRINC or STEPN), an MO journal is generated via the PYODD automatic journal.
  • The payment currency is different from the bank currency (the bank currency is set up at cash general account level): other that the main posting (automatic journals PRINC or STEPN), an MO journal is generated via the automatic journal PYODD or PYDVN.
  • BP amount (field AMTCUR)

Specify the payment amount. This amount is expressed in the payment currency. The currency in which the amount is expressed is displayed beside the field.
It is important to enter this amount because the open items selected on the payment will then have a default amount equivalent to that of the open item, up to the amount entered in this field.

  • C/T val bank curr (field AMTBAN)

This field contains the effective amount of the payment expressed in the bank currency. This field is used to express a counter-value when the payment currency is different from the bank currency. If the counter-value entered is different from the counter-value found by the software, a warning message requests the confirmation of the entry and displays the counter-value found (based on the exchange rate type in force on the accounting date).

  • Currency rate (field CURRAT)

This field defaults to the currency rate listed in the Currency rates table.

If the Main ledger currency rate field is selected in Payment entry types, you can enter a currency different from the one in the rate table and this value is used as the final rate when the payment is posted.

  • Check type (field CHQTYP)

Specify the check type (On-site, Off-site, Foreign, Euro) corresponding to the payment. This field is used as grouping criterion for the payments upon generation of the deposit slips for:

  • the transactions defined with entry of the check type and a print code associated with the CHR or CHE processing code.
  • the banks defined with "On/Off site deposit".
  • Check number (field CHQNUM)

The check number is used to provide payment traceability. It is taken as a reference in the journal entry generated by the payment processing (defined at payment journal setup level).
For expenses associated with the transactions defined with "Mandatory printing" and the print code associated with the CHE (issued checks) processing code, the check number must necessarily be entered before posting to the bank. This can be done by printing checks or check letters.

  • Pay-by branch (field CHQBAN)

 Specify the paying organization for the received checks. The information (check number and paying organization) is used during the printing of the checks.

  • Due date (field DUDDAT)

 Specify the due date of the payment. This is the date from which the amount is due.

If payment transaction is managed by "open item due date":

  • the item due date is initialized in different ways based on how the payment is entered (in this case, it is up to the user to control the value of this date that is by default initialized to the due date) or generated from the automatic payment proposal (the due date is then initialized to the date closest to the open items which make up the payments).
  • the accounting date for the deposit to the bank is forced to the payment due date. It is possible to enter a different posting date during the deposit note phase if the deposit is discounted.

In the specific case of SDD (SEPA Direct Debit):

  • The due date must be later than the mandate signature date.
  • The due date of a payment having a sequence of Recurring (RCUR) type must be later than the date of the payment associated with a sequence of First (FRST) type.
  • The due date of a payment having a sequence of Recurring (RCUR) type must be earlier than the date of the payment associated with a sequence of Last (FNAL) type.
  • Discount type (field FRMTYP)

Specify the remittance type (collection, discount) corresponding to the payment.

  • This field is only entered and used for transactions whose print code is not associated with CHE or CHR.
    For other transactions where the remittance type can be entered, this field is used as a grouping critera for payments when generating remittances. The remittance type can also be used as a selection crieria when remittances are subject to an intermediate posting or bank posting.
     
  • If the payment transaction is managed by open item due date, the notes payable/receivable posting is done by default on this date (remittance type on collection) and so, the bank posting date is also the open item due date. Exceptionally, on the remittance, you can also process some notes payable/receivable on discount. In this case, even if the transaction is managed by open item, you can enter an accounting date for the bank posting (the field is available).
 
  • Source date (field ORIDAT)

This is the payment creation date. By default, it is the current date.

  • Drawee reference (field BPRREF)

 Specify the reference of the drawee, that is, the debtor. This piece of information is useful to elaborate the LOC deposit files and to select a payment in the manual reconciliation function.

  • Bank date (field BANDAT)

The bank date resembles a management by value date but on the financial organization side. Legal date for all print-outs linked to a Bank. In certain countries the "accounting date" is different from the "bank date" that itself can be different from the "value date".

  • Value date (field VALDAT)

 Specify the value date of the payment. This is the date from which the payment amount deposited to the bank will be actually available from this bank, without additional costs. The value date is initialized by default to the due date.

This field is linked to miscellaneous table 313.
It is displayed only for payment entry transactions accepting SEPA format and qualifies the nature of the SEPA Credit Transfer and SEPA Direct Debit.

  • Date created (field BILDAT)

 Specify the creation date of the payment. By default, this is the current date. This piece of information is recalled in the file transmitted to the bank.

This field appears when the option "Bank card no." has been chosen when setting up the payment transactions. Specify the information relating to the payment by credit card:

  • Type of card: if this field is not entered, the others are not entered either.  The values of this field are defined in miscellaneous table no. 314.
  • Card number: a control algorithm is set up for VISA cards.
    The credit/bank card number provides payment traceability. It is taken as a reference in the accounting document generated by the payment processing (defined at payment journal setup level).
  • Validity end date: mentioned on the credit/bank card. Month on 2 numbers/Year on 2 numbers
  • Authorization number This is a code for internal use, non managed as standard by Sage X3.

The economic reason code is used by the Banque de France when determining the Balance of payments.
It is necessary for any operation that fits into the following contexts:

  • transactions in euro to a bank within the European Union, including France, for non-resident's accounts, starting from €50,000,
  • transaction in euro to a bank outside the European Union, starting from €12,500,
  • transactions in a currency -other than the euro- to a bank within the European Union, including France, starting from €12,500.

SEEINFO The resident or non-resident option is defined at theBP level.
The declaration limits are determined by the parameter values "Payment balance Threshold": AMTVIR1, AMTVIR2 and AMTVIR3 (chapter TRS - BP, group DEF - Default values).

The entry of this code and its mandatory entry are determined at the level of the payment entry transaction parameter.
If the company from which the payment is made has the status of general direct declaring site to the balance of payments, code 060 'General direct declaring site' will be proposed (Company record parameter).
Otherwise, the value suggested will be that defined at BP level (BP record parameter).
SEEINFO This code can be modified.
This value is retrieved in the bank files (AFB160, AFB320, SEPA Credit Transfer).

  • Purchase type (field PURTYP)

Indicate if the payment is linked to a purchase of goods and services or to fixed assets. The possible values of this field are defined in local menu 646. 

In this case, the VAT accounts with movements created on payment posting can vary. Using the payment transaction and automatic journals, you can also define various posting structures for the notes payable/receivable posting depending on the purchase type.

 

Specify the bank details of the BP or of the general account in the payment header:

  • Country code: provides the entry format and the control algorithm of the bank details subsequently entered. The Bank details button is used to display and/or modify the information on bank tansfers. This button depends on the VII activity code. 
  • Bank account number with key: selection of one of the BP bank account numbers. Part of the content of this field can be initialized and controlled. The bank account number can be initialized from the payment address code.
  • 2 lines of paying banks: These fields specifies the paying bank relating to the bank account number. This information is used to create the transfer, the deduction and the notes payable/receivable files to be transmitted to the banks.

Specific case for SDD: After selecting the Mandate reference, the country code associated with the bank account of the pay-by BP for the selected mandate is displayed but cannot be modified.

Paying Banks of the beneficiary (3 & 4) - Accessible by Actions icon

These fields are used to manage the intermediary banks within the framework of commercial exchanges with non-western countries. They are accessible from the Bank account no. field.

Intermediary Paying Banks (1, 2, 3 & 4) - Accessible by Actions icon

These fields are used to manage the intermediary banks within the framework of commercial exchanges with non-western countries. They are accessible from the Bank account no. field.

 
  • IPI code (field SWIIPI)

This field is related to the activity code KSW – Switzerland.
This is an extra field which can be activated in the Payment entry type definition. It allows to enter the IPI code (International Payment Instruction) for a payment, if IPI transactions are used.

  • Instruction key EZAG (field SWISUP1)

This field is related to the activity code KSW – Switzerland.
This is an extra field which can be activated in the Payment entry type definition. It can be used when PostFinance bank files (EZAG/OPAE format) are generated. It allows to enter additional paying instructions like Personally or Urgent.
Possible usage also depends on the payment transaction type to be generated in the bank file as not all PostFinance payment transaction types support additional instructions.

  • Instruction key DTA (field SWISUP2)

This field is related to the activity code KSW – Switzerland.
This is an extra field which can be activated in the Payment entry type definition. It can be used when Swiss bank files (DTA format) are generated. It allows to enter additional paying instructions like Salary.
Possible usage also depends on the payment transaction type to be generated in the bank file as not all Swiss bank payment transaction types support additional instructions.

  • Bank charge bearer (field SWISUP3)

This field is related to the activity code KSW – Switzerland.
This is an extra field which can be activated in the Payment entry type definition. It can be used when Swiss bank or PostFinance files are generated. It allows to enter additional bank charge instructions like Shared, Beneficiary or Applicant.
Possible usage also depends on the payment transaction type to be generated in the bank file as not all payment transaction types support bank charge instructions.

  • Bank statement (field BSITRS)

 

Block number 3

Block number 2

Block number 4

 

Tab Entry batch

Presentation

The information in this section is merged with information in the General section. If the amount of information requested for the transaction is restricted, you can enter all needed information on a single page.

Close

 

Fields

The following fields are present on this tab :

Grid

 Specify the payment attribute of the payment line. This piece of information specifies how the payment line will be subsequently posted (account structures to use).  The payment attribute defined at the time of the payment transaction setup is the one displayed by default.

Example: a payment attribute of Cash receipt type impacts a bank account and a BP account.

  • Type (field VCRTYP)

Specify the open item to be allocated to the payment line by specifying its type and journal number. This information can be entered only if the payment attribute entered is "chargeable" ("matchable").
It enables payment posting to perform for example the matching between payment and paid invoice.
The document type and the document can be directly selected using one of the two left lists: "Open items" or "Grouped open items" The selected open item must:

  • come from the payment company
  • come from the payment site, if inter-site MOs are prohibited
  • come from the control account and payment BP, if inter-BP MOs are prohibited
  • be validated if it is associated with a purchase or sale invoice
  • not be factored
  • be approved for payment for creditor open items 
  • not be associated with a BP blocked for payment, for expenses.

The document type given by default comes from the payment attribute. The document number corresponds either to the invoice number of to an open item on the invoice (case of a multi open item invoice). It can also be an order journal type (see general parameters BPSORDTYP - Supplier order doc type and BPCORDTYP - Customer order doc type) and in that case it will be necessary to enter the order number. No matching is triggered when a payment is reconciled to an order.

In the specific case of SDD: the open items to be allocated must have the same mandate reference as the one selected in the header.

  • Entry (field VCRNUM)

Specify the open item to be allocated to the payment line by specifying its type and journal number. This information can be entered only if the payment attribute entered is "chargeable" ("matchable").
It enables payment posting to perform for example the matching between payment and paid invoice.
The document type and the document can be directly selected using one of the two left lists: "Open items" or "Grouped open items" The selected open item must:

  • come from the payment company
  • come from the payment site, if inter-site MOs are prohibited
  • come from the control account and payment BP, if inter-BP MOs are prohibited
  • be validated if it is associated with a purchase or sale invoice
  • not be factored
  • be approved for payment for creditor open items 
  • not be associated with a BP blocked for payment, for expenses.

The document type given by default comes from the payment attribute. The document number corresponds either to the invoice number of to an open item on the invoice (case of a multi open item invoice). It can also be an order journal type (see general parameters BPSORDTYP - Supplier order doc type and BPCORDTYP - Customer order doc type) and in that case it will be necessary to enter the order number. No matching is triggered when a payment is reconciled to an order.

In the specific case of SDD: the open items to be allocated must have the same mandate reference as the one selected in the header.

 Specify the site of the payment line. The site must belong to the payment company.
When the payment is posted, posting of the payment line for the counterpart of the cash account (BP account, charge account, VAT account) will be made on the site specified here.

The site proposed by default is the site of the allocated open item or the payment header site.

It is possible to modify the site on the line and also to carry out the inter-site operations for the same legal company. The link postings are automatically generated for the link accounts previously set up. No specific automatic journal is necessary.

Specify the currency in which the paid amount corresponding to the payment line will be entered.

  • If the payment line refers to a document/invoice: it is the invoice currency. By default, the submitted currency is:
      • the currency of the allocated open item.
      • the bank or company currency for the Bank<=>Account payment attributes 
      • otherwise the payment header currency.
         
  • If the payment line does not refer to a document/invoice: it is the currency of the entry header, that is, that of the "Amount in currency". In this case the currency can be modified. Where-used:
      • Bank account kept in EUR.
      • Payment in £ for an invoice in £.
      • Bank charges in EUR.
         
  • If the transaction specifies that the exchange rate for the payment is the "invoice exchange rate" and that several invoices having different rates are selected within the same payment, the journal entry will specify the theoretical exchange rate on the payment date, and will leave empty the field for the actual exchange rate used.

In the specific case of SEPA, only the EURO is authorized and field Currency cannot be modified.

  • Withholdings (field RITAMT)

This field concerns the Italian legislation: KIT activity code and ITARTZ - Italian deduction at source parameter (chapter LOC, group ITA).

This column is never entered and according to the Retention code setup, it can be empty. It indicates in negative and in retained currency the amount retained on the payment posted to the Cash/Status account(s) for the invoice indicated in the line. The BP amount is deducted from the retention calculated and the amount entered.

  • For example: Invoice FAC001 for 1055 EUR 10% retention on the payment.

 

Account

BP

Debit

Credit

466 (Supplier coll acc)

AUTHOR01

 

1055

4456 (VAT 5,5%)

 

55

 

651 (rights)

 

1000

 

Payment entry:

Pay. att.

Type

Invoice

Site

Currency

Deduction

Amount

Amt inc T

ENC

INV

INV001

001

EUR

-100

1055

955

Payment document:

Account

BP

Debit

Credit

466 (Supplier coll acc)

AUTHOR01

1055

 

437 (Coll. org.)

 

 

100

512 (Bank)

 

 

955

  • Amount (field AMTLIN)

Specify the paid amount corresponding to the payment line, expressed in the invoice currency.
If the BP amount field has been entered, the selected open item loads this field by default with the global amount of the open item up to the limit of what has been entered in the payment header.

  • Allocated to BP (field AMTLIN2)

Specify the paid amount corresponding to the payment line, expressed in the payment currency.

Only payment attributes of the Bank <=> BP type can affect the Amount posted column, expressed in payment currency.
To be able to save the entry of a payment, the sum of the posted amounts of the payment must be equal to the amount of the payment specified in the BP amount field in the header information.
If it is not the case, the Unbalanced payment window is automatically displayed. This window displays the header amount, the amount of lines and the variance amount.
You can choose the terms for correcting this variance:

  • BP amount adjustment: this choice applies when errors of entry are recorded on the header amount. This amount is automatically modified in order to include this variance.
  • Rounding variance: this choice applies to cases where the sum of the line converted amounts is different from the BP amount. Two additional 'technical' posting lines are automatically added to the payment corresponding to the generation of two rounding variance entry lines:
      • One line is created on a payment attribute of the Bank <=> BP type so as to get the required correspondence between the entered BP amount and the sum of the converted amounts related to posted invoices. This attribute is characterized by the value of the PAYRNDCDA1 - Bank - BP rounding variance parameter (TRS chapter, PAY group).
      • One line is created on an Account <=> BP payment attribute in order to balance the BP account and record the variance in the revenue or expense account. This attribute is characterized by the value of the PAYRNDCDA2 - Account - BP rounding variance parameter (TRS chapter, PAY group).
  • Manual correction: this choice is used to go back to the screen modification mode in order to be able to modify the amount yourself.
  • Discount date (field DISDAT)

 

Specify the tax code to be used to post the payment line. The tax code defines the rate, the rules and the terms for the tax deduction applicable to the operation. 
 This code is only entered if:

  • The payment attribute of the line makes use of an account subject to VAT,
  • for Bank<=>BP payment attributes, the pre-payment account or the payment header account is defined with VAT management,
  • for the other payment attributes (Account<=>BP and Bank<=>Account), the payment line account, either coming from the accounting code of the payment attribute, or previously entered, is defined with VAT management.

The tax code proposed by default is that of the open item allocated to the payment line, or that of the account determined as specified above.

  • Description (field DESLIN)

 Specify the title of the payment line. This title is initialized with the payment header description, if it has been entered.

During the setting up of an analytical nature, non-financial unit entry is confirmed or not. As required, a unit is allocated to it, by specifying its default value (in reporting currency). It is this unit that will appear during document entry. The quantity is automatically calculated by dividing the Ex-tax amount (converted into reporting currency) by the non-financial unit value. The quantity can be modified.

  • Quantity (field QTYLIN)

During the setting up of an analytical account, non-financial unit entry is confirmed or not. As required, a unit is allocated to it, by specifying its default value (in reporting currency). It is this unit that will appear during document entry. The quantity is automatically calculated by dividing the Ex-tax amount (converted into reporting currency) by the non-financial unit value. The quantity can be modified.

  • Distribution (field DSP)

- If the accounting amount has been allocated over several analytical dimensions, specify the analytical allocation to post the payment line to. The methods of allocation must be compatible with the accounting date of the payment, the site and the analytical nature of the payment line.

These methods are defined as follows:

  • Entry of an analytical budget weighting code previously configured (see documentation on Prior allocation keys)
  • In amount. It is then possible to allocate the amount to as many sub-amounts as required.
  • In percentage. A calculation is performed based on the sum of the coefficients used for the allocation.

Example: on a basis of 100, a coefficient of 10 will be read as 10%. But, on a basis of 50, a coefficient of 10 will be equivalent to 20%.

For these two later cases, it is possible to pre-initialize the allocation with an already existing key. The final display will be " $ ". 

- If the accounting amount has not been allocated over several analytical dimensions, the "allocation" field does not need to be assigned. The entry is achieved directly in the following columns, in the dimension concerned, for each of the dimension types.

The initialization of the dimensions is carried out by means of the default dimension codes and more particularly the default dimension code PAYMENTD.

Specify the dimensions to which the payment line should be posted. Depending on the setups of chapter CPT and the analytical nature of the payment line, entry of this field can be mandatory, optional or prohibited.

The entered dimension mut be compatible with the site and the analytical nature of the payment line, and the payment date.
By default, the submitted dimension comes in priority from: 

  • the header of the invoice/order allocated to the payment line,
  • the PAYMENTD default dimension code,
  • the default dimension codes of the analytical nature of the payment line.

Close

 

Action icon

Account Inquiry

Select this option to zoom in to the customer, supplier, or BP account inquiry for the payment control account entered.

Invoice/Order

When an open item is allocated on a line, select this option to view the original invoice or order.

Statement

Select this option to view the scheduled invoice for the statements.

 

Close

 

Tab Batch Entry

Presentation

This section displays batch payments at the payment transaction level. Each payment creates a line within an entry batch. The grid summarizes the payments in the batch.  

  • When you select a payment in the batch, the corresponding checkbox in the first column of the grid in the General section is automatically updated to view the payment details.
  • The information related to the payment automatically displays.

The fields relating to the balance control are displayed if the control is active for the payment entry transaction used. This control is active if, for an entry batch, the balance control of the bank is set to Yes. If it is set to No, all fields display 0.
For a new entry batch, after entering a bank with balance control, you must enter the starting balance and ending balance for the bank statement.
An entry batch with balance control can only refer to a single bank account. All values are expressed in the bank currency.

Close

 

Fields

The following fields are present on this tab :

Grid

  • field LIGFLG

 

  • Number (field PAYNUM)

 

  • Date (field PAYDAT)

 

 

 

 

  • Ctrl. (field PAYBPRSAC)

 

 

 

  • Amount (field PAYAMTCUR)

 

  • Status (field PAYSTA)

 

  • Slip no. (field PAYFRMNUM)

 

Block number 2

Block number 3

  • No. of payments (field NBRPAY)

 

  • Total (field TOTLOC)

 

 

Block number 4

  • Start balance (field STRBAL)

This field is displayed only if the "Balance control" is activated in the entry transaction. It is entered only if the balance control of the bank is set to "Yes". In this case, the start and end balances can be modified using the button ..\FCT\GESPAY_01.jpg.

  • Difference (field PRODIF)

This field is displayed only if the "Balance control" is activated in the entry transaction. It is entered only if the balance control of the bank is set to "Yes".
Any change within an “Entry batch” causes to recalculate the difference for the balance (progressive balance - end balance).

  • Bank statement balances (field CHGBAL)

This button is displayed only if the "Balance control" is activated in the entry transaction. It can be accessed only if the balance control of the bank is set to "Yes".
It opens a window used to modify the start and end balances of the bank statement.

  • End balance (field ENDBAL)

This field is displayed only if the "Balance control" is activated in the entry transaction. It is entered only if the balance control of the bank is set to "Yes". In this case, the start and end balances can be modified using the button ..\FCT\GESPAY_01.jpg.

  • Progressive balance (field PROBAL)

This field is displayed only if the "Balance control" is activated in the entry transaction. It is entered only if the balance control of the bank is set to "Yes".
Any change within an “Entry batch” causes to recalculate the progressive balance (start balance + entries).

This field is displayed only if the "Balance control" is activated in the entry transaction. It is entered only if the balance control of the bank is set to "Yes".
The currency from the bank is shown.

Close

 

Action icon

Selection

 

Close

 

Reports

By default, the following reports are associated with this function :

 LISREG : Payment listing

This can be changed using a different setup.

Conditions for creating a capitalized expense automatically

For:

  • Manual creation of a discount line
  • Automatic generation of a discount line linked to the early payment of a purchase invoice or supplier BP invoice

Automatic creation of a negative capitalized expense when the following conditions are met:

  • The company is subject to German or Austrian legislation.
     
  • The DEPMGTMOD - Discount management mode parameter (TC chapter, INV group) is set to Distribution by VAT (invoice level).
     
  • Payment attribute settings for the discount line accounting code:
    - The Expense creation box is selected.
    - The Early discount/Late charge box is selected.
    - The generated entry matches this pattern: Account <=> BP.
     
  • Accounting codes: The accounting allocations for Tax type codes (determined from the tax code on the payment line) are defined for line 13 Adjustment to deduct. These are used for the accounting allocations for negative expenses.
     
  • Account set up:
    - Fixed asset tracking must be active to authorize the use of the account on assets and expenditures that are managed in the Fixed assets module.
    - Expense creation must be authorized.
    Accounting nature must be entered.

SEEINFO When the payment entry transaction process includes several steps, the expense generated for the discount takes placeduring the first step of the payment posting.
The reference of the generated expense is mentioned in the corresponding log after saving the payment.
At the expense level, the payment reference is displayed in the Invoice field and the invoice type takes the value Early discount/Late charge.

If the payment related to a discount is canceled:

  • The discount expense is automatically canceled if it has not yes been capitalized.
  • A positive expense is automatically created if the discount expense has already been capitalized. 

Specific Buttons

Select this action to post the payment. It is only active if all the data entered for the payment is complete.

This action displays the stages processed with the corresponding document number and the stages to follow depending on the entry transaction.

This option is related to the Argentinian legislation.

Click this action to approve payments as required. If approval is not required, this action is not available and the Approved status is Yes by default. Any changes to an approved payment reverts the status to not approved.


Only authorized users can approve payments. Authorizing is managed by the PAYAPP - Payment authorization parameter (TRS chapter, AUZ group).

Requiring approval only applies to payments that are expenses or unspecified payment types and if the Remittances and Bank file check boxes are selected for the payment type.

Payment approval date and approver are stored in the PAYMENTH table.

Menu bar

Zoom / Accounting Document

This zoom is available after the payment has been validated and shows all the journal entries posted for the payment.

Zoom/Transaction

Select this to view transaction settings.

Options / Accounting Cancellation

Select this action to reverse a payment. All the entries associated with it are then reversed. The payment moves back to the Entered status.

Options / Check void

Options / Journal traceability

This option gives access, via a tunnel, to the Journal traceability inquiry function that makes it possible to view and browse the hierarchy of the entries originating the document or coming from it.

Options / Receipt information

This option is only available when the KPO activity code - Portuguese localization is activated.
To enable the entry, the PORTVAT - Portuguese VAT parameter (LOC chapter, POR group) must be set to Yes.

It is useful when the payment is associated to invoices created for a customer subject to the article 23 of the law 71/2013 on VAT rule and applies to the financial information level of the Customer record. In that case, it can be used to display information relating to the payment stored in a dedicated table.

Address / Payment address

This option is used to consult the full payment address.

Functions / Credit card processing

Presentation

Click this action to:

  • Access the complete delivery address.
  • Modify the address before printing the packing slip, as needed.

If the price list is defined with respect to the country code and/or the geographical subdivision code and that the information is modified, a dialog box opens suggesting a recalculation of the discounts and prices. Answer Yes to trigger a price list search and a new assignment of prices and discounts.

Close

 

Fields

The following fields are present on this tab :

Block number 1

  • field DVCRNUM

This field indicates the document number.

  • Remaining amount (field RMNAMT)

This field displays the amount remaining to be authorized for the document.

This field is used to display the customer that will be used upon adding or saving payment cards.

This field is used to display the company linked to the processing code.

Account information

  • One time use card (field ONETIME)

This check box is automatically selected if a saved payment card does not exist on the customer record.

If the customer record is assigned a default card, this check box is cleared and the primary card information for the account nickname displays.

If a saved payment card exists on the customer record, but a default card does not exist, this check box is cleared and the account nickname must be entered or selected.

If the customer's BPC type is miscellaneous, this check box is automatically selected.

Select the One time use card check box to add a payment type to use once for this order or shipment. The data for payment and billing information is not stored and you do not need an Account nickname.

Enter a unique account nickname to identify this payment card. You can select an existing payment card for this customer or you can create a new payment account by entering a new account nickname.

The account nickname can include alpha and numeric characters with a maximum length of 15 characters.

If a customer has multiple payment cards on file, the account nickname must be unique. However, two different customers can have payment card records that use the same name.

If the One time use card checkbox is selected, this field is not available. If the check box is not selected, this field is required.

When adding a new payment card, click Create after entering a unique name to access the Sage Exchange Vault window and enter the card number and expiration date.

Enter a processing code defined by the user. This code identifies the link to the company and account defined in the Payment gateway setup.

If a default processing code exists, use this field to create a new payment card.

If a payment card already exists, recorded and selected in the customized account name field, the default value of this field is automatically displayed and cannot be modified.

  • Payment type (field PYMTYP)

This field is used to display the payment type used. The valid values are: Visa, MC, AMEX, and Other.

  • Last four digits (field ACCL4D)

This field displays the last four numbers of the payment card.

  • Expiration date (field EXPDAT)

This field displays the expiration date of the payment card.

Authorization

  • Manual entry (field MANAUT)

Select this check box to enter transaction information for Sage Exchange transactions that are processed manually outside of Sage X3.

This field is available only if the parameter MANAUTH is set to Yes at the user level.

  • Amount (field AUTAMT)

This field displays the authorized amount of the payment card.

  • Code (field AUTID)

This field displays the authorization code for the transaction.

  • Date (field AUTDAT)

This field displays the authorization date of the payment card.

  • Status (field STAFLG)

This field displays the status of the transaction by payment card.

Billing information

  • Name (field ACCNAM)

Enter the cardholder name.

If a saved payment card is selected, the cardholder name displays and cannot be changed.

If the One time use card checkbox is selected, the cardholder's name must be entered and the information is saved to the payment card transaction.

  • Billing address (field USEBILLADR)

Check this box to display the default billing address of the customer.

  • If this box is checked, the lines corresponding to the billing address of the customer are displayed and cannot be changed.
  • If this box is unchecked, the information of the billing address can be modified in the address fields of the card.

Enter the country of the invoicing address of the cardholder.

If the Billing address check box is selected, the country from the customer's bill-to address is displayed and cannot be modified.

If the Billing address check box is cleared, the country from the customer's bill-to address can be modified.

  • Address (field ADDLIG)

Enter the billing address of the cardholder.

  • If the 'Billing address' check box is selected, the address from the customer bill-to address appears and cannot be changed.
  • If the 'Billing address' check box is cleared, the billing address can be changed.
  • field SAT

Enter the invoicing status of the cardholder.

  • If the Billing address check box is selected, the status from the customer's bill-to address is displayed and cannot be modified.
  • If the Billing address checkbox is cleared, the invoicing status can be modified.
  • Postal code (field POSCOD)

Enter the postal code.

If the Billing address check box is selected, the postal code from the customer bill-to address appears and cannot be modified.

If the Billing address check box is cleared, the postal code from the customer bill-to address can be modified.

  • City (field CTY)

Enter the customer’s city.

If the Billing address check box is selected, the city from the customer's bill-to address is displayed and cannot be modified.

If the Billing address check box is cleared, the city from the customer's bill-to address can be modified.

  • Email address (field EMAIL)

This field displays the customer’s email address for this transaction.

Payment

  • Amount (field PAYAMT)

This field displays the payment amount to be applied to the payment card during the invoice allocation.

  • Date (field PAYDAT)

This field is used to display the payment date used during the transaction.

  • Number (field PAYNUM)

Payment number associated with the transaction.

Grid History

  • Document (field HVCRNUM)

This field displays the document number, processed for the selected payment card.

  • Sequence (field HVCRSEQ)

This field displays the sequence number counter of the document, processed or the selected payment card.

  • Transaction type (field HTXNTYP)

This field displays the transaction type of the document, processed for the selected payment card.

  • Amount (field HAUTAMT)

This field displays the document invoiced amount processed on the selected payment card.

  • Original amount (field HORIGAUTH)

This field displays the originally authorized document amount and, if it was rejected, the amount used in the authorization request.

  • Date (field HAUTDAT)

This field displays the processing date of the transaction for the selected payment card.

Close

 

Limits

Management of tax discounts

When the company manages tax discounts for the invoicing elements (the DEPMGTMOD - Discount management mode parameter (TC chapter, INV group) is set to Rebate on VAT), then the early discount/late charge amounts in payment entry or proposal includes taxes. The calculation does not take into account the VAT already deducted from the early discount/late charge when invoicing.

Unmatching/Rematching

After cancelling a payment, the open items for a payment and associated open items:

  • Could no longer be matched
  • Could be partially matched (in lowercase) although the group is balanced

This is because the accounting cancellation of a payment does not always take into account the matching information if:

  • The open items of the canceled payment are matched with other entries that are not present in the canceled payment
  • These entries contain a credit memo that is allocated and matched to an invoice in the group even though it was closed (parameter LETAUTCNO- Auto match inv ->credit note, (CPT chapter, MTC group) is set to Yes).
Case of an inactive BP client or supplier

Creating payments for an inactive BP is prohibited in Manual entry of payments.
To avoid completely blocking the recording of a payment received from, or directed to, a recently inactive BP, the payment of the open items for this BP remains possible in the automatic Payment proposals function.

Open item selection by payment currency picking

While creating a payment by selecting an open item date, the  Currency field is loaded with the currency of the first selected open item date. The currency cannot be modified.

If you require a payment currency different from the open item currency, enter the payment currency before selecting a due date.

Cases not managed in standard

Sage X3 does not manage the following cases in standard mode: payment in currency A  and prepayment in currency B, with a BP in the payment header different from the BP of the order.

Open items in the selection panel

In the selection panel, the  Open items and Grouped open items  lists only suggest open items with an entry type where the  Management of open items check box is selected.

Specific case :

For a payment in creation progress with the payment site not yet entered (payment legislation not known). In this case, the legislation of the entry type to be considered is determined as follows:

  • If the entry transaction includes a legislation, this legislation is considered. The open items displayed apply to the entry types of this legislation where the  Manage open items check box is selected.
  • If the entry transaction does not include a legislation, the system searches for the LEGFIL - Legislation (selection filter)parameter (SUP chapter, INT group).

    - If the LEGFIL parameter includes a value, the legislation of this parameter is taken into account.
    - If the LEGFIL parameter is blank, the system searches for the default folder legislation and the first legislation found is considered as a last resort.

Exceptions when the entry type is linked to no legislation:

1) When the site is not specified on the payment, the open item is displayed in the grouped open item list, even when the open item has been posted for a company with a legislation different from the one of the entry transaction.

2) If the payment entry transaction is not linked to any legislation, the open item is displayed, regardless of the default folder legislation or value of the LEGFIL parameter.


Manual matching

If you allocate open items by manual matching, the payment remains allocated and the payment is still displayed on the print-out.


Prepayment open items linked to a sales order

When creating a prepayment open item linked to a sales order where the Exempted tax field is set to Yes, the following apply:

  • There no VAT calculation in the sales document, although a tax rate is set in the tax code grid in the Tax rates function (GESTVT).
  • When such a prepayment is paid and posted, the VAT is calculated according to the tax rate in the tax code grid.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Open item in the process of being matched

The open item selected has already been the object of a matching that has not been completed yet. The matching is probably 'pending' in the 'Accounting task'. Verify that the accounting task is active.

Caution, different payment address code

A control makes it possible to check the consistency between the payment address and that of the open item.

Mandatory allocation

In the specific case of SDD, this message is displayed if an attempt is made to create a payment without allocation.

Tables used

SEEREFERTTO Refer to documentation Implementation