Running the Product Distribution, Resale Report

The purpose of the Product Distribution, Resale Report is to allow manufacturers to track product that has been shipped from or returned to a customer's inventory location for a specified period of time. The customer can reconcile rebates and discounts, and the manufacturer can assess commissions.

Use IC154 to generate a report in either a CSV file or printed format. The report shows the manufacturer code/division, distribution company, and distribution location information in separate sections. The item section contains the item, doc type, quantity, UOM, unit cost, and trans date.

This report is a companion to the Product Transfer and Resale Report that comes from IC153. Both the IC153 and the IC154 reports can be delivered in the EDI 867 format.

  1. Access the Product Distribution, Resale Report (IC154).
  2. Use the following guidelines:
    Item Group

    Select the Item Group. Select the one that you previously defined in Corporate Item Group (IC00.1).

    Item

    Select the Item for which to report sales.

    Manufacturer Code, Division

    Select the Manufacturer Code and Division for which to report sales. If left blank, then all manufacturers are reported. A Code or Code/Division combination is required if the Output Type is 3 - EDI. Manufacturer codes and divisions for an item group are defined in Manufacturer Code (IC14.1).

    EDI Number

    If an EDI Number is specified, it is written to the EDI-Nbr field in the CSV file. Otherwise, the Manufacturer Code or a concatenated Manufacturer Code/Division value is used.

    EDI Numbers for manufacturer codes and divisions of an item group are defined in Manufacturer Code (IC14.1).

    Distribution Company

    Select the Inventory Control Company. This limits the origin to a single distribution center. (IC01.1).

    Distribution Location

    Select the inventory location. This limits the origin to a single distribution location.

    Trans field date

    Select a Starting and Ending Date for the range of transactions to include in the report.

    Output Type

    • Select 1 to Print and create a CSV file.

    • Select 2 to create only the CSV file.

    • Select 3 to send this report to a Manufacturer using an EDI 867 transaction set. A Code or Code/Division combination is required if the Output Type is 3 EDI.

    If an EDI Number is specified, it is written to the EDI-Nbr field in the CSV file. Otherwise, the Manufacturer Code or a concatenated Manufacturer Code/Division value is written to the EDI-Nbr field in the CSV file. A Trading Partner (ED10) record with this EDI Nbr is required to send the report to a manufacturer.

    File Name

    Type a name for the CSV file. The file is saved to the $LAWDIR/productline/work/IC154 directory. If left blank, then the default is IC154CSV.

  3. Define the job and select the parameters. Submit the EDI or print job.

See 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.