Prerequisites

Activity codes

The following activity codes (sorted by type) may have an impact on the way the function operates :

Dependent activity codes

These codes are never entered in folder management, because their value is calculated :

Bullet point  KAG (Argentinean localization), REGBC (Bank/Cash register).

Functional

Bullet point  BSI :  Bank statement import

Bullet point  CHQMG :  Checkbooks management

Bullet point  FAS :  Asset folder

Bullet point  SDD :  SDD management

Bullet point  SEPP :  Credit card integration

Bullet point  VII :  International transfers

Bullet point  WTHMG :  Withholding tax management

Sizing

Bullet point  ANA :  No. of analytical dimensions

Bullet point  PAY :  Number of payment lines

Bullet point  PYL :  No. of payments/entry batch

Localization

Bullet point  KDE :  German localization

Bullet point  KIT :  Italian localization

Bullet point  KPO :  Portuguese Localization

Bullet point  KSW :  Swiss localization

Bullet point  KUK :  Localization united kingdom

General parameters

The following general parameters may change the way the function is working :

Accounting

Bullet point  ACESIMTRC (defined at level User) : Simulated entry generation

Bullet point  MTCRNDBAT (defined at level Site) : Batch auto balancing threshold

Payroll-X3P

Bullet point  AMTVIR1 (defined at level Company) : Threshold 1 payment balance

Bullet point  AMTVIR2 (defined at level Company) : Threshold 2 payment balance

Bullet point  AMTVIR3 (defined at level Company) : Threshold 3 PB countervalue

Common Data

Bullet point  CTLPAZ (defined at level User) : Pay approval control

Bullet point  DEPMGTMOD (defined at level Company) : Discount management mode

Bullet point  NIVBONPAYE (defined at level User) : Payment approval level

Bullet point  TRSENDDAT (defined at level User) : A/P-A/R accounting end date

Bullet point  TRSSTRDAT (defined at level User) : A/P-A/R accounting start date

Acc Payable/Acc Receivable

Bullet point  AUTDEPCUS (defined at level Company) : Auto calc AR discount taken

Bullet point  BANKDEF (defined at level User) : Default bank

Bullet point  BIDBPENT (defined at level User) : Authorize bank acct. no. entry

Bullet point  BIDPAYENT (defined at level User) : Authorize bank acct. no. entry

Bullet point  BPCORDTYP (defined at level Legislation) : Customer order doc type

Bullet point  BPSORDTYP (defined at level Legislation) : Supplier order doc type

Bullet point  CAISDEF (defined at level User) : Default cash

Bullet point  CHGRAT (defined at level Company) : Reval. payment accounting rate

Bullet point  CHGRATIPT (defined at level Company) : Deposit rate

Bullet point  DACVALDAT (defined at level Folder) : Manage valuation date

Bullet point  DATDEP (defined at level Company) : Date for the calc of discounts

Bullet point  DENCRG (defined at level Company) : Late charge payment attribute

Bullet point  DENDEP (defined at level Company) : Customer early paymt./discount

Bullet point  DENINSRCP (defined at level Company) : Prepayment rec accounting code

Bullet point  DENINSSEN (defined at level Company) : Prepayment iss accounting code

Bullet point  DENPAY (defined at level Company) : Supplier early paymt./discount

Bullet point  DENSPG (defined at level Company) : Payment exp accounting code

Bullet point  DENTAK (defined at level Company) : Payment rec accounting code

Bullet point  JOUPAY1 (defined at level Site) : Bank journal

Bullet point  JOUPAY2 (defined at level Site) : Check to cash journal

Bullet point  JOUPAY3 (defined at level Site) : Drafts receivable journal

Bullet point  JOUPAY4 (defined at level Site) : Purchase notes payable journal

Bullet point  JOUPAY5 (defined at level Site) : FA notes payable journal

Bullet point  JOUPAY6 (defined at level Site) : Payment receipt journal

Bullet point  JOUPAY7 (defined at level Site) : Discount journal

Bullet point  PAYAPP (defined at level User) : Payment authorization

Bullet point  PAYRNDCDA1 (defined at level Company) : Bank <=> BP rounding variance

Bullet point  PAYRNDCDA2 (defined at level Company) : Account <=> BP rounding variance

Bullet point  PAYRNDMAX (defined at level Folder) : Maximum rounding variance

Bullet point  PAYUNALL (defined at level Company) : Unalloc. payments considered

Bullet point  PPYCONSCTL (defined at level Company) : Prepayment control

Bullet point  PRCAMTCNV (defined at level Folder) : Currency amount variation %

Bullet point  PRCTOL (defined at level Folder) : % variance on tolerance amount

Bullet point  PROBALCTL (defined at level Legislation) : Progressive balance control

Bullet point  SEVBPRENT (defined at level Site) : Inter-BP MOs for payment

Bullet point  SEVFCYENT (defined at level Site) : Inter-site GL for payment

Sequence Numbers

The sequence numbers used to number the documents managed by this function are :

Bullet point  PY1 : Payment Receipts

Bullet point  PY5 : Payments-Deposit Slips

Bullet point  PY7 : Payments-Paying Bank notes

Bullet point  PYL : Payment Lot

The sequence number assignment function defines the sequence number which is used

The addition can be used at the level of the sequence number counter in order, for each transaction to introduce the transaction code used sequence number counters PY1, PY5, PY7 and PY.

Accounting interface

Default dimensions

The default dimensions sections assignment is performed through the following codes :

(defined at level Company)

Bullet point  PAYMENTD (All companies ) : Payment detail line

Authorizations

This function is object managed. The creation, modification, and deletion operations can be activated or deactivated for a given user. Filters by roles can also be associated with this function.

As data is linked to a site, a filter per site can be activated.

A filter by access code is performed, based on the field named ACS. If an acess code is given, the inquiry and modification rights are granted according to the reading and writing rights associated with the code of the current user in their function profile.

The following options can be activated or deactivated for each user :

Bullet point  Accounting cancellation

Bullet point  Post

Bullet point  Transactions

Bullet point  Entry batch

Bullet point  Check void

Other prerequisites

Miscellaneous tables

The following miscellaneous tables are used by the function. They must be populated if necessary :

Bullet point  Miscellaneous table number 3 : After-Sales steps

Bullet point  Miscellaneous table number 304 : Financial data extraction

Bullet point  Miscellaneous table number 306 : Interbank codes

Bullet point  Miscellaneous table number 314 : Bank card type

Bullet point  Miscellaneous table number 325 : File grouping code

Bullet point  Miscellaneous table number 309 : File grouping code

Bullet point  Miscellaneous table number 313 : SEPA - Payment nature

Tables to be completed

The following tables are used by the function. Their content must be updated if necessary :

Table

Table description

GACCDENCOD [CDA]

Payment attribute

GAUTACE [GAU]

Automatic journals

GRPAUTACE [GRA]

Automatic journal group

FISCALYEAR [FIY]

Fiscal years

PERIOD [PER]

Periods

GACCOUNT [GAC]

Accounts

TABPAYTYP [TPY]

Payment transactions

Local menus

The following parameterizable local menus are used by the function. Their content must be updated if necessary :

Bullet point  Local menu number 689 : Payment status

Bullet point  Local menu number 655 : Deposit type

Bullet point  Local menu number 646 : Purchase Type

Charts of Accounts

The general ledger accounts, linked accounts, analytical accounts and dimensions must be defined.

Fiscal years and periods

The journal date is controlled with respect to the periods and fiscal years tables: the fiscal year and the period must be open.

Entry transactions

The Entry transactions must be set up. By default the transactions delivered by Sage X3 separate the customer and supplier transactions. This is also used to define:

  • Specific entry screens (on 1 to 4 tabs)
  • Specific information linked to the payment method (example: a check entry transaction displays the Check number field on the screen; a bank transfer entry transaction displays the fields relating to the Bank ID fields on the screen)
  • different posting phases:
    • Draft management posting
    • Deposit on intermediate account
    • Deposit in the bank (mandatory stage)
    • Draft devaluation

Note An entry transaction that can be submitted to SEPA relates to payments in Euro only.

Accounting destinations

The payment attributes must be set up. They define the account structures to be used, for example, as a payment attribute of type Cash receipt that acts on a bank account and a BP account.

Automatic journal groups and automatic journals

The posting stage at transaction level involves:

  • Having a group of automatic payment journals available. An automatic journal group contains all the journals likely to be generated at a given posting stage. It is also at this level that the matching rules are defined between payments and invoices.
  • Having automatic journals available. These journals allow the posting of the payment based on the account structure specified by the payment attribute and the payment stage.

Tables used

The following tables are implemented by the function :

Table

Table description

ATABDIV [ADI]

Miscellaneous tables

AUTILIS [AUS]

Users

BANK [BAN]

Bank accounts

BID [BID]

Bank ID statement

BPARTNER [BPR]

Business partner

BPCUSTOMER [BPC]

Customers

BPSUPPLIER [BPS]

Suppliers

CACCE [CCE]

Dimensions

CACCEDEF [CDE]

Default dimensions

CADSP [DSP]

Analytical allocations

COMPANY [CPY]

Company

FACILITY [FCY]

Sites

FISCALYEAR [FIY]

Fiscal years

GACCCODE [CAC]

Accounting codes

GACCDENCOD [CDA]

Payment attribute

GACCDUDATE [DUD]

Open items

GACCENTRY [HAE]

Accounting entries

GACCOUNT [GAC]

Accounts

PAYLOT [PYL]

Entry batch

PAYMENTA [PYA]

Analytical payment lines

PAYMENTD [PYD]

Payment lines

PAYMENTH [PYH]

Payment header

PERIOD [PER]

Periods

PORDER [POH]

POs

SORDER [SOH]

Sales orders - header

TABCHANGE [TCH]

Currency rate table

TABCOUAFF [TCA]

Sequence No assignments

TABCOUNTRY [TCY]

Country table

TABCUR [TCU]

Currency table

TABPAYTYP [TPY]

Payment transactions

TABUNIT [TUN]

Table of units of measure

TABVAT [TVT]

Tax code table