Automatic Contract Invoice Generation - Implementation

Prerequisites

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

  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 automatically upon order creation (standard order or order with direct invoicing). A contract is created for each ordered product associated with 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 larger than 1, it can lead to the creation of more than one contracts (upon user's request). They can also be created directly using the service contracts management function.

A service contract is characterized by an annual fee base (corresponding to the net price of the order line if the contract has been created from an order). Based on the invoicing frequency, this annual fee allows the calculation of the open item amount of the contract to be invoiced. The frequency and invoicing notice 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 of a service contract.

All the contracts 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 at the start of the automatic invoicing. The invoicing method in the customer record is not used in this context. As a matter of fact, given that it is possible to have classic products and service contract type products at the same time on the same order, 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 as having a normal invoicing cycle (order-invoice or order-shipment-invoice). On the other hand, they can be assigned manually in the contract itself.

Compliance with the French fiscal rules

If you want to be compliant with the French fiscal rule (DGI), the CTLPERINV - Control period invoice date parameter must have the following value: Yes.
In this case:

• The generation of invoices is prohibited if there is at least one document (invoice, credit memo, debit or credit note of one of the modules Purchaseand A/P - A/R accounting) which date is strictly greater 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
BPARTNER [BPR]	Business partner
BPCUSTMVT [MVC]	Customer transactions
BPCUSTOMER [BPC]	Customers
BPDLVCUST [BPD]	Ship-to customer
COMPANY [CPY]	Company
CONTAMT [CAM]	Annual databases
CONTREW [CRE]	Contract renewals
CONTSERV [CON]	Service contract
FACILITY [FCY]	Sites
FISCALYEAR [FIY]	Fiscal years
GACCCODE [CAC]	Accounting codes
GACCDUDATE [DUD]	Open items
GACCOUNT [GAC]	Accounts
GAJOUSTA [JST]	Journals - reports per period
GAUTACE [GAU]	Automatic journals
GAUTACED [GAD]	Automatic journals (lines)
GJOURNAL [JOU]	Journal codes
GTYPACCENT [GTE]	Document types
ITMFACILIT [ITF]	Products-sites
ITMMASTER [ITM]	Products
ITMMVT [ITV]	Product-site totals
ITMSALES [ITS]	Products - sales
PERIOD [PER]	Periods
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
TABCHANGE [TCH]	Currency rate table
TABCOUAFF [TCA]	Sequence No assignments
TABCUR [TCU]	Currency table
TABUNIT [TUN]	Table of units of measure