This program provides historical sales information, such as sales, cost of goods sold, gross margin and gross margin percentage, for each customer on record. Accumulated, Comparison, Multiperiod and Graph formats are available in this inquiry. When you access this screen, the system displays the current period for your company.
1. Customer
Press Enter (CR) to default to the first record on file. If you already have a customer selected, press Enter (CR) to default to the next record on file. Press F2 or to search.
2. Ship-To
If the customer selected has several locations, you can review sales volume of an item for each of the customer’s locations. Press Enter (CR) or to default to SAME, or the same ship-to information in the customer’s master file (Customer F/M). Press F2 or to search.
3. Customer Ship-To’s by Number
If the customer selected has several locations, you can click to open the Ship-To address file for the specified customer or select to scroll through customer ship-to locations to review sales volume of an item for each of the customer’s locations.
4. View
Enter the display code for the inquiry view. You can select from: Accumulated, Comparison, Multiperiod.
The Accumulated format displays the sales dollars, cost, gross margin ($), gross margin (%) and, in item and item class inquiries, units for the current period, previous period, year-to-date, prior year-to-date, prior year, past 6 periods and past 12 periods. When making comparison between year-to-date figures and prior year figures, keep in mind that year-to-date figures include the current period; however, prior-year-to-date figures exclude the current period 12 months ago. As a result, more accurate comparison can be made at the beginning of each period.
The Comparison format provides a historical comparison of the sales dollars, cost, gross margin ($), gross margin (%) and, in item and item class inquiries, units. This format requires you to enter a beginning and ending period as well as the number of past periods to compare. If you select the comparison format, the system displays the dates of the last sale to the customer and the last sale to ship-to location. Historical comparison data will display for:
The Multiperiod format displays the sales dollars, cost, gross margin ($), gross margin (%) and units (for item and item class inquiries only) for the current period and the previous periods you specify.
For the Multiperiod view, the following fields are available:
5. Beginning Pd
Enter the beginning period for the multiperiod view.
6. # Pds
Enter the number of periods to view.
7. Comparison
Select the Comparison checkbox to indicate you want compare mutli- period customer information
8. # Pds Back
Enter the number periods back for the mutiperiod comparison range.
Select the Show Chart checkbox to indicate you want to view customer sales information graphically.
When you select this checkbox, FACTS enables the Chart Contents section of the screen, where you can select the types of customer information for the graph. The Chart displays sales, cost, gross margin or units (in item and item class information) in a graphical format based on your selections below. The chart also allows comparison graphing of sales vs. gross margin or any other combination of sales, cost, and gross margin.
10. Sales
Select the Sales checkbox to include sales information for the chart of the specified customer/ship-to location selected.
11. Cost
Select the Cost checkbox to include cost information for the chart of the specified customer/ship-to location selected.
Select the GM checkbox to include gross margin information for the chart of the specified customer/ship-to location selected.
Select the GM% checkbox to include gross margin information for the chart of the specified customer/ship-to location selected.
When you have finished viewing historical sales information the specified customer/ship-to location selected, press the Done button to return to the Customer field. Enter the customer number for the inquiry or press Done to exit the screen.