This article describes the procedure for using the Import data application in relation to picking order reportings. You will be informed about possible preconditions, effects and special features.

The description of the Import data application, which also includes field and button descriptions, can be found in the Import data article.

General information

When importing a picking order reporting, no picking order voucher is created, but the import is used to update an existing picking order.

Structure of a picking order reporting

Picking order reporting consists of the following elements:

• Basic data: picking order type and number
• Line item data: line item number, item, identifier, warehouse and reporting quantity

Line item data cannot be imported separately, but only with assignment to a clearly identified picking order. The picking order must already exist.

Procedure: Importing picking order reporting

1. Open the Import data application
2. Open the filter for this part: cisag.app.sales.obj.PickingOrderTransactionThe filter for importing picking order reporting is opened.
3. Duplicate or create a new filter for this business object if required
4. If necessary, change the attributes of the filter that have already been selected
5. Select the Import data button in the standard toolbar
6. The Import data dialog box opens
7. You can make settings for the import file in the Import data dialog box. You can find a description of the fields in the Import data article.
8. Select one of the buttons [In background] or [Immediately] buttons
9. The import is executed.

Overpicking

The import of an overpicking is normally noted with an error message. This prevents reporting. This behavior can be changed using the following system property and the value true: If the reporting quantity exceeds the open quantity, the maximum amount of the reporting is the open quantity, but an error message is not issued.

com.cisag.app.sales.picking.log.PickingOrderProcessingDisableCheckOverDelivery=true

The following system property is no longer available:

com.cisag.app.sales.picking.log.PickingOrderTransactionCheckOverDelivery

Overview: Attributes

The attributes of the individual business objects that are available for import are listed below. The corresponding relationship name is also included for foreign key attributes. The identification and mandatory fields are subject to change and can be extended by making adjustments.

The identification attributes (key attributes) are identified by a (K).

Enter at least the following attributes for each picking order reporting:

• Identification attributes
• Mandatory attributes

Without the identification attributes, the picking order reporting cannot be assigned to the existing picking order data. If a mandatory field is missing, the picking order reporting cannot be executed.

All attributes with the exception of referenceWarehouse and ean must be specified. The attributes identifier and serialNumbers only need to be specified for identifier-managed items.

Example

The following import file can be used to import a reporting for a picking order item with a serial number without inventory management:

<xml version="1.0" encoding="UTF-8">
<semiramis xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="">
  <PickingOrderTransaction xmlns="com.cisag.app.sales.obj.PickingOrderTransaction" invalid="true">
    <warehouse>
      <warehouse>100</warehouse>
    </warehouse>
    <referenceWarehouse>
      <warehouse>0</warehouse>
    </referenceWarehouse>
    <reportedQuantity index="0">
      <amount>5</amount>
      <Uom>
        <index/>
        <code>St.</code>
      </Uom>
    </reportedQuantity>
    <Item>
      <number>10010</number>
    </Item>
    <serialNumbers index="0">S001</serialNumbers>
    <serialNumbers index="1">S002</serialNumbers>
    <serialNumbers index="2">S003</serialNumbers>
    <serialNumbers index="3">S004</serialNumbers>
    <serialNumbers index="4">S005</serialNumbers>
    <PickingOrder>
      <number>KS0654</number>
      <type>
        <code>100</code>
      </type>
    </PickingOrder>
    <PickingOrderDetail>
      <number>10</number>
      <subNumber>0</subNumber>
    </PickingOrderDetail>
  </PickingOrderTransaction>
</semiramis>