Automatic Tranfer 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
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 inter-company stock transfers, it is necessary to have defined at least one invoice type. The invoice type must use an automatic sequence number.
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.
In addition, it is necessary to have defined an inter-site customer for each purchase site entered on a transfer advice note and an inter-site supplier for each sales site entered on the advice note. The destination storage site must be entered (as a receipt site) on a delivery address for a customer associated with the sales site.
When the CTLPERINV - Period invoice date control parameter (TC chapter, INV group) is set to 'Yes', the generation of invoices is prohibited if there is at least one document (invoice, credit memo, debit or credit note of the Sales or Customer A/P - A/R accounting modules) which date is strictly greater than the end date of the period on which the 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] |
|
ITMFACILIT [ITF] |
|
ITMMASTER [ITM] |
|
ITMMVT [ITV] |
Product-site totals |
ITMSALES [ITS] |
|
PERIOD [PER] |
Periods |
SCHGD [SGD] |
Stock change line |
SCHGH [SGH] |
Stock change header |
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] |