Automatic Order Invoicing - 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
LOKORD (defined at level Site) : Order blocked if no prepayment
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
SCDTUNL (defined at level User) : Authorization to unlock order
SIVTYP (defined at level Site) : User invoice type
TRSFAC (defined at level Site) : Auto invoice transaction
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
- Only totally or partially allocated orders are considered by the automatic order invoicing function. Shortages are not considered. Orders with products which are not managed in stock are invoiced as soon as there are quantities remaining to be invoiced on their lines.
- To be able to carry out the automatic invoicing of orders, you need to define 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.
- When the approval circuit is managed (APPSOH - Order approvals management parameter), the sales orders with direct invoicing following the established approval rules are not taken into account as long as they are not Totally signed.
- When theCTLPERINV - Invoice date control Period(TC chapter, INV group) parameter is set to 'Yes', the creation of invoice is prohibited when there is at least one document (invoice, credit memo, debit or credit note of the Purchase or Customer A/P - A/R accounting modules) whose date is strictly later than the end date of the period where the current documents are being entered.
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] |
|
|
ORDERS [ORD] |
WIP |
|
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 |
|
STOALL [STA] |
Allocations |
|
STOCK [STO] |
Stock |
|
STOLOT [STL] |
Lot numbers |
|
STOSER [STS] |
Serial numbers |
|
TABCHANGE [TCH] |
Currency rate table |
|
TABCOUAFF [TCA] |
|
|
TABCUR [TCU] |
|
|
TABUNIT [TUN] |