how can i create a transaction saved search for pu...
# ask-stanley-ai
j
how can i create a transaction saved search for purchase order with pending billing status to exclude any purchase order with bill transactions already but is still pending billing
c
AI generated answer (using internal Slack threads):
To create a transaction saved search for purchase orders with pending billing status and exclude any purchase order with bill transactions already but is still pending billing, you can follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction from the list. 3. In the Criteria subtab, set the following filters: - Type = Purchase Order - Main Line = True - Status = Purchase Order:Pending Billing 4. To exclude purchase orders with bill transactions, you can add a subcriteria: - Join to 'Applying Transaction' and set Type = Bill - Then, set a condition for this subcriteria to 'is none of'. 5. In the Results subtab, select the fields you want to display in your search results. This will give you a list of Purchase Orders that are in 'Pending Billing' status but do not have any related Bill transactions. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.822297037
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.820020914
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819641
Please provide your feedback on this answer.