Open topic with navigation

Value on Hand Report screen

The Value on Hand Report screen allows the user to review and print a report showing the quantity, total costs, and total value for every item in inventory at present or for a selected past month.

Use the Value on Hand Report screen

1. Log In to the Data Center Application to display the Data Center ribbon menu.

   

2. Select Reports > Inventory Reports > Value on Hand Report from the main menu to display the Value on Hand Report screen.

   Note: A user must be granted the Reports permission to view/use this feature.

   

3. Complete the desired procedure(s) with onscreen features.

   Date drop-down	Select "Today" (default value) from the drop-down to display current inventory values. Select a past month from the drop-down to display inventory values from that period. Note: The drop-down does not include months that occurred prior to the installation of AXIS software version 2.5. Note: Some individual values (i.e., Retail Price, Ext Retail Price, GP $, GP %) may not be available for past months.
   Raw Data and Report tabs	Click the Raw Data tab to display a grid that can be filtered, sorted, and grouped. Click the Report tab to display and print a report showing data as filtered, sorted, and grouped on the Raw Data tab.
   Sort and Filter Reporting Screen Data	Use these controls on the Raw Data tab as needed to modify the list. Enter a term (string of characters) in the Search field to display only records containing that term. Click the Clear Search (X) button to undo the Search field filter. Click the Clear All button to undo all filters. Click the Toggle Filters button to display filter controls at the tops of the columns. (Click again to hide the controls.) Click the Export to Excel (Table) button to export the data to an Excel file formatted like the Raw Data tab. Click the Column Chooser button to hide or display individual columns.
   Report controls	Use these controls on the Report tab as needed to modify the report. Click the green Back and Forward arrow buttons to move through report history. Click the red Stop button to stop historical navigation. Click the green Refresh button to refresh the information on the screen. Click the blue First, Previous, Next, and Last buttons to move through the report's pages. Click the Page Setup button to modify the report's page size, orientation, margins, and source as desired for printing. Click the Print Preview button to display a preview of the printed report. (Click the button again to return to the original view.) Click the Print button to print the report. Click the Export button to display a drop-down menu of export options.
   Report columns	See the Report Columns Index for more information.

   • Use the Value on Hand Report