Material Item Summary

This page allows you to view the quantity ordered and received from Purchase Orders, and used from Daily Reports.

Query Data

Purchase Order Status - Select the status (or all) of the Purchase Orders to which you wish to limit the display.  Only the statuses of the Purchase Orders you have entered on this project will show.

Item Number - Select the item number (or all) of the materials you wish to display.

Balance - Select the outstanding balance (quantity ordered - quantity received) to which you wish to limit the display.

Log

Item Number - Item number for material.  The material database can be updated from Navigate > Administration > Company Setup > Add Material.

Item Description - Description for the material.  The material database can be updated from Navigate > Administration > Company Setup > Add Material.

Total Ordered - Dollar amount ordered from Purchase Order line item for the material.

Quantity Ordered - Number of items ordered from the Purchase Order line item for the material.

Quantity Received - Number of items noted as received from the Purchase Order line item for the material.

Ord/Rec Balance - Sum of items not received yet (quantity ordered - quantity received) for the item.

Quantity Used - Number of items noted as used from Daily Reports.