Purchasing > Invoices > Invoices > 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.), DEBR (Intrastat state/region), FEE2 (Fee declaration), KAG (Argentinean localization), LABD (Number of labor groups), MACD (Number of machine groups), MATD (Number of material groups), PBDPO (Payment balance declaration), PP1 (Purchase charge / discount 1), PP2 (Purchase charge / discount 2), PP3 (Purchase charge / discount 3), PP4 (Purchase charge / discount 4), PP5 (Purchase charge / discount 5), PP6 (Purchase charge / discount 6), PP7 (Purchase charge / discount 7), PP8 (Purchase charge / discount 8), PP9 (Purchase charge / discount 9), SI1 (Product statistical group 1), SI2 (Product statistical group 2), SI3 (Product statistical group 3), SI4 (Product statistical group 4), SI5 (Product statistical group 5).

Functional

 BE281 : Belgian 281.5 form

 CCN : Concessions

 CFG : Configurator

 CFOM : Cash forecast management

 CSL : Consolidation

 DAS : DAS2

 DEB : EU exchange declaration

 ECC : Product version management

 EDIX3 : Paperless document exchange

 EORI : EORI identification

 ESD : European services declaration

 FAS : Asset folder

 FOA : Food allergens

 GDD : Operating budgets

 LPN : Internal container management

 LTA : Local taxing

 MAXPD : Maximum period (companies)

 MURAN : Spanish payroll

 MWM : Weighing stations

 NPI : Product design

 PJM : Project management

 PLM : PLM - X3 interface

 PRCSL : Pre-consolidation

 PTX : Regional taxes

 REX : REX Customs System

 RVM : Routing version management

 S1099 : 1099

 SAFT : SAF-T

 SMI : Integrale migration

 SPD : Stock cost breakdown

 SVC : Periodic accruals

 WRH : Warehouse management

 WTHMG : Withholding tax management

Sizing

 ANA : No. of analytical dimensions

 NBCOA : No. of charts of accounts

 NDL : Default no. of locations

 NUC : Number of packing units

 PFI : Max no. invoicing elements

 PIH : Supplier invoice lines maximum

 PPR : Max purchasing charge/discount

 PVA : Max no. taxes by document

 STI : Product 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

 KSP : Spanish localization

 KSW : Swiss localization

 KUK : Localization united kingdom

 KUS : Localization USA

 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

Purchase

 DACMANPUR (defined at level Site) : Default price reason - manual

 ITMBPS (defined at level Site) : Supplier referencing

 ITMFLG (defined at level Company) : Product/supplier ref. entry

 NODVATSTO (defined at level Company) : Non-deductible taxes in stock

 PCTLVAT (defined at level Company) : Tax code control

 PIBLKR (defined at level Company) : Restriction to inv line source

 PIHACCDAT (defined at level Company) : Allow account date changes

 PIHCALTAX (defined at level Company) : Tax calculation

 PIHCPR (defined at level Company) : Invoice price adjustment

 PIHCURDAT (defined at level Company) : Invoice currency rate date

 PIHQTYAQR (defined at level Company) : Billable quantity

 PIHQTYRET (defined at level Company) : Returned quantity invoicing

 PRIFLG (defined at level Site) : Full stock valuation

 PURCMM (defined at level Site) : Update budget - commitments

 PURCMMPIH (defined at level Site) : Invoice de-commitment date

 PURCMMTAX (defined at level Site) : Commitment type

 PURREN (defined at level Site) : Require price reasons

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

 PORVAT (defined at level Company) : Portuguese VAT

 SPAVAT (defined at level Company) : VAT Spain

 SWIPAYBVR (defined at level Company) : Control of Swiss payments

 SWIPAYQR (defined at level Company) : Control of Swiss QR payments

 SWIPURBVR (defined at level Site) : Swiss ISR usage purchasing

 SWIPURQRC (defined at level Site) : QR code entry

Common Data

 ACHENDDAT (defined at level User) : Purchase end date

 ACHSTRDAT (defined at level User) : Purchase start date

 CTLOPPCOD (defined at level Folder) : Project code control

 CTLPERINV (defined at level Company) : Invoice date control Period

 DEFBONPAY (defined at level User) : PA default value

 DEPMGTMOD (defined at level Company) : Discount management mode

 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

 GAUKIK4 (defined at level Company) : Expense accruals purchase inv.

 NIVBONPAYE (defined at level User) : Payment approval level

 OSTSCTL (defined at level Company) : Sup. author. credit ctrl 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

The purchase user parameters ACHSTRDAT - Purchase start date (chapter TC, group CLO) and ACHENDDAT - Purchase end date (chapter TC, group CLO) make it possible to define, by user, the date ranges for entering invoices, credit memos and complementary invoices.

Sequence numbers

No sequence number is used by this function.

The counters of invoices, credit memos and additional invoices must be selected as 'Chronological control' since counters managed on a chronological basis can be used for these types of documents. These counters ensure that a document which has been entered cannot have a date prior to that of the previous document. The counter number of the previous document has to be strictly less than the counter number of the new document.

Accounting interface

Automatic journals

The following automatic journals are used in the posting processes associated with the function :

 PIHI: Facture fournisseur (achat)

Default dimensions

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

(defined at level Company)

 PIH (All companies ) : Purchase Invoice Header

 PIV (All companies ) : Invoice invoicing element

 PIC (All companies ) : Add. purchase invoice line

 PID (All companies ) : Purchase Invoice Line

 PCOSTPIH (All companies ) : Purchase Cost of invoice

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.

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

 Post

 Open items

 Unblock matching error

 Issuing

Entry transactions

This function is managed with entry transactions which can be set up.

A standard transaction is suggested when installing the software. A setup function is used to modify this standard transaction or create new personalized transactions. This setup essentially exists to specify some functional characteristics of the transaction and display as well as the default loading for certain fields.

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]

Supp invoice type table

Invoice type

The definition of the invoice type (see the Invoice type documentation) is used to specify if the document has the invoice, additional invoice, credit memo or credit memo on return type). It is at this level that the automatic journal (which is used to generate an accounting entry during posting (see the Automatic journal documentation) is specified. It is possible to have an automatic journal for each document type. The PIHI journal delivered as standard is used to automatically make the difference between the different document types. At this stage, a journal type and a specific accounting journal code can also be specified. It is at the level of the journal type (see the Journal type documentation) that a specific sequence number counter can be defined for the automatic numbering of the journal entries created (see the Sequence number counters documentation). If no sequence number counter is specified at document type level, the sequence number counter specified at the level of the sequence number counter assignment option will be used (see the Sequence number assignment documentation).

Accounting prerequisites

The fiscal years and accounting periods must be open.

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 Accounting Supplier 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

ATABDIV [ADI]

Miscellaneous tables

BPADDRESS [BPA]

Addresses

BPARTNER [BPR]

Business partner

BPSUPPLIER [BPS]

Suppliers

BPSUPPMVT [MVS]

Supplier transactions

COMPANY [CPY]

Company

CONTEXT [CNX]

Contexts

CPTANALIN [CAL]

Analytical accounting lines

FACILITY [FCY]

Sites

FISCALYEAR [FIY]

Fiscal years

FISCYEAR [FIS]

Fiscal year

GACCCODE [CAC]

Accounting codes

GACCOUNT [GAC]

Accounts

GTYPACCENT [GTE]

Document types

ITMBPS [ITP]

Supplier product

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

ITMMVT [ITV]

Product-site totals

PERIOD [PER]

Periods

PFOOTINV [PFI]

Purchase invoicing elements

PINVOICE [PIH]

Purchase invoices

PINVOICED [PID]

Purchase invoice detail

PINVOICEV [PIV]

Costing purchase invoices

PORDER [POH]

POs

PORDERC [POC]

Cumulative POs before returns

PORDERP [POP]

POs price

PORDERQ [POQ]

POs quantities

PRECEIPT [PTH]

Receipt

PRECEIPTD [PTD]

Detail receipts

PRETURN [PNH]

Returns

PRETURND [PND]

Detail return

PVCRFOOT [PVF]

Purchase documents - footer elt

PVCRVAT [PVV]

Purchase documents - taxes

TABCOEFF [TCO]

Coefficients table

TABCOUNTRY [TCY]

Country table

TABCUR [TCU]

Currency table

TABPIVTYP [TPV]

Supp invoice type table

TABUNIT [TUN]

Table of units of measure

TABVACBPR [TVB]

BP tax rule table

TABVAT [TVT]

Tax code table