The S2 - Commodity by Month panel in Customer Consolidated Inquiries (ibis_su45) displays the sales dollars by month for the current year and previous year for the customer entered in the Header Section. The information is grouped by commodity and displays the last 24 months of historical purchases. These 24 months are based on the fiscal year structure as maintained in Fiscal Date Entry (ibis_cc90).

The following list defines every field on the commodity by month panel:

  • Enter or select from the query a commodity code in the commodity field. The commodity codes are defined in Commodities (ibis_im02). Once the commodity code is entered, the product line and product group descriptions display below the commodity field.

    • You can select all commodity codes by clicking on ALL. This option displays values for all of the commodity groups. The statistics displayed are for all commodity groupings.

  • The list box includes the 12 calendar months and sales statistics based on the commodity code entered for the current fiscal year and the previous fiscal year.

  • Note: The level of detail displayed in the list box depends on the 'Update Customer History' flag set up in Company Control Initialization (CC00/Inventory). You cannot modify the setting for this flag in CC00 once it is set up. Valid options include:

    • Full Commodity - sales statistics are stored by full commodity code (4 character commodity code).
    • Product Line - sales statistics are stored by product line only (2 high-order characters of the commodity code).