Consignment Usage Report

The Usage Report is used for billing.  This report shows all items Released from the Consignment Catalog.

At the menu, click on Consignment.  At the next screen click on Reports.  

The Usage Report can be sorted by Order # or Req # and can be displayed by Product Code or Alternate Code (customer code).

Make sure that Usage Report is selected, you choose how to sort report, then enter in data and click Report, or you can not enter any data and click Report.

image7.gif

This will bring you to the Usage Report hyperlink.

You can print the report by clicking the Printer Icon of your browser, or you can download the report by clicking on the Download Report at the bottom of the report.

"Tips for download" Page. Click on the blue "HERE" hyperlink displayed at the top of the screen to actually perform the download.

The download option will generate a tab delimited ASCII text file. This file will be displayed in text format for viewing. To request another report, use the BACK button on your browser to return to the Report Selection Screen.

This file format can be imported into any spreadsheet or database for further review. Save Target as a user-specified file. Right-Clickon the blue "HERE" hyperlink displayed at the top of the screen. In the pop-up box displayed, highlight "Save Target As...." (A "Save As" Box will appear). Browseand select the file in which you want to save the Consignment Usage  Report. Click on the Save Button.

"Download Complete" will appear on your screen. To import into Excel, open the application and select the text file.


 

A wizard will help you to convert the text file into Excel.

A wizard will help you to convert the text file to Excel.