Automatic Service Invoice Generation - Implementation
Prerequisites
General parameters
The following general parameters may change the way the function is working :
Customer Support
CLOINV (defined at level Folder) : Service request invoicing
INVSREMOD (defined at level Site) : Order invoice method
INVSREUOM (defined at level Site) : Order invoice unit
Common Data
CTLPERINV (defined at level Company) : Invoice date control Period
FRADGI (defined at level Company) : French fiscal regulation
NOTATI (defined at level Site) : Price / Amount +tax / -tax
OSTCTL (defined at level Company) : Cus. author. credit ctrl level
OSTDRAFT (defined at level Company) : Customer credit notes P/R amt.
Sales
DACMANSAL (defined at level Site) : Default price reason - manual
OSTLND (defined at level Company) : Loan in order total
OSTORD (defined at level Company) : On order in order total
SALTEXINV (defined at level Site) : Invoice text position
SALTEXLIN (defined at level Site) : Product text tracking
SIVTYP (defined at level Site) : User invoice type
Accounting interface
Default dimensions
The default dimensions sections assignment is performed through the following codes :
(defined at level Company)
SIH (All companies ) : Sales Invoice Header
SID (All companies ) : Sales Invoice line
Authorizations
An authorization can be granted for this function to limit the processes to a company or a site.
Miscellaneous prerequisites
To be able to carry out the automatic invoicing of service requests, at least one invoice type must have been defined. The invoice type must use an automatic sequence number.
The CLOINV - Service request invoicing parameter (HDK chapter, INV group) must be set to 'Yes’. This setup can neutralize the service request invoicing.
The entry of the invoice date is submitted to an existence check in the period table and the fiscal year table. The fiscal year and the period must be open.
When the CTLPERINV - Invoice date control Period parameter (TC chapter, INV group) is set to ‘Yes’, the generation of invoices 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 documents are generated.
Tables used
The following tables are implemented by the function :
|
Table |
Table description |
|---|---|
|
BPARTNER [BPR] |
|
|
BPCUSTMVT [MVC] |
Customer transactions |
|
BPCUSTOMER [BPC] |
|
|
BPDLVCUST [BPD] |
|
|
COMPANY [CPY] |
|
|
FACILITY [FCY] |
|
|
FISCALYEAR [FIY] |
|
|
GACCCODE [CAC] |
|
|
GACCDUDATE [DUD] |
Open items |
|
GACCOUNT [GAC] |
|
|
GAJOUSTA [JST] |
Journals - reports per period |
|
GAUTACE [GAU] |
|
|
GAUTACED [GAD] |
|
|
GJOURNAL [JOU] |
|
|
GTYPACCENT [GTE] |
|
|
HDKTASKINV [HDI] |
Consumptions to be invoiced |
|
ITMFACILIT [ITF] |
|
|
ITMMASTER [ITM] |
|
|
ITMMVT [ITV] |
Product-site totals |
|
ITMSALES [ITS] |
|
|
PERIOD [PER] |
Periods |
|
SERREQUEST [SRE] |
|
|
SINVOICE [SIH] |
Sales invoices |
|
SINVOICED [SID] |
Sales invoice detail |
|
SINVOICEV [SIV] |
Costing sales invoice |
|
TABCHANGE [TCH] |
Currency rate table |
|
TABCOUAFF [TCA] |
|
|
TABCUR [TCU] |
|
|
TABUNIT [TUN] |