Import/export template > Module Sales > Import/export template SIHIMPNCAL (Sales Invoice (imp no calc.))
 |
 |
Sales Invoice (imp no calc.)
Use this template to import sales invoices without triggering the invoice footer calculation. The invoice footer is imported from the file and is not recalculated.
Tax controls are not performed irrespective of the value of the CTLTAX - Tax code control parameter (VEN chapter, VAT group).
Tables used
This template can be used in import and export modes. The data is updated in the following tables :
| Table |
Table description |
|---|---|
|
BPARTNER [BPR] |
|
|
BPCUSTMVT [MVC] |
Customer transactions |
|
BPCUSTOMER [BPC] |
|
|
BPDLVCUST [BPD] |
|
|
CONTSERV [CON] |
|
|
CPTANALIN [CAL] |
Analytical accounting lines |
|
FACILITY [FCY] |
|
|
GACCCODE [CAC] |
|
|
GACCOUNT [GAC] |
|
|
GTYPACCENT [GTE] |
|
|
HDKTASKINV [HDI] |
Consumptions to be invoiced |
|
ITMBPC [ITU] |
|
|
ITMCATEG [ITG] |
|
|
ITMFACILIT [ITF] |
|
|
ITMMASTER [ITM] |
|
|
ITMMVT [ITV] |
Product-site totals |
|
ITMSALES [ITS] |
|
|
ITMWRH [ITW] |
|
|
PRICSTRUCT [PRS] |
|
|
SALESREP [REP] |
|
|
SDELIVERY [SDH] |
|
|
SDELIVERYD [SDD] |
Delivery detail |
|
SERREQUEST [SRE] |
|
|
SFOOTINV [SFI] |
|
|
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 |
|
SPRICLINK [SPK] |
Sales price list search |
|
SPRICLIST [SPL] |
Customer price lists |
|
SRETURND [SRD] |
Sales return detail |
|
STOCK [STO] |
Stock |
|
STOJOU [STJ] |
Stock journal |
|
STOLOT [STL] |
Lot numbers |
|
SVCRFOOT [SVF] |
Sales document - footer el. |
|
SVCRVAT [SVV] |
Sales document - tax |
|
TABCUR [TCU] |
|
|
TABPRTMOD [TPM] |
|
|
TABSIVTYP [TSV] |
|
|
TABUNIT [TUN] |
|
|
WAREHOUSE [WRH] |