Use this template to import expense notes from the Sage SIRH product.
In addition to the generic error messages, the following messages can appear during the entry :
Employee not defined in the management of employees.
Expenses not defined in the management of expenses.
Dimension not defined in the management of analytical dimensions.
It was not possible to determine a VAT code via the VAT amount and no default VAT code is defined in miscellaneous table 552.
No user parameter "REFNUM" is linked to this employee ID.
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] | |
LPN [LPN] | |
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 |
TABCONTAINER [TCTR] | |
TABCUR [TCU] | |
TABPRTMOD [TPM] | |
TABSIVTYP [TSV] | |
TABUNIT [TUN] | |
WAREHOUSE [WRH] |