Supplier Invoices - 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 :
CASIN (Treasury interface), CSL1 (Consolidation or pre-conso.), FEE2 (Fee declaration), KAG (Argentinean localization), PBDPO (Payment balance declaration).
Functional
BADBT :
Bad debt management
BE281 :
Belgian 281.5 form
CCN :
Concessions
CFOM :
Cash forecast management
CSL :
Consolidation
CTSW :
Control system
DAS :
DAS2
DEB :
EU exchange declaration
EFAT :
EFAT connector
EINV :
Electronic invoice
ELINV :
Electronic invoice ZAF
EORI :
EORI identification
ESD :
European services declaration
FAS :
Asset folder
FCT :
Factoring management
FUP :
Reminder and late payment mana
GDD :
Operating budgets
INTCO :
Intercompany transactions
LND :
Loan management
MAXPD :
Maximum period (companies)
MURAN :
Spanish payroll
PJM :
Project management
PPT :
Prospect management
PRCSL :
Pre-consolidation
PTX :
Regional taxes
REX :
REX Customs System
S1099 :
1099
SDD :
SDD management
SMI :
Integrale migration
SVC :
Periodic accruals
WTHMG :
Withholding tax management
Sizing
ANA :
No. of analytical dimensions
NBCOA :
No. of charts of accounts
PFI :
Max no. invoicing elements
PIH :
Supplier invoice lines maximum
REC :
Customer sales reps
SFI :
Max. no. entered inv. elts
STC :
Sales statistical groups
STS :
Purchasing statistical groups
Localization
KBE :
Belgian localization
KDE :
German localization
KFR :
French localization
KIT :
Italian localization
KPL :
Polish localization
KPO :
Portuguese Localization
KRU :
Russian localization
KSP :
Spanish localization
KSW :
Swiss localization
KZA :
South-African localization
General parameters
The following general parameters may change the way the function is working :
Fixed assets
VATAUTVAL (defined at level Company) : Automatic VAT validation
Accounting
ACESIMTRC (defined at level User) : Simulated entry generation
CONTROLDAS (defined at level Company) : DAS2 parameter control
LETAUTCNO (defined at level Company) : Auto match inv ->credit note
Localisations
AUSABNWRN (defined at level Company) : Warn supplier without ABN
SWIPAYBVR (defined at level Company) : Control of Swiss payments
SWIPAYQR (defined at level Company) : Control of Swiss QR payments
SWIPURQRC (defined at level Site) : QR code entry
Common Data
CTLPERINV (defined at level Company) : Invoice date control Period
DEFBONPAY (defined at level User) : PA default value
DMAXAGR (defined at level Company) : Maximum contractual period
DMAXPAY (defined at level Company) : Maximum period (companies)
DMAXPAYP (defined at level Company) : Maximum period (Public sector)
FLGPAZ (defined at level Site) : Payment approval management
FRADGI (defined at level Company) : French fiscal regulation
GAUKIK2 (defined at level Folder) : Expense accruals supplier inv.
NIVBONPAYE (defined at level User) : Payment approval level
PIVSUP (defined at level Site) : Delete invoices
POSTINVSUP (defined at level Company) : Invoice accounting cancellation
SIVNULL (defined at level Site) : Lines set to zero prohibited
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
SUPINVDAT (defined at level Site) : Validity control for dates
TYPINVSUP (defined at level Company) : Supplier invoice type
WRNINVOICE (defined at level Site) : Invoice no. warning
Sequence numbers
The sequence numbers used to number the documents managed by this function are :
WRK : Workflow
WRK : Workflow
The sequence number assignment function defines the sequence number which is used
Accounting interface
Automatic journals
The following automatic journals are used in the posting processes associated with the function :
BPSIN : Supplier Invoice - A/P
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.
The following options can be activated or deactivated for each user :
Invoice validation
Open items
Other prerequisites
Tables to be completed
The following tables are used by the function. Their content must be updated if necessary :
|
Table |
Table description |
|---|---|
|
TABPIVTYP [TPV] |
|
|
TABSIVTYP [TSV] |
|
|
GAUTACE [GAU] |
Chart of accounts and analytical chart of accounts
The general accounts, link accounts, natures and analytical dimensions must be defined, too.
CTLPERINV - Period invoice date control parameter
When the CTLPERINV - Invoice date control Period parameter (TC chapter, INV group) is set to 'Yes', the creation of the invoice is prohibited when there is at least one document (invoice, credit memo, debit or credit note of one of the Purchase and AccountingSupplier BP modules) whose date is strictly higher than the end date of the period on which the current document is entered.Tables used
The following tables are implemented by the function :
|
Table |
Table description |
|---|---|
|
ACCES [ACC] |
Access by user |
|
ATABDIV [ADI] |
|
|
AUTILIS [AUS] |
|
|
BID [BID] |
Bank ID statement |
|
BPADDRESS [BPA] |
Addresses |
|
BPARTNER [BPR] |
|
|
BPCUSTOMER [BPC] |
|
|
BPSINVLIG [PIL] |
Supplier invoice lines |
|
BPSINVLIGA [PIA] |
Supplier analytical line |
|
BPSUPPLIER [BPS] |
|
|
BPSUPPMVT [MVS] |
Supplier transactions |
|
CAAUZ [CAZ] |
|
|
CACCE [CCE] |
|
|
CADSP [DSP] |
|
|
COMPANY [CPY] |
|
|
CONTEXT [CNX] |
|
|
FACILITY [FCY] |
|
|
FISCALYEAR [FIY] |
|
|
FISCYEAR [FIS] |
Fiscal year |
|
GACCCODE [CAC] |
|
|
GACCDUDATE [DUD] |
Open items |
|
GACCOUNT [GAC] |
|
|
GAUTACE [GAU] |
|
|
GAUTACED [GAD] |
|
|
GAUTACEF [GAG] |
Automatic journal formulas |
|
GDIAACC [GDA] |
|
|
GTYPACCENT [GTE] |
|
|
PERIOD [PER] |
Periods |
|
PINVOICE [PIH] |
|
|
TABCOUNTRY [TCY] |
|
|
TABCUR [TCU] |
|
|
TABPIVTYP [TPV] |
|
|
TABUNIT [TUN] |
|
|
TABVACBPR [TVB] |
|
|
TABVAT [TVT] |