| □ | Inventory Usage Report lists all Inventory Items that were used within the Date Range specified. |
| • | To access this report, on the Main Menu Select Reports and Choose Inventory Tracking. |
| • | Click the Inventory Usage Report button. |
Inventory Usage Report Options
| • | Options - Initially only the Options tab is shown (until you make your Options selections and Select Print). |
| • | Detail/Summary - Select whether you want a detailed or summary style Inventory Usage Report. |
| ▪ | The Summary choice will simply list each Inventory Item and the total cost of what was used. |
| ▪ | The Detail report will list complete information on where, what, how much, who and when each part was used. |
| • | Order By - Establish the sequence the Inventory Items will be listed. |
| ▪ | Inventory Item - Sort the Inventory Items by Part Number. |
| ▪ | Subscriber - Sort the Inventory Items by Subscriber, then within each Subscriber, by the Inventory Item's Item ID. |
| ▪ | Technician - Sort the Inventory Items by Technician, then within each Technician, by the Inventory Item's Item ID. |
| ▪ | Job - Sort the Inventory Items by Job Number, then within each Job Number, by the Inventory Item's Item ID. |
| ▪ | Date Used - Sort the Inventory Items by the Date that they were used, then within each Date, by the Inventory Item's Item ID. |
| • | One or All - Based on the Order By option selected above, Choose whether All of the records for the select Order By method will be listed, or only a specific One. |
| ▪ | Inventory Item - If the Inventory Item order option was selected above, you may include All Inventory Usage in the report, or the Inventory Usage of One specific Inventory Item. |
| o | One - Click this button to report usage for only one Inventory Item. Use the Drop-Down Selection List to Choose the appropriate Inventory Item's Item ID. |
| o | All - The default. All Inventory Usage of all Inventory Items will be listed. |
| ▪ | Subscriber - If the Subscriber order option was selected above, you may include All your Subscriber's Inventory Usage in the report, or the Inventory Usage of One specific Subscriber. |
| o | One - Click this button to report usage for only one Subscriber. Use the Drop-Down Selection List to Choose the required Subscriber. |
| o | All - The default. All Inventory Usage for all Subscribers will be listed. |
| ▪ | Technician - If the Technician order option was selected above, you may include All your Technician's Inventory Usage in the report, or the Inventory Usage of One specific Technician. |
| o | One - Click this button to report usage for only one Technician. Use the Drop-Down Selection List to Choose the required Technician. |
| o | All - The default. All Inventory Usage for all Technician will be listed. |
| ▪ | Job - If the Job order option was selected above, you may include All your Jobs in the report, or the Inventory Usage of One specific Job. |
| o | One - Click this button to report usage on only one Job. Use the Drop-Down Selection List to Choose the required Job. |
| o | All - The default. All Inventory Usage for all Jobs will be listed. |
| ▪ | Date Used - If the Date Used order option was selected above (see Dates below), you may include All Dates that Inventory Items were Used in the report, or the Inventory Usage that occurred within a specific Date Range. |
| • | Sort By - This option is only available if you've selected Inventory Item as the desired Order. You may Choose the order that the Inventory Items will be listed. |
| ▪ | Group Code and Part Number - Sorts the Inventory Items by Group Code, then within each Group, by Part Number (Item ID). |
| ▪ | Part Number - Sorts the Inventory Items by Part Number (Item ID). |
| • | Dates - Click the Selected button to report Inventory Usage that occurred within the specified Beginning and Ending Date Range. |
| ▪ | By default, theses dates with be for the month preceding the current month. |
Selected Dates option with default Dates inserted
| • | Print - Click the Print button  to Preview and optionally Print (to a File or a Printer) this Inventory Usage Report. |
| • | Preview - The Preview tab presents the report which resulted from the Options you've selected. |
| • | Up Arrow/Down Arrow - hi - Moves the report one line up, or one line line down, respectively. |
| • | Page Up/Page Down - Moves the report to the previous or next page, respectively. |
| • | Subscriber ID - Click this number to open the related Subscriber Form. |
| • | Inv. # - Click this number to open the related Invoice Form. |
Inventory Usage Report Preview
| • | Home -  - Using either the screen icon or your Keyboard's Home key, moves the report to the top of the first page. |
| • | End -  - Using either the screen icon or your Keyboard's End key, moves the report to the bottom of the last page. |
| • | Arrows - The arrows allow you to move back and forth, from page to page. |
| • | Number - Indicates the page number you are viewing. |
| ▪ | You may also type in a specific page number, Press 8 Enter and that page will be displayed immediately. |
| ▪ | If you enter an invalid page number, it will be ignored. |
| • | Fit To Page - Click the first button after the arrows to size a full page of the report to fit the screen. |
| • | Zoom To 100% - Click the second button after the arrows to display the page at 100% (of the printed view). |
| • | Fit To Page Width - Click the third button after the arrows to size the page of the report to fit the full width of the screen. |
| • | Zoom To Percentage - Click the fourth button after the arrows to re-size the page of the report by percentage. |
| ▪ | When you Click the Zoom To Percentage button, the Percentage selector will be displayed. |
| ▪ | You may then Click the Up or Down ‚ arrows to set the exact amount of Zoom you want. |
| • | Type - The Type column on the Inventory Usage Report identifies how that Inventory Item was used. |
| • | Print - Click the Print button to Print (to a File or a Printer)  the displayed Inventory Usage Report. |
| • | Email - Click the Email button  to send the Report to an Email Address of your choosing. |
| • | Data View - This view provides a tabular (spreadsheet style) presentation of the selected data. |
Inventory Usage Report Data View
| • | Arrows - Click the arrows to move through the record. |
| • | Export - Exporting the data from this Data View Form (note the "fly-over" help available on these buttons): |
| ▪ | Export to CSV - Click the first button after the arrows to export the data to a Comma Separated Values (CSV) file format. |
| ▪ | Export To Excel - Click the second button after the arrows to export the data to an Excel (.xls) file format. |
| ▪ | Export To Html - Click the third button after the arrows to export the data to an HTML formatted file. |
| • | Exit the Form by Clicking the Close button x on the right at the top of the Form. |
