Selecting Inventory History Report

Inventory History Report

This chapter contains the following topic:

The Inventory History report enables you to print the transaction types by date range.

If you prefer to view inventory history see Viewing Inventory History in the View chapter.

Transaction quantity and transaction value columns can be printed. Here is a description of the contents of each quantity and value column:

Column Heading	Description
Trx-quantity	The transaction quantity column prints the quantity of each transaction included per the date range and selected transaction type. The Trx-quantity total field is the total of the included transactions.
Trx-value	The transaction value column prints the value of each transaction included per the date range and selected transaction type. The Trx-value Total field is the total quantity of the transactions included.
Item-quantity or Whs-quantity	The heading displays as Item-quantity if you select "All" warehouses or you are not using multiple warehouses. If you select a specific warehouse it displays as Whs-quantity. Each line prints the running balance quantity as of that transaction and is calculated from the beginning of the item history for that item. The item Total includes the quantity balance of all transactions up to the End date. The Grand total is the balance for all included items up the End date.
Item-value or Whs-value	The heading displays as Item-value when you select "All" warehouses or you are not using multiple warehouses. If you select a specific warehouse it displays as Whs-value. Each line prints the running balance value as of that transaction and is calculated from the beginning of the item history for that item. The item Total includes the value balance of all transactions up to the End date. The Grand total is the balance for all included items up the End date.

The unit cost is rounded to the nearest whole number.

An asterisk (*) next to the running cost indicates that the item went into a negative quantity and negative cost because of no quantity on hand due to a sale, adjustment or component usage transaction. With out received inventory on hand, the actual item cost of those transactions is not known. Because of this the running cost for the next transactions may not be fully accurate if the full quantity to replace the negative quantity is not received.

If you want to purge history, see the Purge Inventory History chapter.

Select

Inventory history from the Reports menu.

Graphical Mode

When using multiple warehouses the following screen displays:

Character Mode

Enter the information as follows:

Warehouse

Options

If you are using multi-warehousing, enter the warehouse code for which you want the report printed, or use one of the options:

<Enter>	For the Central warehouse
<F1>	For "All" warehouses

Format	Two characters
Example	Press <F5> for "All" warehouses.

Note	If you are not using multi-warehousing, you will not be able to enter the Warehouse field. Using character mode the field does not display and all field numbers will be one less than the numbers shown.

Starting date and

Ending date

Enter the range of transaction dates to include on the report.

Format	MMDDYY for both fields
Example	Press <F2> for Earliest and Latest dates

Starting item numberand

Ending item number

Enter the range of item numbers to include on the report.

Format	Up to 15 digits
Example	Press <F2> for First and Last item numbers

Product category

Enter the category to print the report for only one product category.

<F5>	To include All items.
<Enter>	Leave the field blank to include only those items which do not have a category.

Format	Up to five characters
Example	Press <F5>

Product sub-category

If you entered blank in the previous field, this field also displays as blank and may not be changed.

Options

Enter the product sub-category for the items to be printed, or use one of the options:

<F5>	To include "All" items regardless of whether they have a sub-category or what the sub-category is
<Enter>	Leave the field blank to include only those items which do not have a sub-category.

Format	Up to five characters
Example	Press <F5> for "All" sub-category

Transaction type

Enter a specific transaction type to print on the report.

Options

You may also use one of the following:

<F5>	For All types
<F2>	In character mode select F2 to show a list of the valid transaction types

The transaction types include the following:

F5	All
A	Adjustment
C	Credit memo
R	Receiving
T	Transfer
S	Sale
J	Job usage
K	Kit assembly
U	Component usage

Format

Graphical mode: Drop down list from the table above. The default is All

Character mode: One letter from the table above or one of the options

Example

Select F5 for All types

Show

Select Quantity to print the transaction quantities, Cost to print the transaction costs or Both to print both. Totals by item quantities or costs will also be printed if selected.

If you show both quantity and cost, the transaction comment will not print. If you show quantity or cost the comment will print.

Options

You can use the following options:

Q	Quantity
C	Cost
B	Both quantity and cost

Format

Graphical mode: Drop down list from the table above. The default is quantity

Character mode: One letter from the table above

Example

Enter B to print both Quantity and Cost

Show post date

If you selected B for both for the previous field Show, then this field displays as (Not applicable) and prints regardless.

If you want to print the posting date, select Y. If not select N.

Format

Graphical mode: Check box where checked is yes and unchecked is no. The default is checked

Character mode: One letter, either Y or N. The default is Y

Example

Displays as (Not applicable) in this example

OK or Cancel

Make any changes and select OK to select a printer for printing the report.

Character Mode

Field number to change ?

Enter a number to change a field or select the <Enter> key to continue.