The S4 - Product YTD panel in Customer Consolidated Inquiries (ibis_su45) displays detailed product information relating the invoiced purchases for the customer in the Header Section.

The following list defines every field on the product YTD 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 Line Description
    • Product Group Description
    • Class

  • The list box is organized into three main sections:

    • Line 1 and 2 identify the 'Current Period Sales' from S/A Sales Fiscal Period Close (ibis_sa89). The current month statistics are identified for both the current year and the previous year. Note: The year identifying each period represents the calendar year associated with the month, not the fiscal year.

    • Line 3, 4 and 5 identify the 'Fiscal Year Summary' information, in both Year-To-Date and Year Total formats:

      • Line 3 represents the current fiscal year.
      • Line 4 represents the previous fiscal year.
      • Line 5 represents the total for the previous year's fiscal.

    • Lines 6 and 7 represent the 'Next Period Sales'. The next Month statistics are identified for both the current year and the previous year. Note: The year identifying each period represents the calendar year associated with the month, not the fiscal year.

    The List Box includes 6 columns of information:

    • Period
    • Sales Dollars
    • Gross Margin
    • Gross Margin %
    • Sales Increase/Decrease %
    • Sales Units