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 :

Bullet point  DKS (Electronic signature), KAG (Argentinean localization), RE1 (Sales rep 1), RE2 (Sales rep 2), 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), SLO (Management by sub-lots), SP1 (Sales charge / discount 1), SP2 (Sales charge / discount 2), SP3 (Sales charge / discount 3), SP4 (Sales charge / discount 4), SP5 (Sales charge / discount 5), SP6 (Sales charge / discount 6), SP7 (Sales charge / discount 7), SP8 (Sales charge / discount 8), SP9 (Sales charge / discount 9), VATTN (VAT declaration no.).

Functional

Bullet point  CTSW :  Control system

Bullet point  DEB :  EU exchange declaration

Bullet point  ECC :  Product version management

Bullet point  EDIX3 :  Paperless document exchange

Bullet point  EINV :  Electronic invoice

Bullet point  ELINV :  Electronic invoice ZAF

Bullet point  EMP :  Location management

Bullet point  FCT :  Factoring management

Bullet point  LOT :  Lot management

Bullet point  LPN :  Internal container management

Bullet point  LTA :  Local taxing

Bullet point  PAL :  Stock identifiers

Bullet point  PJM :  Project management

Bullet point  PREPM :  Prepayment invoice management

Bullet point  SDD :  SDD management

Bullet point  SEPP :  Credit card integration

Bullet point  SER :  Serial number management

Bullet point  SMI :  Integrale migration

Bullet point  SVC :  Periodic accruals

Bullet point  WRH :  Warehouse management

Sizing

Bullet point  ANA :  No. of analytical dimensions

Bullet point  BOD :  Number of BOM components

Bullet point  REP :  Sales reps

Bullet point  SFI :  Max. no. entered inv. elts

Bullet point  SFIV :  Max. no. valued inv. elts

Bullet point  SFL :  No. invoice elts distributed

Bullet point  SIH :  Number of sales invoice lines

Bullet point  SPR :  Maximum sales charges/discount

Bullet point  STC :  Sales statistical groups

Bullet point  STI :  Product statistical groups

Bullet point  SVA :  Max no. taxes by document

Localization

Bullet point  KBE :  Belgian localization

Bullet point  KPO :  Portuguese Localization

Bullet point  KSP :  Spanish localization

Bullet point  KSW :  Swiss localization

Bullet point  KUK :  Localization united kingdom

Bullet point  KUS :  Localization USA

Other activity code:

  • MAXPD: Maximum period (companies)

General parameters

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

Accounting

Bullet point  ACESIMTRC (defined at level User) : Simulated entry generation

Bullet point  LETAUTCNO (defined at level Company) : Auto match inv ->credit note

Customer Support

Bullet point  DATREFCON (defined at level Company) : Service contract invoice date

Localisations

Bullet point  SIIABTYP (defined at level Site) : SII credit memo type

Common Data

Bullet point  CTLOPPCOD (defined at level Folder) : Project code control

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

Bullet point  DENINVSDD (defined at level Company) : SDD payment type

Bullet point  DEPMGTMOD (defined at level Company) : Discount management mode

Bullet point  EXDSALINV (defined at level Legislation) : Exceptions in sales invoice

Bullet point  FRADGI (defined at level Company) : French fiscal regulation

Bullet point  GAUKIK3 (defined at level Company) : Revenue accruals sales inv.

Bullet point  INVCAN (defined at level Legislation) : Cancellation invoice

Bullet point  NOTATI (defined at level Site) : Price / Amount +tax / -tax

Bullet point  OSTCTL (defined at level Company) : Cus. author. credit ctrl level

Bullet point  OSTDRAFT (defined at level Company) : Customer credit notes P/R amt.

Bullet point  PJTSNGDOC (defined at level Company) : Single-project document

Bullet point  SALDSPVOU (defined at level Company) : Volume unit to affect

Bullet point  SALDSPWEU (defined at level Company) : Weight units to affect

Bullet point  SDDMGT (defined at level Company) : SDD management

Bullet point  SDDPRN (defined at level Company) : Printing SDD information

Bullet point  SIVNULL (defined at level Site) : Lines set to zero prohibited

Bullet point  SIVSUP (defined at level Site) : Delete invoices

Bullet point  VATRND (defined at level Company) : Sales tax rounding

Bullet point  VENENDDAT (defined at level User) : Sales end date

Bullet point  VENSTRDAT (defined at level User) : Sales start date

Acc Payable/Acc Receivable

Bullet point  DENINVPAY (defined at level Company) : Check payment type

Sales

Bullet point  APPSOH (defined at level Company) : Order signature management

Bullet point  CRENOTTHR (defined at level Company) : Control threshold

Bullet point  CTLCRENOT (defined at level User) : Credit memo invoice control

Bullet point  CTLTAX (defined at level Company) : Tax code control

Bullet point  DACMANSAL (defined at level Site) : Default price reason - manual

Bullet point  FOCPRI (defined at level Site) : Free product valuation

Bullet point  GRPNBRFOC (defined at level Site) : Grouped prices : free

Bullet point  GRPPRI (defined at level Site) : Group price management

Bullet point  LINREP (defined at level Site) : Sales rep on detail

Bullet point  OSTLND (defined at level Company) : Loan in order total

Bullet point  OSTORD (defined at level Company) : On order in order total

Bullet point  SALREN (defined at level Site) : Require price reasons

Bullet point  SALRND (defined at level Site) : Round unit price

Bullet point  SALTEXINV (defined at level Site) : Invoice text position

Bullet point  SALTEXLIN (defined at level Site) : Product text tracking

Bullet point  SCDTUNL (defined at level User) : Authorization to unlock order

Bullet point  SDACLOK (defined at level User) : Non block ctrl price,profit,qt

Bullet point  SIHVALLIG (defined at level Company) : Line invoice valuation

Bullet point  SPRIMOD (defined at level User) : Modify prices/discounts

Bullet point  UPDCUR (defined at level Site) : Modify currency

Bullet point  UPDPRISAL (defined at level Site) : Default price reason - base

Bullet point  WRNEXETAX (defined at level Company) : EXETAX use warning

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

Other parameters:

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 sequence numbers guarantee 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.

For a company to use electronic signature, the SAFT sequence number must be specified as a sequence number subjected to electronic signature.

To assign the VCS sequence number to the sales invoices, it is necessary to add the VCS number to the sequence number assignments (Common data module) and to set field Manual to NO. The VCS number is never entered but automatically validated upon creation of the sales invoice.

Accounting interface

Default dimensions

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

(defined at level Company)

Bullet point  SIH (All companies ) : Sales Invoice Header

Bullet point  SID (All companies ) : Sales Invoice line

  • SIV (All companies): Sales invoicing element
  • STKFAC (All companies): Invoicing stock movement

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 :

Bullet point  Post

Bullet point  Open items

Bullet point  Payment

Bullet point  Stock txn modification

Bullet point  Issuing

Entry Transactions

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

Bullet point  GESSLI : Invoice transaction

Bullet point  GESSLA : Credit memo transaction

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.

Miscellaneous prerequisites

Miscellaneous tables

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

Bullet point  Miscellaneous table number 8 : Credit memo reasons

Bullet point  Miscellaneous table number 9 : Stock movement groups

Tables to be completed

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

Table

Table description

TABSIVTYP [TSV]

Customer invoice type table

GTYPACCENT [GTE]

Document types

PRICSTRUCT [PRS]

Price structure (cust/supp)

SFOOTINV [SFI]

Invoicing elements

TABVAC [TVC]

Tax determination table

TABVAT [TVT]

Tax code table

TABPAYTERM [TPT]

Payment term table

TABDEPAGIO [TDA]

Early discount/late charge table

TABCUR [TCU]

Currency table

Invoice type

The definition of the invoice type (see the Invoice type documentation) is used to specify if the document has the invoice, credit memo or proforma type.
It is at this level that the automatic journal (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 SIHI automatic 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.

Sequence number assignment

  • A specific sequence number for the automatic numbering of the created entries (see Sequence number definition) can be defined at the level of the Document types. If no sequence number is specified at the level of the journal type, it is the sequence number specified at the level of the sequence number assignment option used (see the Sequence number assignment).
  • If the document type is not specified in the invoice type, the sequence number used is the one indicated at the level of the document type defined in the automatic journal used.
  • If the document type is not specified for the invoice type and the document type of the automatic journal does not have a sequence number defined, the program uses the sequence number defined in the sequence number assignment table.

Structure code

This code is used to determine the sales conditions managed at the level of each line of the order, of the invoice... in the form of the different Discounts and Charges fields. This structure code is unique and does not depend on the customer. A default structure code is supplied during the installation and it is possible to create the structure code adapted to the local requirements. (see the Price list structure documentation).

Fiscal year and Period

The invoice date is controlled with respect to the periods and fiscal years tables: the fiscal year and the period must be open.

TPT activity code

This activity code concerns the payment of the VAT. It is used to set up the payment condition in order to decide on which open items the VAT is paid.

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 the Sales or A/P - A/R accounting modules) whose date is strictly higher than the end date of the period where the current document is being entered.

Electronic signature

Warning An invoice can be validated only if the previous invoices have been signed.

Tables used

The following tables are implemented by the function :

Table

Table description

BPARTNER [BPR]

Business partner

BPCUSTMVT [MVC]

Customer transactions

BPCUSTOMER [BPC]

Customers

BPDLVCUST [BPD]

Ship-to customer

CONTSERV [CON]

Service contract

CPTANALIN [CAL]

Analytical accounting lines

FACILITY [FCY]

Sites

GACCCODE [CAC]

Accounting codes

GACCOUNT [GAC]

Accounts

GTYPACCENT [GTE]

Document types

HDKTASKINV [HDI]

Consumptions to be invoiced

ITMBPC [ITU]

Customer product

ITMCATEG [ITG]

Product category

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

ITMMVT [ITV]

Product-site totals

ITMSALES [ITS]

Products - sales

ITMWRH [ITW]

Products-warehouses

LPN [LPN]

License plate number

ORDERS [ORD]

WIP

PRICSTRUCT [PRS]

Price structure (cust/supp)

SALESREP [REP]

Sales rep

SCHGD [SGD]

Stock change line

SCHGH [SGH]

Stock change header

SDELIVERY [SDH]

Delivery header

SDELIVERYD [SDD]

Delivery detail

SERREQUEST [SRE]

Service requests

SFOOTINV [SFI]

Invoicing elements

SINVOICE [SIH]

Sales invoices

SINVOICED [SID]

Sales invoice detail

SINVOICEV [SIV]

Costing sales invoice

SORDER [SOH]

Sales orders - header

SORDERP [SOP]

Sales orders - price

SORDERQ [SOQ]

Sales orders - quantities

SPRICLINK [SPK]

Sales price list search

SPRICLIST [SPL]

Customer price lists

SRETURND [SRD]

Sales return detail

STOALL [STA]

Allocations

STOCK [STO]

Stock

STOJOU [STJ]

Stock journal

STOLOT [STL]

Lot numbers

STOSER [STS]

Serial numbers

SVCRFOOT [SVF]

Sales document - footer el.

SVCRVAT [SVV]

Sales document - tax

TABCONTAINER [TCTR]

Container

TABCUR [TCU]

Currency table

TABPRTMOD [TPM]

Print template table

TABSIVTYP [TSV]

Customer invoice type table

TABUNIT [TUN]

Table of units of measure

WAREHOUSE [WRH]

Warehouses