About the Item History History Tab
The History tab shows extended history of quantities sold for the past 24 months and total number of hits (number of items sold) for the last 12 months, for selected items. These totals are displayed in columns based on calendar months. The quantities sold figures are displayed by general ledger location. The total hits figures are displayed by inventory location.
The 1-12 column shows figures for each month that has passed in the current year; for each month that has not passed in the current year, the 1-12 column shows totals for the previous year. Each monthly total in the 13-24 column is one year older than the corresponding total in the 1-12 column.
The totals in the Hits column are for the months in the 1-12 column. For example, if the totals for January 2001 are in position 1 in the 1-12 column, then hits for January 2001 are in position 1 in the Hits column.
Monthly totals and hits are updated when you do the month-end procedure. The following diagram illustrates this change.
|
1 - 12 |
13 - 24 |
Hits |
Before Month-End |
6/00 |
6/99 |
6/00 |
After Month-End |
6/01 |
6/00 |
6/01 |
Yearly Totals
These boxes show year-to-date sales totals for the current fiscal year and year-end sales totals for the previous fiscal year. These totals are kept for all cataloged items. All of these boxes, except YTD Hits, are updated by general ledger location. The YTD Hits box is updated by inventory location. However, if the Update I-AUX Sales for Inventory Location field in the (LE1) Inventory Parameters screen is set to Y, all these boxes update by inventory location.
These figures are not totals for the 1-12 and 13-24 columns. There are several differences between the column figures and the yearly totals:
The columns show information by calendar year, and the yearly totals are kept by fiscal year (or whenever you perform year-end actions).
Yearly totals are updated continuously; the columns are updated once a month.
The left column of yearly totals displays year-to-date figures, but the 1-12 column above it shows totals for an entire year.
The columns may include information from more than one year; the first column of yearly totals is for this year and the second column is for the year before.
Return to:
See also: