Payment/Receipt Entry - Implementation

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 :

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

Functional

 BSI : Bank statement import

 CHQMG : Checkbooks management

 FAS : Asset folder

 SDD : SDD management

 SEPP : Credit card integration

 VII : International transfers

 WTHMG : Withholding tax management

Sizing

 ANA : No. of analytical dimensions

 PAY : Number of payment lines

 PYL : No. of payments/entry batch

Localization

 KDE : German localization

 KIT : Italian localization

 KPO : Portuguese Localization

 KSW : Swiss localization

 KUK : Localization united kingdom

General parameters

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

Accounting

 ACESIMTRC (defined at level User) : Simulated entry generation

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

Payroll-X3P

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

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

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

Common Data

 CTLPAZ (defined at level User) : Pay approval control

 DEPMGTMOD (defined at level Company) : Discount management mode

 NIVBONPAYE (defined at level User) : Payment approval level

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

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

Acc Payable/Acc Receivable

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

 BANKDEF (defined at level User) : Default bank

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

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

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

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

 CAISDEF (defined at level User) : Default cash

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

 CHGRATIPT (defined at level Company) : Deposit rate

 DACVALDAT (defined at level Folder) : Manage valuation date

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

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

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

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

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

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

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

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

 JOUPAY1 (defined at level Site) : Bank journal

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

 JOUPAY3 (defined at level Site) : Drafts receivable journal

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

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

 JOUPAY6 (defined at level Site) : Payment receipt journal

 JOUPAY7 (defined at level Site) : Discount journal

 PAYAPP (defined at level User) : Payment authorization

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

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

 PAYRNDMAX (defined at level Folder) : Maximum rounding variance

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

 PPYCONSCTL (defined at level Company) : Prepayment control

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

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

 PROBALCTL (defined at level Legislation) : Progressive balance control

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

 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 :

 PY1 : Payment Receipts

 PY5 : Payments-Deposit Slips

 PY7 : Payments-Paying Bank notes

 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)

 PAYMENTD (All companies ) : Payment detail line

Authorizations

This function is object managed. The creation, modification, anddeletion operations can be activated or deactivated for a given user.Filters by rolescan 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 tothe 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 :

 Accounting cancellation

 Post

 Transactions

 Entry batch

 Check void

Other prerequisites

Miscellaneous tables

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

 Miscellaneous table number 3 : After-Sales steps

 Miscellaneous table number 304 : Financial data extraction

 Miscellaneous table number 306 : Interbank codes

 Miscellaneous table number 314 : Bank card type

 Miscellaneous table number 325 : File grouping code

 Miscellaneous table number 309 : File grouping code

 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 :

Local menus

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

 Local menu number 689 : Payment status

 Local menu number 655 : Deposit type

 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

 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 :