The S5 - Product by Month panel in Customer Consolidated Inquiries (ibis_su45) displays the sales dollars and sales units by month for the product identified for the current year and the previous year for the customer in the Header Section. The 24 months are based on the fiscal Year set up in Fiscal Date Entry (ibis_cc90).

The following list defines every field on the Product by Month panel:

  • Product - enter or select from the query the product. Once the product code is entered, the following information from the Products (ibis_ici1.im13) view displays below the product field:

    • Product Description & Second Description (if applicable)
    • Commodity Code
    • Product Group Description
    • Class

  • The list box displays the sales dollars and units by month for the current year and for the previous year.