Import/export template > Module Sales > Import/export template SIRHABS (Sales Invoice (imp no calc.)) 

Use this template to import into the time entry the employees' absences entered in the Sage SIRH product.

Prerequisites

Mandatory fields in the template

The mandatory fields are:

  • Employee ID
  • Absence event code
  • Start/end date
  • Number of days

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

ID number does not exist

Employee not defined in the management of employees.

Event nature does not exist

Code not defined in the management of natures of events.

The ID number approving times does not refer to a user

No user parameter "REFNUM" is linked to this employee ID.

Employee not present on ../../.. ../../..

The employee is not present in the company during the absence period.

Nonexistent site

The connection site of the employee does not exist. It corresponds to the site of the employee's arrival/departure record.

Import not completed: adjustment already entered for this period

This message is displayed if the update is not authorized at the template's level and if the time adjustment is already entered for the employee on this period.

Import not completed: time already entered for this period

This message is displayed if the update is not authorized at the template's level and if the time entry already exists for the employee on this period.

No payroll defined on this date

No extraction period is defined on the absence period.

Period not covered upon entry

The extraction period that includes the absence period is not authorized for entry.

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]

Business partner

BPCUSTMVT [MVC]

Customer transactions

BPCUSTOMER [BPC]

Customers

BPDLVCUST [BPD]

Ship-to customer

CONTSERV [CON]

Service contract

CPTANALIN [CAL]

Analytical accounting lines

FACILITY [FCY]

Sites

GACCCODE [CAC]

Accounting codes

GACCOUNT [GAC]

Accounts

GTYPACCENT [GTE]

Document types

HDKTASKINV [HDI]

Consumptions to be invoiced

ITMBPC [ITU]

Customer product

ITMCATEG [ITG]

Product category

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

ITMMVT [ITV]

Product-site totals

ITMSALES [ITS]

Products - sales

ITMWRH [ITW]

Products-warehouses

LPN [LPN]

License plate number

PRICSTRUCT [PRS]

Price structure (cust/supp)

SALESREP [REP]

Sales rep

SDELIVERY [SDH]

Delivery header

SDELIVERYD [SDD]

Delivery detail

SERREQUEST [SRE]

Service requests

SFOOTINV [SFI]

Invoicing elements

SINVOICE [SIH]

Sales invoices

SINVOICED [SID]

Sales invoice detail

SINVOICEV [SIV]

Costing sales invoice

SORDER [SOH]

Sales orders - header

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]

Container

TABCUR [TCU]

Currency table

TABPRTMOD [TPM]

Print template table

TABSIVTYP [TSV]

Customer invoice type table

TABUNIT [TUN]

Table of units of measure

WAREHOUSE [WRH]

Warehouses