S/A Customer & Product Sales Print (SA86)

The Customer/Product Sales Report (SA86) provides on demand printing of Customer/Product Sales statistics for the current period open or for true to-date figures, including any Sales recorded to-date in the next period.

1. The Printer Selection screen automatically opens. Select the Printer destination and click OK.

2. The Report Parameters screen for SA86 opens.
   • Select a Format from the drop down list. Valid options include:
     • Sales & Gross Profit - provides a listing of MTD & YTD Sales, Profit and GP% for this year and last year, date of last sale, number of Orders and average Order size.
     • Customer 24 Month History - provides a listing of Sales dollars for 12 months for this year and last year, YTD Sales dollars for this year and last year, and total Sales dollars for the past year.

   • Select a Sequence from the drop down list. Valid options include:
     • Customer
     • Class of Trade
     • Tax Group
     • Territory
     • Current Sales Rep
     • Sales Grouping
     • Sales Office
     • Postal/Zip Code

   • If a New Page for each Break is required, select the checkbox.

   • The Levels list box displays the various Levels of detail available for the report. All Levels are automatically selected in SA86; the '>' before each Level option indicates the Level is selected. Double click on the line to remove the selector. SA86 includes the following Levels:
     • Detail Line
     • Customer
     • Report Total/Class of Trade/Tax Group/Territory/Current Sales Rep/Sales Grouping/Sales Office/Price Group/Postal Code Zip code (This Level varies depending on the Sequence selected.)

   • Select the Restrictions that apply to the Report by double clicking on the line in the list box. Restrictions allow you to tailor SA86 to your specific needs. The '>' before a Restriction indicates the Restriction is selected. Once a Restriction is selected, it can be de-selected but the '>' remains. An '*' before a Restriction means the Restriction is mandatory. SA86 includes the following Restrictions:
     • Current/Next Period - the Invoicing and Sales Analysis modules provide for Current Period/Next Period processing and reporting. Select the Current Period during the normal sales period days and select the Next Period when the next Sales period has started before the previous (current) period is closed.

     • Ranking - ranks Products in Sales dollars or Profit dollars. Note: When the sequence is Postal/Zip code, you cannot select ranking.

       When the print job is submitted, this restriction automatically generates another message: "Enter number of Top Products __. ALL. OK". Enter the number of Top Products you wish to see on the report or click ALL. When all of the information is entered correctly, click OK to close the message window.

       Notes:

       • If a number is entered, the program will generate the ranking sort file and then print the report. Products will be reported from best to worst, reporting the Product with the highest Sales/Profit first.
       • If the sequence chosen is anything other than Customer, the ranking, including any Number of Top Accounts limit, will be done within the sequence chosen. For example, if 'Territory' sequence is chosen for the top 20 Products, the Report will show the top 20 Products for EACH Territory.

     • Suppress Zero Sales - reports only those Products with Sales in the current and/or previous year with Sales not equal to zero.

       Note: To modify a Restriction once it is set up, reselect the Restriction and make the necessary changes.

   • Select the Range From and To for the report. The Range must match the Sequence selected; if, for example, the Sequence is Customer, you must enter Customer codes in the To and From fields. Multiple Ranges may be entered.
     • In the From field, enter the starting 'code' for the report.

     • In the To field, enter the ending 'code' for the report.

     • The information displays in the list box below.

     • To add additional Ranges, repeat these steps.

       Note: To print the entire file (all Customer codes), simply tab through the From and To fields. The list box displays *Start and *End in the From and To fields.

     • To delete a Range from the list box, double click on the line. The following message displays, "Do you wish to delete this range? Yes/No". Click Yes to delete the range.

   • When all of the information on the Report Parameters screen is complete, click OK to run the report.

3. The Report Complete screen opens when the report is generated. Click OK to accept the Report or click Abort to cancel the Report. Note: This report does not require you to enter the Acceptance Codes.

^{Customer/Product Sales Report (SA86)}