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 .
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? |
checkbox to exclude completed requisitions. |
|
Exclude Denied Requisitions? |
checkbox to exclude denied requisitions. |
|
Exclude Denied Quotes? |
checkbox to exclude denied quotes. |
