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, 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 :
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 :
|
Table |
Table description |
|---|---|
|
GACCDENCOD [CDA] |
|
|
GAUTACE [GAU] |
|
|
GRPAUTACE [GRA] |
|
|
FISCALYEAR [FIY] |
|
|
PERIOD [PER] |
Periods |
|
GACCOUNT [GAC] |
|
|
TABPAYTYP [TPY] |
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 :
|
Table |
Table description |
|---|---|
|
ATABDIV [ADI] |
|
|
AUTILIS [AUS] |
|
|
BANK [BAN] |
|
|
BID [BID] |
Bank ID statement |
|
BPARTNER [BPR] |
|
|
BPCUSTOMER [BPC] |
|
|
BPSUPPLIER [BPS] |
|
|
CACCE [CCE] |
|
|
CACCEDEF [CDE] |
|
|
CADSP [DSP] |
|
|
COMPANY [CPY] |
|
|
FACILITY [FCY] |
|
|
FISCALYEAR [FIY] |
|
|
GACCCODE [CAC] |
|
|
GACCDENCOD [CDA] |
|
|
GACCDUDATE [DUD] |
Open items |
|
GACCENTRY [HAE] |
Accounting entries |
|
GACCOUNT [GAC] |
|
|
PAYLOT [PYL] |
Entry batch |
|
PAYMENTA [PYA] |
Analytical payment lines |
|
PAYMENTD [PYD] |
Payment lines |
|
PAYMENTH [PYH] |
Payment header |
|
PERIOD [PER] |
Periods |
|
PORDER [POH] |
|
|
SORDER [SOH] |
|
|
TABCHANGE [TCH] |
Currency rate table |
|
TABCOUAFF [TCA] |
|
|
TABCOUNTRY [TCY] |
|
|
TABCUR [TCU] |
|
|
TABPAYTYP [TPY] |
|
|
TABUNIT [TUN] |
|
|
TABVAT [TVT] |