Import/export template > Module Sales > Import/export template SOQ (Shipment requests) 

Importing delivery requests enables the creation of new requests or the modification of those delivery requests associated with a contract line. Certain lines can also be deleted, if required.


A delivery request refers to an existing open order line: the contract and product must exist.

Operation

The main file to be set up remains the SORDEC file (contract line). Indeed it is the file linked to the SOQ object.
In the import template for delivery requests, you need to set up two identifiers:

During an import, the existence of the main object (contract line) is recognized automatically by means of the main key representing the contract number, and the line number (SOHNUM + SOPLIN).

The identification of the existence of the detail lines is made, if they exist, in two ways as a function of the presence or not of the quote line number in the import template:

If two lines have the same delivery date, it is necessary to set up the line number in order to differentiate them. If this is not done, it is always the first line corresponding to the search criteria that will be processed.

The import processes the deletion of a line. A request is deleted if it is imported with an ordered quantity equal to zero.

Import of daily, weekly and monthly requests

You need to set up the sequencing field (CAD) in order to properly integrate daily, weekly and monthly requests.
This is a special case: this field is neither entered nor displayed in standard mode. However, for imports, the field needs to be set up in order to differentiate the various types of requests.
If the field is no longer present in the template, or is equal to zero, the system considers this is a daily request.

Other prerequisites

Tables to be completed

The following tables are used by the function. Their content must be updated if necessary :

Table

Table description

SALESREP [REP]

Sales rep

SORDERC [SOC]

Sales orders - early / late

SORDERQ [SOQ]

Sales orders - quantities

Mandatory fields in the template

  • Contract number (*)
  • Contract line number (*)
  • Delivery date requested
  • Requested quantity

(*) In some management cases, a contract line being recognized may not depend on the contract line number. In that case, the system makes it possible not to enter these pieces of information. Yet the information provided must make it possible to clearly identify a contract line. In case of uncertainty, the system rejects the import.

The alternate solutions are:

  • Contract number (SOHNUM) + product reference of the customer (ITMREFBPC). If two order lines exist for this combination, the import is rejected.
  • Contract number (SOHNUM) + product reference (ITMREF). If two order lines exist for this combination, the import is rejected.
  • Customer contract number (CUSORDREF) + product reference (ITMREF). If two order lines exist for this combination, the import is rejected.
  • Customer contract number (CUSORDREF) + product reference (ITMREF) STOP. If two order lines exist for this triplet, the import is rejected.
  • Customer code (BPCORD) + address code (BPAADD) + customer product reference (ITMREFBPC) + product reference (ITMREF). If two order lines exist for this combination, the import is rejected.
  • Customer contract number (CUSORDREF) + customer code (BPCORD) + customer product reference (ITMREFBPC). If two order lines exist for this combination, the import is rejected.

Error messages

The only error messages are the generic ones.

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

FACILITY [FCY]

Sites

ITMBPC [ITU]

Customer product

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

ITMMVT [ITV]

Product-site totals

ITMSALES [ITS]

Products - sales

ITMWRH [ITW]

Products-warehouses

SORDER [SOH]

Sales orders - header

SORDERC [SOC]

Sales orders - early / late

SORDERP [SOP]

Sales orders - price

SORDERQ [SOQ]

Sales orders - quantities

TABSOHTYP [TSO]

Order type table

TABUNAVAIL [TUV]

Unavailable periods

WAREHOUSE [WRH]

Warehouses