How do I filter the report to show only POs tied to a requisition? (2025.02)

Issue

I'm printing purchase orders, but I only want to print a purchase order if the purchase order is tied to a requisition. 

 

Explanation

You may want to only print purchase orders that are tied to a requisition to

• reduce confusion and eliminate the potential for over-ordering or financial discrepancies. 

• improve clarity and communication with vendors to make it easier to match invoices and deliveries. 

• ensure high-priority orders are processed and fulfilled on time. 

• make sure the purchase order aligns with budget limits. 

 

 

Solution

You will need to be running version 2025.02 or later. The requisition number variable is included in the 2025.02 release. 

1. To sort purchase orders by requisition number, open the Purchase Orders report (Reports > Purchase Orders). In the selection criteria, click Select field criteria .

2. Select Requisition.Requisition number. 

 

3. Click OK. 

4. In the selection criteria, double-click ALL. 

5. Set up an operator to {< >} Is not equal to and then enter zero as the value. 

 

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

• Related Articles

• Requisition Status Report

  Use the Requisition Status Report to print requisitions that have been approved, canceled, or pending. Print the Requisition Status Report 1. Open Connect Accounts Payable > Purchases and Requisitions > Requisition Status Report. 2. Select a report ...

• How do I filter a report by requisition number? (2025.02)

  Issue I want to sort report information by requisition number. How do I do that? Solution First, you need to be running version 2025.02 or later. Next, add the requisition number field to the selection criteria. Click Select the criteria fields . ...

• Requisition Register

  A Requisition Register is a written record containing regular entries of items or details for requisitions. This is an audit report. You can look at all of the requisitions that you've entered on a specific date and review if you have the right ...

• What is a filter?

  A filter is a search tool for sorting reports. The Filter menu is located next to the field where you select a report definition. When you set up a filter, you can select which report definitions will display in the Definition menu. Connect will only ...

• Requisition Budget Report

  Print a budget report for requisitions. You can see who requested the item, the vendor assigned to the requisition, YTD expenditures, what has been spent, what is committed, and so on. You can also see pending approvals that may be delaying the ...