Import/export template >  Module Sales >  Import/export template SDH (Shipments)  

Index

This function is used to import packing slips. This import only works in creation mode. The packing slip imports are not managed in modification and deletion modes.

The imported packing slips are of direct type or related to orders or delivery requests. They can be imported under a 'Non-validated', 'Validated' or 'Invoiced' status.

Import of a 'Non-validated' packing slip (CFMFLG field not present in the template or present but set to 'Non-validated')

Component lines are all allocated in detail or contain shortages if the product management allows it (negative stock authorized). The way the lines are allocated depends on the information contained in the import template. Actually, if the template only contains the tables of the packing slips, the detailed allocation will be automatically performed by the system while complying with the allocation and issue rules that are linked to the product. If a shortage is reported and authorized for the product, it will not specify the characteristics of the stock shortage.

In this context, it is possible to impact the allocation by importing the following fields from the table of the delivery lines:

LOT

This field is used to filter exclusively a specific lot or a group of lots (use of the ? and * wildcards) if the product is managed by lot.

STA

This field is used to filter exclusively a specific status or a group of statuses (use of the ? and * wildcards).

LOC

This field is used to consider in priority a location or a a group of locations (use of the ? and * wildcards). If no stock is found on these locations, the system will normally apply the allocation rule.

If the import template contains an additional hierarchy based on the elements of the STOJOU table, the system will exactly follow the information given to carry out the detailed allocation. In case of inconsistency between the allocation request specified in the import file and the stock, the system will reject the packing slip to be imported. At this level in the hierarchy, certain pieces of information are mandatory:

The quantity

It can be expressed in two ways. The stock unit quantity (QTYSTU field) or packing unit quantity (QTYPCU field). If the quantity is expressed in packing unit, the packing unit must always be specified (PCU field). In any case, the sum of the quantities of the allocation lines needs to be equal to the quantity delivered on the delivery line.

Stock characteristics

Based on the types of imported products, the template must contain at least all the characteristics of the imported products (lot, sub-lot, serial number, location). For instance, if one of the imported products is managed by lot, the template needs to contain the LOT field.

The status

It is not mandatory. On the other hand, if it is contained in the template, it will be strictly used. If it is not contained in the template, the system will exploit the issue rule of the product to choose a status.

If the product authorizes negative stock and the quantity to be issued is not available, a shortage will be generated on the stock characteristics mentioned in the import file.

Import of delivery lines linked to order lines or delivery requests.

The following fields will have to be added to the import template:

• For order lines, the SOHNUM and SOPLIN fields of the delivery line file need to be present in the import template.
• For delivery requests, the SOHNUM, SOPLIN and SOQSEQ fields of the delivery line file need to be present in the import template.

Import of delivery not linked to an order (Update 8.0.0 and higher)

• The delivery type is updated from the delivery type specified in the file.
  When the category is also specified in he filed, the import is rejected if this category is not consistent with the delivery type entered.
• If the delivery type is not specified in the import file but the category is, the delivery type is loaded from the one set up by the parameter linked to the category:
• SDHTYPLND - Loan delivery type
• SDHTYPNOR - Normal delivery type.
• SDHTYPSCO - Subcontract delivery type
• If no delivery type and no category are entered in the import file, these fields will be loaded as follows:
• Category: 'Normal'
• Delivery type: this parameter is the first delivery type (in the list) respecting the category, site and legislation constraints, which is taken into account.

Delivery import linked to an order

The order is updated automatically.
Importing an order delivery is not possible when the customer is locked, even when the order is not (while with interactive order deliveries, as long as the order is not locked, the delivery is authorized).

Import of a delivery linked to one or several orders

The detailed allocation will be carried out as follows, if the original order line is itself allocated in detail (if the order is globally allocated or not allocated at all, the allocation will be carried out like in direct delivery import):

• If the delivery import template does not have any information related to the stock identification, the detailed allocation of the order line will be moved down to the delivery line (as in the interactive mode).
• If the import template has information on the exclusive or priority filter of the delivery line, this information will not be exploited in this context. The detailed allocation of the order line will be moved down to the delivery line.
• If the import template has the details of the allocation to be carried out (STOJOU table), the allocation considered for the delivery will be the allocation described in the import template. The allocations present on the order are de-allocated.

Import of a packing slip in the 'Validated' status (CFMFLG field present in the template and set to 'Validated')

The lines contained in the packing slip generate a stock movement or pending movement when the stock is not available and if negative stocks are authorized for the product. These packing slips can be invoiced later on. Like for the import of non-validated packing slips, stock transactions will be generated from the allocation and issue rules if the import template does not contain the stock transaction file. It remains possible in this context to use the exclusive and preferential filters of the delivery line file in order to determine the choice of the stock detail (same operation as for the allocation). If the import template contains the details of the issued stock, the system will exactly apply the information of the import template to perform the stock transactions. The constraints are similar to those described in the detailed allocation upon import of the non-validated packing slips.

It is also possible to import validated packing slips linked to order lines or delivery requests by specifying the link in the import template. If order lines are allocated in detail, the allocations recovery process for generating issue movements is the same than when transferring allocations to a non-validated delivery.

Import of a packing slip with the 'Invoiced' status (INVFLG field present in the template and set to 'Invoiced')

This is considered as an import for statistical purposes. No stock movement is carried out. For this type of import, the STOJOU file does not need to be mentioned in the template.

Import of a delivery containing sales kits 

In any case, the imported information is considered to be accurate since the issue transaction is carried out or is about to be carried out. The kit or the BOM will not be controlled in import. If the delivery is linked to an order, the latter will be updated normally.

Import of texts linked to packing slips

Use GIMP variables:

• from 71..78, that contain the header text of the packing slip.
• from 81..88, that contain the footer text of the packing slip.
• from 91..98, that contain the text of each line in the packing slip.

Each occurrence contains 99 characters.

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 SDHFL import template.

Import of invoicing elements

The value entered for the invoicing elements can be imported into the different documents through the INVDTAAMT fields. (SQH, SOH, SDH).

 The deliveries import template does not take into account picking notes, even though their numbers are included into the template.

Import of the project code and impact on prices and discounts (update 8.0.0 and higher)

• Project code management:
  
  For documents, single project and multi-project management must be distinguished. This mode of management is determined by the parameter PJTNSGDOC - One project by document (TC chapter, PRP group).
   
  1/ Single project management of documents:
   
  

  Import template with tax code ...		Management of the project code on delivery
  ... in header	... on line
  YES	NO	Header = Value of the header import file  Line = Header value
  YES	YES	Header = Value of the header import file Line = Value of the line import file,  or header value if the line value is different from the header
  NO	YES	Header = Blank value Line = Blank value (+ information message if attempt to import a not blank project code)

  
   
  2/ Multi-project management of documents:
   
  

  Import template with tax code ...		Management of the project code on delivery
  ... in header	... on line
  YES	NO	Header = Value of the header import file Line = Header value
  YES	YES	Header = Value of the header import file Line = Value of the line import file
  NO	YES	Header = Blank value Line = Value of the line import file

  
   
• Impact on prices and discounts:
   
  No re-calculation of prices and discounts is carried out on import. However, the behavior can change whether the price is entered or not in the import file:
   
  1/ If the price is not entered in the file, then prices and discounts are taken from the price list search based on the project code of the quote.
   
  2/ If the price is entered in the import file, then the price corresponds to the one of the import file.

Import of returned deliveries - deliveries which have been subject to returns (update 8.0.0 and higher)

Deliveries are imported but the return status of these deliveries is set to 'Not returned'. Returned quantities are not taken into account in the import.