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 .
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. |
