APPX Software Library

4Reports and Inquiry

Option 3Product Activity Report

This report tracks product sales activity. It may be printed by customer area (from the Accounts Receivable Customers file) or by salesperson area (from the Commission Accounting Sales Areas file).

Select “Product Activity” from the Reports and Inquiry menu. The following entry screen appears:

Product Activity screen

The Product Activity Screen
Figure 8

Data items for the preceding screen are described below.

Print Sales By Customer Area (C), or By Salesperson Area (S)?

This field specifies how you want to print the Product Activity report. You may enter either:

C
Print data based on the customer’s area.
S
Print data based on the salesperson’s area.

Press RETURN to save the information on this screen.

Here is a Product Activity Report by customer area:

                                                     Expert Distributing, Inc.
04/09/91 03:28 pm                                                                                                  KAY Page:    1
                                                      Product Activity Report

     Product       Description                    Total Shipped      Not Shipped           Total Sales         Total Margin
==================================================================================================================================
Division

Area

Product Class 20   Special Order

                                                           0.25             0.00                 90.00                86.63
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->          0.25             0.00                 90.00                86.63
                                                      =========        =========         =============         ============
Product Class 30   Custom

     20            #4 12" Gold Plated Black Round          1.00             0.00                300.00               105.65
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->          1.00             0.00                300.00               105.65
                                                      =========        =========         =============         ============
                                                      ---------        ---------         -------------         ------------
                               -- Area Totals -->          1.25             0.00                390.00               192.28
                                                      =========        =========         =============         ============
                                                      ---------        ---------         -------------         ------------
                           -- Division Totals -->          1.25             0.00                390.00               192.28
                                                      =========        =========         =============         ============
Division  1  Main Division

Area 01  Western Region

Product Class

                                                           1.00             0.00                275.00               275.00
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->          1.00             0.00                275.00               275.00
                                                      =========        =========         =============         ============
Product Class 10   Standard

                                                           5.00             0.00                 60.00                10.00
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->          5.00             0.00                 60.00                10.00
                                                      =========        =========         =============         ============
Product Class 20   Special Order

                                                           4.00             0.00              1,440.00               280.00
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->          4.00             0.00              1,440.00               280.00
                                                      =========        =========         =============         ============
Product Class 30   Custom

     20            #4 12" Gold Plated Black Round         16.00             1.00              4,940.00             1,415.00
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->         16.00             1.00              4,940.00             1,415.00
                                                      =========        =========         =============         ============
                                                      ---------        ---------         -------------         ------------
                               -- Area Totals -->         26.00             1.00              6,715.00             1,980.00
                                                      =========        =========         =============         ============

Here is a Product Activity Report by salesperson area:

                                                     Expert Distributing, Inc.
04/09/91 03:33 pm                                                                                                  KAY Page:    1
                                                      Product Activity Report

     Product       Description                    Total Shipped      Not Shipped           Total Sales         Total Margin
==================================================================================================================================
Area 10  Western United States

Product Class 10   Standard

     10            #10 3-1/2" White Round                  6.00             1.00              1,450.00               803.00
                                                           5.00             0.00                 60.00                10.00
     20            #4 12" Gold Plated Black Round          1.00             0.00                200.00               103.00
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->         12.00             1.00              1,710.00               916.00
                                                      =========        =========         =============         ============
Product Class 20   Special Order

                                                           7.00             0.00              2,520.00               490.00
     30            #56 10" Red Cylinder                    2.00             1.00                600.00               211.34
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->          9.00             1.00              3,120.00               701.34
                                                      =========        =========         =============         ============
Product Class 30   Custom

     20            #4 12" Gold Plated Black Round         16.00             1.00              4,860.00             1,437.39
     40            #58 10" Yellow Cylinder                 2.00             1.00                600.00               211.34
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->         18.00             2.00              5,460.00             1,648.73
                                                      =========        =========         =============         ============
                                                      ---------        ---------         -------------         ------------
                               -- Area Totals -->         39.00             4.00             10,290.00             3,266.07
                                                      =========        =========         =============         ============
Area 20  Eastern United States

Product Class

                                                           1.00             0.00                275.00               275.00
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->          1.00             0.00                275.00               275.00
                                                      =========        =========         =============         ============
Product Class 20   Special Order

                                                           0.75             0.00                270.00               259.88
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->          0.75             0.00                270.00               259.88
                                                      =========        =========         =============         ============
Product Class 30   Custom

     20            #4 12" Gold Plated Black Round          1.00             0.00                290.00               265.00
                                                      ---------        ---------         -------------         ------------
                      -- Product Class Totals -->          1.00             0.00                290.00               265.00
                                                      =========        =========         =============         ============
                                                      ---------        ---------         -------------         ------------
                               -- Area Totals -->          2.75             0.00                835.00               799.88
                                                      =========        =========         =============         ============