Running the Product Transfer and Resale Report

Use this procedure to set the parameters for a Product Transfer, Resale Report (IC153). The report tells a manufacturer that product was transferred from a distribution center to a facility, for a specified period of time. With the report, you track product from the customer's warehouse to the facility where it is used (by distribution location). One transaction is generated for each distribution center that is transferring a manufacturer's product. The report is historical and for it to run, the current date must be greater than the next period end date associated with the manufacturer.

IC153 generates an interface file in one of two formats, EDI or printed format. The report lists the distribution location, ship-to location, and item information in separate sections. The distribution location section includes the product origin, identifiers, and description. The ship-to location section includes the product destination, identifiers, and address. Finally, the item section includes manufacturer items IDs, quantity, price, unit of measure, transaction date, and transaction ID.

Before running IC153, you must have defined manufacturer item numbers, ship-to facilities, and manufacturer relationships.

To run the product transfer and resale report

  1. Access Product Transfer, Resale Report (IC153).

    Use the following guidelines to enter field values:

    Output Type

    Required. Determine the output type of the report (EDI or Print). If you select EDI, the report is transmitted to the manufacturer electronically using the EDI 867 transaction set. For more information, see the Lawson EDI Standard and EDI Professional for Supply Chain Management User Guide.

    Item Group

    Required. Select the item group to report on (the manufacturer is defined under an item group). You set up item groups using Corporate Item Group (IC00.1).

    Manufacturer ID

    Select the manufacturer ID that you set up using Manufacturer Relationship Management (IC34.1). If left blank, this field reports on all manufacturers.

    Distribution Company

    Select the company to be reported on. Your selection limits the origin to a single distribution center.

    Distribution Location

    Select the inventory or requesting location to be reported on. Your selection limits the origin to a single distribution center.

    Ship To Facility

    Select the ship to facility to be reported on. You define ship to facilities using Ship to Facility (IC33.1). Your selection limits the destination to a single ship to facility.

    Override Period End Date

    Type the date that overrides the next period end date.

    Update Next Period End Date

    Decide whether the report is to update the next period end date for the manufacturer (default is Yes).

    Select No if you chose an output type of Print.

  2. Define the job and select the parameters that you want to report on and submit the EDI or print job. Refer to the Lawson EDI for Supply Chain Management Trading Partner List and the Lawson EDI Standard and EDI Professional for Supply Chain Management User Guide for setup requirements.