Customer intercompany invoices - Implementation
Prerequisites
Activity codes
The following activity codes (sorted by type) may have an impact on the way the function operates :
Dependent activity codes
These codes are never entered in folder management, because their value is calculated :
CASIN (Treasury interface), CSL1 (Consolidation or pre-conso.), DKS (Electronic signature), EINVF (Electronic factoring invoice), FEE2 (Fee declaration), KAG (Argentinean localization), PBDPO (Payment balance declaration), VATTN (VAT declaration no.).
Functional
BADBT :
Bad debt management
BE281 :
Belgian 281.5 form
CCN :
Concessions
CFOM :
Cash forecast management
CSL :
Consolidation
CTSW :
Control system
DAS :
DAS2
DEB :
EU exchange declaration
EFAT :
EFAT connector
EINV :
Electronic invoice
ELINV :
Electronic invoice ZAF
EORI :
EORI identification
ESD :
European services declaration
FAS :
Asset folder
FCT :
Factoring management
FUP :
Reminder and late payment mana
INTCO :
Intercompany transactions
INVCA :
Cancellation invoice
LND :
Loan management
LTA :
Local taxing
MAXPD :
Maximum period (companies)
MURAN :
Spanish payroll
PJM :
Project management
PPT :
Prospect management
PRCSL :
Pre-consolidation
PTX :
Regional taxes
REX :
REX Customs System
S1099 :
1099
SDD :
SDD management
SEPP :
Credit card integration
SMI :
Integrale migration
SVC :
Periodic accruals
WRH :
Warehouse management
WTHMG :
Withholding tax management
Sizing
ANA :
No. of analytical dimensions
NBCOA :
No. of charts of accounts
PFI :
Max no. invoicing elements
REC :
Customer sales reps
SFI :
Max. no. entered inv. elts
SIH :
Number of sales invoice lines
STC :
Sales statistical groups
STS :
Purchasing statistical groups
Localization
KBE :
Belgian localization
KDE :
German localization
KFR :
French localization
KIT :
Italian localization
KPL :
Polish localization
KPO :
Portuguese Localization
KRU :
Russian localization
KSP :
Spanish localization
KSW :
Swiss localization
KUS :
Localization USA
KZA :
South-African localization
General parameters
The following general parameters may change the way the function is working :
Accounting
ACESIMTRC (defined at level User) : Simulated entry generation
LETAUTCNO (defined at level Company) : Auto match inv ->credit note
Common Data
CTLPERINV (defined at level Company) : Invoice date control Period
FRADGI (defined at level Company) : French fiscal regulation
GAUKIK1 (defined at level Folder) : Revenue accruals customer inv.
SIVNULL (defined at level Site) : Lines set to zero prohibited
SIVSUP (defined at level Site) : Delete invoices
TRSENDDAT (defined at level User) : A/P-A/R accounting end date
TRSSTRDAT (defined at level User) : A/P-A/R accounting start date
Acc Payable/Acc Receivable
INTCPYINV (defined at level Company) : Intercompany invoices
TYPINVCUS (defined at level Company) : Customer invoice type
WRNINVOICE (defined at level Site) : Invoice no. warning
Sequence numbers
The sequence numbers used to number the documents managed by this function are :
WRK : Workflow
WRK : Workflow
The sequence number assignment function defines the sequence number which is used
To assign the VCS sequence number to the customer BP invoices, it is necessary to add the 'VCS number' to the sequence number assignments (Common data module) and to set field 'Manual' to 'NO'. The VCS number is never entered but automatically validated upon creation of the customer BP invoice.
Accounting interface
Automatic journals
The following automatic journals are used in the posting processes associated with the function :
BPCIN : Customer Invoice- A/R
Authorizations
This function is object managed. The creation, modification, and deletion operations can be activated or deactivated for a given user. Filters by roles can also be associated with this function.
As data is linked to a site, a filter per site can be activated.
The following options can be activated or deactivated for each user :
Invoice validation
Open items
Miscellaneous prerequisites
Tables to be completed
The following tables are used by the function. Their content must be updated if necessary :
|
Table |
Table description |
|---|---|
|
TABSIVTYP [TSV] |
Chart of accounts and analytical chart of accounts
The general accounts, link accounts, natures and analytical dimensions must be defined.
CTLPERINV - Period invoice date control parameter
When theCTLPERINV - Invoice date control Period parameter(TC chapter, INV group) is set to 'Yes', the creation of the 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) which date is strictly higher than the end date of the period where the current document is being entered.
Tables used
The following tables are implemented by the function :
|
Table |
Table description |
|---|---|
|
ACCES [ACC] |
Access by user |
|
ATABDIV [ADI] |
|
|
BID [BID] |
Bank ID statement |
|
BPADDRESS [BPA] |
Addresses |
|
BPARTNER [BPR] |
|
|
BPCINVLIG [SIL] |
Customer invoice lines |
|
BPCINVLIGA [SIA] |
Customer analytical line |
|
BPCUSTMVT [MVC] |
Customer transactions |
|
BPCUSTOMER [BPC] |
|
|
BPSUPPLIER [BPS] |
|
|
CAAUZ [CAZ] |
|
|
CACCE [CCE] |
|
|
CADSP [DSP] |
|
|
COMPANY [CPY] |
|
|
FACILITY [FCY] |
|
|
FISCALYEAR [FIY] |
|
|
GACCCODE [CAC] |
|
|
GACCDUDATE [DUD] |
Open items |
|
GACCOUNT [GAC] |
|
|
GAUTACE [GAU] |
|
|
GAUTACED [GAD] |
|
|
GAUTACEF [GAG] |
Automatic journal formulas |
|
GDIAACC [GDA] |
|
|
GJOUCOA [JCO] |
Journals - Chart of accounts |
|
GJOURNAL [JOU] |
|
|
GTYPACCENT [GTE] |
|
|
PERIOD [PER] |
Periods |
|
SINVOICE [SIH] |
Sales invoices |
|
TABCOUNTRY [TCY] |
|
|
TABCUR [TCU] |
|
|
TABSIVTYP [TSV] |
|
|
TABUNIT [TUN] |
|
|
TABVACBPR [TVB] |
|
|
TABVAT [TVT] |