Topic overview

This article describes procedures for using the Import data application in relation to inventory order reporting.

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

General information

You can use inventory order reportings to report quantities for inventory orders that already exist in the system. You can also change the inventory orders without reporting quantities (except for inventory orders with serial numbers and loading units).

The data model used for the import differs from the data model of the inventory order. It consists of a part that can only include the attributes that are required for the reporting and that can be changed in the inventory order.

Procedures

1. Open the Import data application
2. Display the relevant filter com.cisag.app.inventory.obj.TransportOrderTransaction

• The filter for importing the inventory order reporting is displayed.

(If required, you can also create a new filter for this).

• The selected attributes of the filter are already highlighted.

3. Adapt the attributes if required
4. Select the [Import data] button in the standard toolbar

• The Import data dialog window opens.

5. You can make settings for the import file in this dialog window. A detailed description of the fields can be found in the Import data article.
6. You can carry out the import by selecting the [In background] or [Immediately] button.

Reporting an inventory order via the import interface

Reporting or changing the data of an inventory order via the import interface is always done line item by line item. When reporting the inventory order, you only need to enter the data that enables the reporting to be assigned to an inventory order line item and, if required, the check digits of the storage locations. If you want to change the inventory order data via the import, you must specify the corresponding attributes in the import file.

If a partial reporting quantity and a different warehouse zone, a different storage location or a different identifier are specified for an inventory order line item, the line item is automatically split. The precondition is that other conditions for splitting line items are fulfilled.

Some attributes can be specified via foreign key relationships (indicated by italics in the filter). These attributes are not part of the inventory order reporting. Business objects that are referenced with foreign key relationships are identified by their identification attributes. They cannot be imported via the import for inventory order reportings and must already exist in the system.

A corresponding XML file with functional attributes has the following content, for example:

<?xml version="1.0" encoding="UTF-8"?>
<semiramis xmlns=
 "com.cisag.app.inventory.obj.TransportOrderTransaction"
 locale="en-US-XMLSchemaCompliant">
 <TransportOrderTransaction>
  <TransportOrderDetail>
   <number>10</number>
    <TransportOrder>
     <number>LA002809</number>
     <Type>
      <code>100</code>
     </Type>
      </TransportOrder>
   </TransportOrderDetail>
   <Storage>
     <warehouse>TSTD</warehouse>
     <zone>Z1</zone>
     <location>006-023</location>
   </Storage>
   <Item>
     <number>BT_01</number>
   </Item>
   <reportedQuantity index="0">
    <amount>10</amount>
    <Uom>Stk</Uom>
   </reportedQuantity>
 </TransportOrderTransaction>
</semiramis>

Overview: Supported attributes during import

Below is a list of all attributes supported by the import of the inventory order reporting. The corresponding relationship name is given for all attributes that can be specified via foreign key relationships.

Reporting of loading units

When reporting loading units, a distinction must be made between the reporting of a loading unit that was assigned when the inventory order was generated and the reporting of line items with an item for which the reporting is made via loading units.

Reporting of a line item with a loading unit assigned during generation

It is not absolutely necessary to specify the loading unit for this reporting. For such a line item, it is also possible to change the loading unit if it has not already been specified in the original voucher.

Reporting a line item with loading units

When reporting a line item using loading units, one reporting must be made per loading unit. The loading unit must be specified, otherwise the reporting is treated as a reporting without loading units. A quantity can be specified in addition to the loading unit. In this case, the quantity of the loading unit and the separately specified quantity are reported. If several loading units are used for the reporting, each reporting is considered as a partial reporting.

Reporting of serial numbers

When reporting serial numbers, a distinction must be made between inventory-managed and non-inventory-managed serial numbers.

Inventory-managed serial numbers

When reporting a line item with a serial number, one reporting must be made per serial number, whereby the serial number must be specified. This type of reporting does not require a quantity to be specified (quantities are not taken into account in the reporting).

Non-inventory managed serial numbers

Non-inventory managed serial numbers can be reported in two different ways:

• Specifying the serial number

In this case, the reporting is carried out in the same way as the reporting of inventory-managed serial numbers. You must specify an item if it concerns line items that have a loading unit that was assigned to the inventory order when the inventory order was generated.

• Specifying the quantity to be reported

In this case, the reporting is the same as for a line item with an article or a loading unit, i.e. without specifying a serial number.