Inventory usage report

1. At the EMMS main menu, select Administration | Reports | Material | Inventory Usage. The Inventory Usage Report enter screen appears.
2. Fill in the fields as required.

   Companyis a specific company to report on. Leave blank for all. You can click on the Prompt button to select the company from a list.

   Copiesis the number of copies of the report to print.

   Date/Time Usage From / Toare the start and end dates and times of the range to report on.

   Download Report Fileidentifies whether the report results should be placed into a file that can be downloaded to a PC.

   Duplexidentifies whether the report should print on both sides of the page.

   Exclude Core Itemsidentifies whether core items should be excluded from the report.

   Holdidentifies whether the report should be held in the queue until released manually rather than being printed automatically.

   If All Warehousesidentifies whether to combine or separate the warehouse data if you have chosen to report on all warehouses.

   Include Adjustmentsidentifies whether inventory adjustments should be included on the report.

   Include Non Stock Purchidentifies whether to include non-stock purchases on the report. You can click on the Prompt button to select your choice from a list. Valid values are:
        - Include Non Stocked Purchase
        - Only Non Stocked Purchase
        - Exclude Non Stocked Purchase

   Include Physical Countidentifies whether physical count transactions should be included on the report.

   Include Transfersidentifies whether or not part transfers should be included on the report.

   Itemis a specific item to report on. Leave blank for all. You can click on the Prompt button to select the item from a list.

   Item Categoryis a specific item category to report on. Leave blank for all. You can click on the Prompt button to select the category from a list.

   Output Queueidentifies which output queue the report should be placed in. It defaults to your regular output queue.

   Product Categoryis a specific product category to report on. Leave blank for all. You can click on the Prompt button to select the product category from a list.

   Report Typeidentifies which version of the report to run. You can click on the Prompt button to select the report type from a list. Valid values are:
        - Total Usage for Period
        - Usage by Month
        - By Month: Total Quantity
        - Descending Usage for Period

   Saveidentifies whether the report should be saved in the output queue after printing.

   Submit to Batchidentifies whether the report should be run in batch (background) or interactively; if run interactively, you will not be able to do anything else until the report is complete.

   User Dataallows you to set up an identifier for the print job that will show up on the output queue. It is optional.

   Vendoris a specific product vendor to report on. Leave blank for all. You can click on the Prompt button to select the vendor from a list.

   View On Screen or Printflags whether the report should be displayed on screen or sent to the printer.

   VMRSis a specific VMRS component to report on. Leave blank for all. You can click on the Prompt button to select the VMRS from a list.

   Warehouseis a specific warehouse to report on. Leave blank for all. You can click on the Prompt button to select the warehouse from a list.

3. Click Enter . The Confirm prompt appears.
4. Click Confirm.
   • If you selected to print, the Inventory Usage report (F6DYPFK) will print on your default printer.
   • If you selected to display the results on screen, the Inventory Usage display screen appears.
   • 1. To view the item master for a part, right-click on the part and select Item Detail. The Item Master Information display screen appears for the selected part.
     2. To view utilization information for a part, right-click on the part and select Item Utilization. The Display Item Utilization screen appears for the selected part.

Back to Material Reports