Creating a product resale report

Run Product Dist, Resale Report (IC154) to create a Product Resale Report for a Manufacturer. The result is a CSV file in the LAWDIR/productline/work/IC154 directory. The file name can be user-defined, or if left blank, the default is IC154CSV. The job is setup once and then is run as part of processing an EDI 867 Product Dist, Resale Report.

Use these instructions to transmit Product Sales records to a specific Manufacturer.

  1. Access Product Dist, Resale Report (IC154).
  2. Specify this information:
    Item Group

    Select an item group for which to report shipments.

    Item Number

    Select an item number or leave blank to report on all items for a manufacturer.

  3. Specify a Manufacturer Code or Code and Division
    EDI Number

    Optionally, specify an EDI Number to find the correct Trading Partner (ED10.1) record. If the EDI Number field is left blank, then the Manufacturer Code, or Code and Division is used to find the Trading Partner record. If a code and division are specified, they are concatenated and used as a single value. <code + division>

    Trans Date

    Select a starting and ending date.

    Output Type

    Specify 3 EDI.

    Filename

    Specify a filename. If the filename is left blank, the default is IC154CSV.

  4. Run the job.

The file is save to the $LAWDIR/productline/work/IC154 folder.