i want to create a saved search that returns the b...
# ask-stanley-ai
n
i want to create a saved search that returns the bills internal id that is related to the po in netsuite
c
AI generated answer (using internal Slack threads):
To create a saved search that returns the bills internal id that is related to the PO in NetSuite, you can follow these steps: 1. Navigate to the saved search creation page in NetSuite. 2. Select the record type as 'Purchase Order'. 3. In the criteria section, add a new criteria 'Billing Transaction : Internal ID'. This will filter the POs that have a bill associated with them. 4. In the results section, add a new column 'Billing Transaction : Internal ID'. This will display the internal id of the bill associated with the PO. Remember, if a PO has multiple bills associated with it, this search will return multiple rows for the same PO, each row having a different bill's internal id. Also, if you want to include POs that are open with or without bills, you can add another criteria 'Status' and set it to 'Open'. This will filter the POs that are open, and the 'Billing Transaction : Internal ID' criteria will ensure that if there are bills associated then it will show what's been billed. Please note that this approach might not work perfectly if there is one bill for multiple lines as it adds bill amount for each line. You might need to add 'Billing Transaction : Main Line = true' into your criteria to avoid this issue. ****** 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.849985242
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.844425797
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.833902121
Please provide your feedback on this answer.