Automatic contract invoice generation - Implementation
Prerequisites
Activity codes
The following activity codes (sorted by type) may have an impact on the way the function operates :
MAXPD :
Maximum period (companies)
General parameters
The following general parameters may change the way the function is working :
Common Data
CTLPERINV (defined at level Company) : Invoice date control Period
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)
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
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
The prerequisite conditions for this function are listed below.
The service contracts created from an order or directly created can be invoiced.
The service contracts are created in an automatic fashion during the creation of an order (standard order or order with direct invoicing). A contract is created for each product ordered that possesses a service contract number in its product record. This contract corresponds to a template contract. The creation of this contract leads to the automatic completion of the order line. If the quantity ordered is greater than 1, it can lead to the creation of more than one contracts (on the request of the user). They can also be created directly using the service contracts management function.
A service contract is characterized by an annual royalty basis (corresponding to the net price of the order line if the contract has been created from an order). This annual royalty basis is based on the invoicing frequency to calculate the open item amount of the contract to be invoiced. The frequency and notice of invoicing is used in the calculation of the next invoice issue date and the next invoice date. It is these elements that are used at the time of invoicing a service contract.
All the contract corresponding to the different criteria assigned at the time of the automatic invoicing launch can be invoiced. This invoicing is dependent on the invoicing method chosen during the start of the automatic invoicing. The invoicing method in the customer record is not used in this context. In effect, given that on the same order it is possible to have classic products and service contract type products at the same time, the same invoicing method cannot be used for both.
The invoicing elements entered at the level of the order at the origin of the service contract are not taken into account in the contract invoices. They are considered to have a normal cycle of invoicing (order-invoice or order-shipment-invoice). On the other hand, they can be assigned manually in the contract itself.
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] |
|
|
CONTAMT [CAM] |
Annual databases |
|
CONTREW [CRE] |
Contract renewals |
|
CONTSERV [CON] |
|
|
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] |
|
|
ITMFACILIT [ITF] |
|
|
ITMMASTER [ITM] |
|
|
ITMMVT [ITV] |
Product-site totals |
|
ITMSALES [ITS] |
|
|
PERIOD [PER] |
Periods |
|
SINVOICE [SIH] |
Sales invoices |
|
SINVOICED [SID] |
Sales invoice detail |
|
SINVOICEV [SIV] |
Costing sales invoice |
|
SORDER [SOH] |
|
|
SORDERP [SOP] |
Sales orders - price |
|
SORDERQ [SOQ] |
Sales orders - quantities |
|
TABCHANGE [TCH] |
Currency rate table |
|
TABCOUAFF [TCA] |
|
|
TABCUR [TCU] |
|
|
TABUNIT [TUN] |