This report runs through the Parts stock file. Only parts that have a stock quantity are included in the report, and only parts that are older than the age specified. The age of a part is calculated using the date last sold or the date last purchased, depending on the prompt selected.
By default the report is displayed, and sorted by bin location. A page break is forced on change of bin location, and a prompt allows you to specify how many characters of the bin location to use before the break is generated. (The default is five characters.) When the report is run, you are also given the option to print the report or output the report to an HTML directory.
The following details are included in the report:
Part number
Description
Bin location
Total stock value
Quantity in stock
Average cost
Date last purchased
Date last sold
Stock age in days
To report on lines over X days old by bin:
From the Rev.8 Master Menu, select the Stock management option and Company you require.
The STOCK MANAGEMENT menu is displayed.
Select the Reports and enquiries option.
The SM REPORTS AND ENQUIRIES menu is displayed.
Select the Lines over X days old by Bin option.
The Lines over X days old by Bin form is displayed.
Complete the form and click OK.
The report is compiled and output in the selected format.
This form is displayed when you select the Lines over X days old by Bin option from the SM REPORTS AND ENQUIRIES menu. From this form you can report on lines over a specified number of days old by bin location.
Output type: Enables you to specify the format in which the report is produced. One of:
Print: Prints the report to the currently selected printer
HTML: Outputs the report to file in Hyper-Text Markup Language (HTML) format
Display: Displays the report (default)
By Franchise (Blank=All): Single-character franchise code, or blank for all franchises
From Location: First bin location in the range, or blank to include all bins
To Location: Last bin location in the range, or blank to include all bins
Break On: Number of characters to count in the bin location before a break is generated (default 5)
No. of Days Old (0=All): Number of days old the part must be to be included in the report
RADIO BUTTONS:
By Last Date PURCHASED: Select to age parts by last date purchased
By Last Date SOLD: Select to age parts by last date sold
PUSH BUTTONS:
OK: Outputs the report in the selected format
Cancel: Returns you to the SM REPORTS AND ENQUIRIES menu
Help: Displays help on the current program using the default browser
Schedule: Displays the Timed Operations scheduler. This button is not enabled when the output type is set to Display.
Add to batch: Displays an Add report to batch form in which a report may be batched for printing in a report group. This button is not enabled when the output type is set to Display.
