TrainCat Help - Inventory Asset Report

Inventory Asset Reports

The Asset Reports provides an overview of the collection contained with in the inventory database along with the value and profit of the items based upon the Current Market Value, the items condition and price paid for the item. Starting with version 2.00.0000, TrainCat introduced the Report Manager. This module allows the user to select the type of report that is desired and then the report format.

Standard Asset Report
	Default Sort Order
		MANF_CODE, ITEM_NUM, ROAD_NUM, CONDITION
	Default Grouping
		MANF_CODE, ITEM_NUM, CONDITION
	Description
		Standard Asset Report is a basic report where TrainCat groups all Inventory items into line items having the same Manufacturer, Stock # and Condition. The Standard Asset Report does provide totals for the Inventory as a whole on the Summary Page.
Assets By Description Report
	Default Sort Order
		MANF_CODE, ITEM_NUM, ROAD_NUM, CONDITION
	Default Grouping
		MANF_CODE, DESCRIPT, ITEM_NUM, CONDITION
	Description
		Asset by Description Report groups all Inventory items into line items having the same Manufacturer and Description into sub-sections providing subtotals for each section. Each sub-section is then grouped by Stock # and Condition. The Asset by Description Report does provide totals for the Inventory as a whole on the Summary Page.
Detailed Asset Report
	Default Sort Order
		MANF_CODE, ITEM_NUM, ROAD_NUM, CONDITION
	Default Grouping
		MANF_CODE, CATEGORY, DESCRIPT, ITEM_NUM, CONDITION
	Description
		Detailed Asset Report groups all Inventory items into line items having the same Manufacturer, Category and Description into sub-sections. Each sub-section is then grouped by Stock # and Condition. Subtotals are provided for each group of (Manufacturer, Category and Description), (Manufacturer and Category) and subtotal of all of a Maunfacturer. The Detailed Asset Report does provide totals for the Inventory as a whole on the Summary Page.

The user is provided with the option to change the sort order of the report. From the Report Manager, click on the Sort button. The sort screen will open. Four pull-downs are available to set the desired order. Clicking the Clear All button will remove all sorts. The sort option for the Asset Reports are:

Manufacturers Code *
Stock Number *
Road Number *
Road Name
Item Condition *
Release Date
Current Value
Original Cost

* indicates defaults. Click Done when the desired Sort is set.

TrainCat always provides the user with a preview of the report first allowing the user to review the report before printing. The report generator is controlled by the Print Preview Control Bar.

The control buttons from left to right are:

First Page
Previous Page
Go To Page
Next Page
Last Page
Preview Magnification
Exit Print Preview
Print Report

See Also