PO Requisition Status Report By Material

You can use the PO Requisition Status Report By Material report to print requisitions by material, with the option to sort the data by Material Category or by Route (purchase/stock/quote) by selecting Purchase Order > Reports > PO Requisition Status Report By Material.

This report prints requisitions by material, with the option to sort the data by Material Category or by Route (purchase/stock/quote). The report can be run for a range of Req Dates, JCCo,Jobs, IN Locations and Material with options to exclude requisitions and quotes that have a status of Denied and exclude Completed Requisitions. The RQ Status & Reviewer/Statu. columns will pull based on the RQ Route. If the route is Purchase or Stock RQRL/RQRR tables are used, if the RQ Route is Quote the RQQL/RQQR tables are used. The report totals by Material and by Material Category.

Report Parameters

Description

Company

Accept the default, or press F4 to select a company.

Sort by (M)at’l Category or (R)oute (purch/stock/quote)

Enter M or R.

Beginning Req Date

Enter beginning requisition date.

Ending Req Date

Enter ending requisition date.

Beginning Requisition #

Click the Field Lookup button or press F4 to select the beginning requisition number.

Ending Requisition #

Click the Field Lookup button or press F4 to select the ending requisition number.

Beginning RQ Date

Enter beginning requisition date.

Ending RQ Date

Enter ending requisition date.

Beginning JCCo

Select the Field Lookup button or press F4 to select the beginning job cost company.

Ending JCCo

Select the Field Lookup button or press F4 to select ending job cost company or leave blank to select all.

Beginning Job

Select the Field Lookup button or press F4 to select the beginning job.

Ending Job

Select the Field Lookup button or press F4 to select the ending job.

Beginning INCo

Click the Field Lookup button or press F4 to select the beginning inventory company.

Ending INCo

Click the Field Lookup button or press F4 to select the ending inventory company.

Beginning IN Location

Click the Field Lookup button or press F4 to select the beginning inventory location.

Ending IN Location

Click the Field Lookup button or press F4 to select the ending inventory location.

Beginning Material

Select the Field Lookup button or press F4 to select the beginning material.

Ending Material

Select the Field Lookup button or press F4 to select the ending material.

Exclude Completed Requisitions?

Check box to exclude completed requisitions.

Exclude Denied Requisitions?

Check box to exclude denied requisitions.

Exclude Denied Quotes?

Check box to exclude denied quotes.