This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

purchase order saved search with bill attachment

&gt;*AI generated answer (using internal Slack threads):*
To create a purchase order saved search with bill attachment, you can follow these steps:

1. Go to Reports &gt; Saved Searches &gt; All Saved Searches &gt; New.
2. Select Transaction from the list.
3. On the Criteria subtab, set the following filters:
   - Type = Purchase Order
   - Main Line = False (This will allow you to search line items)
4. On the Results subtab, add the following columns:
   - Document Number
   - Item
   - Quantity
   - Amount
   - Applying Transaction (This will show the related Vendor Bill)
5. Save the search.

You can also add a formula to calculate the billed and unbilled amounts. For the billed amount, you can use the formula `quantitybilled*rate`. For the unbilled amounts, you can use the formula `amount-(quantitybilled*rate)`.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1538680888000200|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.847281396

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C29HKGM6J/p1613141042180000|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.829565525

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C29J1BPM3/p1668532442053519|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.828610122



Please provide your feedback on this answer.