Automatic Tranfer 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

  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. It is also necessary that this invoice type uses 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.

Compliance with the French fiscal rules

If the user wants to be conform to 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
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
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]	Sequence No assignments
TABCUR [TCU]	Currency table
TABUNIT [TUN]	Table of units of measure