• Prerequisite
• Mandatory fields in the template
• Local menus
• Tables used

• One for the header file SINVOICEV;
• One for the detail file SINVOICED.

Import limitations in Modification mode

When importing a detail line, the system analyzes whether the line is a new line (creation) or an existing line (modification). To that end, the system uses the identifying fields of the line. These fields are: the line number assigned automatically (SIDLIN) and the product reference (ITMREF).

• If SIDLIN is set up in the template and if it is entered and different from 0, this field or ITMREF is used.
  If there is a line with the SIDLIN value, this line is modified. Otherwise, a new line is created.
• If SIDLIN is not set up or if it is set to 0, the ITMREF field is used.
  If there is such a line with a value corresponding to the value contained in the field ITMREF, this line is modified. Otherwise, a new line is created.

Invoice import in modification mode

The import of invoice in modification does not update stocks. The system rejects the import if there are imported lines in modification mode with stock update. The message: 'Invoice number: Product code: Invoice with unauthorized stock movement' is displayed in the log file.

When importing an invoice with a template used to calculate the invoice footer, the invoice elements are imported in the INVDTAAMT fields of the SINVOICEV table.

Import with stock movement

There are two different ways of importing the kits and BOMs on an invoice:

• The LINTYP field is not present in the template. In this case, it will be necessary to import only the parent product (the components not being considered as belonging to the kit or BOM but processed like classic products). The import of the parent product then leads to the automatic generation of all the components defined by the first BOM code. The components with the Option or BOM code type are also generated for the first option and the first variant.
• The LINTYP field is contained in the template. In this case, the import of the parent product does not trigger the automatic generation of the components. The component lines must be imported by specifying the value of the corresponding LINTYP. You can thus specify the selected components for kits or BOMs containing options or variables.

Import of texts

When necessary, it is possible to import the texts into the invoice header, footer and line. This can be set up in the import template by using the global variable GIMP (in the template the fields *71... must be mentioned).

Import of dimension types on the line

To import the dimension types of a document line, it is necessary to add an additional level to enter the common table containing the analytical information on the line (CPTANALIN).
See SIHFL import template.