S6 - Customer/Product (SU45)

TIP: This program has access to the iTopia Quick Link feature. For more information, click here.

The S6 - Customer/Product panel in Customer Inquiries (SU45) displays Dollar and Unit Sales information represented in various Detail Levels for the Customer in the Header Section.

The following list defines every field on the Customer/Product panel:

• Detail Level - from the drop down list, select a Detail Level. Valid options include:
  • Total - summarizes all information on a single line for ALL products. This total is displayed as a single line of data, and all column headings represents the company totals up to the period number as selected in the Up To Period selector. This is the default Detail Level.

  • Product Line - displays the accumulated data for each Product Line up to the period selected in the 'Up To Period' field.

  • Product Group - displays the accumulated data for each Product Group up to the period selected in the 'Up To Period' field.

  • Product - displays data for each Product up to the period selected in the 'Up To Period' field.

• Up to Period - from the drop down list, select the fiscal period up to which the data is accumulated. The list only includes the Current Sales Analysis Period as defined in Close Sales Fiscal Period (SA89). The Next Period or any future periods are not available.
  • The range of Periods begins with the Current Period and continues back for the previous 23 periods, allowing you to select from 24 periods. The Current Sales Analysis Period is the default period.

• Print - click on the Print icon to print the information currently displayed in the panel. For example, if the current panel displays 50 items, but there are 100 items in the list, only the 50 items currently displayed on the panel print.
  • The 'Detail Level' and 'Up to Period' settings are Headings on the report.
  • For more detailed reporting, run the Customer/Product Sales Report (SA86).

• In the List Box, there are 9 columns of information:
  • Code

  • Description

  • Sales MTD - displays the Month-to-Date dollar Sales for the period selected in the 'Up To Period' field.

  • GM% - displays the calculated Gross Margin Percentage based on the current Month-to-Date Sales figures. The GM% uses the current Replacement Cost. If you are not authorized to view Costs, based on the 'Display Cost' setting in Maintain Operator Password/Privilege (CC03), then this column is blank.

  • Sales YTD - displays the Year-to-Date dollar Sales for all periods in the current year including, but not exceeding, the period defined in the 'Up To Period' field. The year is based on the Fiscal Year defined in Maintain Fiscal Dates (CC90), and not the calendar year.

  • GM% - displays the calculated Gross Margin Percentage based on the current Year-to-Date Sales figures. The GM% uses the Current Replacement Cost. If you are not authorized to view Costs, based on the 'Display Cost' setting in CC03, then this column is blank.

  • Sales NXMTD - displays the Month-to-Date dollar Sales for the Next period. 'Next' is defined as the period following the period entered in the 'Up To Period' field. If the Current period is period 11, and the 'Up To Period' is defined as period 9, then the NXMTD period is period 10.

  • Sales LYTD - displays the Year-to-Date Sales for Last Year for all periods last year, including but not exceeding, the period entered 'Up To Period' field. The year is based on the Fiscal Year defined in CC90, and not the calendar year.

  • Sales LYT - displays the Total dollar sales for Last Year. The year is based on the fiscal year defined in CC90, and not the calendar year.

  • +/-% - (scroll to the right) displays the calculated Increase or Decrease percentage based on Sales Month-to-Date compared with Sales Last Year Month-to-Date.

  • Units MTD - displays the Month-to-Date Unit Sales for the period selected in the 'Up To Period' field.

  • Units YTD - displays the Year-to-Date Unit Sales for all periods in the current year including, but not exceeding, the period entered in the 'Up To Period' field. The year is based on the fiscal year defined in CC90, and not the calendar year.

  • Units NXMTD - displays the Month-to-Date Unit Sales for the Next period. 'Next' is defined as the period following the period entered in the 'Up To Period' field. For example, if the Current period is period 11, but the 'Up To Period' is defined as period 9, then the NXMTD period is period 10.

  • Units LYTD - displays the Year-to-Date Unit Sales for Last Year for all periods last year including, but not exceeding, the period entered in the 'Up To Period' field.

  • Units LYT - displays the Total Unit Sales for Last Year.

  • +/-% - displays the calculated Increase or Decrease Percentage based on Units Month-to-Date compared with Units Last Year Month-to-Date.

^{S6 - Customer/Product Sales}