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
ESD :
European services declaration
FAS :
Asset folder
FOA :
Food allergens
GDD :
Operating budgets
LTA :
Local taxing
MAXPD :
Maximum period (companies)
MURAN :
Spanish payroll
MWM :
Weighing stations
PJM :
Project management
PLM :
PLM - X3 interface
PRCSL :
Pre-consolidation
PTX :
Regional taxes
RVM :
Routing version management
S1099 :
1099
SAFT :
SAF-T
SMI :
Integrale migration
SPD :
Stock cost breakdown
SVC :
Cost and revenue accruals
WRH :
Warehouse 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
KAU :
Australian 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
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
GAUKIK4 (defined at level Company) : Suppl. service prov staggering
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
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
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
FLGPAZ (defined at level Site) : Payment approval management
FRADGI (defined at level Company) : French fiscal regulation
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
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.
Counters
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, 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 :
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] |
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). The automatic journal (which is used to generate an accounting entry during posting (see the Automatic journal documentation) is specified at this stage. 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. It is also possible to define at this level a type of journal and any specific journal code. 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 the level of the journal type, it is the sequence number counter specified at the level of the sequence number counter assignment option that will be used (see the Sequence number counter assignment).
Accounting prerequisites
The fiscal years and accounting periods must be open.
Compliance with the French fiscal rules
If you want to comply with DGI (France), the CTLPERINV - Control period invoice date parameter must be set to: Yes.
In this case:
- The creation of the invoice is prohibited in the case where there is at least one document (invoice, credit memo, debit or credit note of one of the modules Purchaseand Accounting Supplier BP) 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] |
|
|
BPADDRESS [BPA] |
Addresses |
|
BPARTNER [BPR] |
|
|
BPSUPPLIER [BPS] |
|
|
BPSUPPMVT [MVS] |
Supplier transactions |
|
COMPANY [CPY] |
|
|
CONTEXT [CNX] |
|
|
CPTANALIN [CAL] |
Analytical accounting lines |
|
FACILITY [FCY] |
|
|
FISCALYEAR [FIY] |
|
|
FISCYEAR [FIS] |
Fiscal year |
|
GACCCODE [CAC] |
|
|
GACCOUNT [GAC] |
|
|
GTYPACCENT [GTE] |
|
|
ITMBPS [ITP] |
|
|
ITMFACILIT [ITF] |
|
|
ITMMASTER [ITM] |
|
|
ITMMVT [ITV] |
Product-site totals |
|
PERIOD [PER] |
Periods |
|
PFOOTINV [PFI] |
|
|
PINVOICE [PIH] |
Purchase invoices |
|
PINVOICED [PID] |
Purchase invoice detail |
|
PINVOICEV [PIV] |
Costing purchase invoices |
|
PORDER [POH] |
|
|
PORDERC [POC] |
Cumulative POs before returns |
|
PORDERP [POP] |
POs price |
|
PORDERQ [POQ] |
POs quantities |
|
PRECEIPT [PTH] |
|
|
PRECEIPTD [PTD] |
Detail receipts |
|
PRETURN [PNH] |
|
|
PRETURND [PND] |
Detail return |
|
PVCRFOOT [PVF] |
Purchase documents - footer elt |
|
PVCRVAT [PVV] |
Purchase documents - taxes |
|
TABCOEFF [TCO] |
|
|
TABCOUNTRY [TCY] |
|
|
TABCUR [TCU] |
|
|
TABPIVTYP [TPV] |
|
|
TABUNIT [TUN] |
|
|
TABVACBPR [TVB] |
|
|
TABVAT [TVT] |