NS AdminA
04/02/2025, 3:16 AMCeligo AI
04/02/2025, 3:16 AMAI generated answer (using internal Slack threads):To get the Purchase Order (PO) amount billed as of a certain date, you can create a saved search in NetSuite. Here are the steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Purchase Order from the list. 3. In the Criteria subtab, you can add the following filters: - Status: Any of Open - Date: on or before the date you want to check 4. In the Results subtab, add the following fields: - Name (this will give you the PO number) - Amount (this will give you the total amount of the PO) - Quantity Billed (this will give you the quantity that has been billed) - Formula (Numeric) with the formula
quantitybilled*rate
(this will give you the amount that has been billed)
5. Save the search.
This will give you a list of all open POs as of the date you specified, along with the total amount of the PO and the amount that has been billed.
Please note that NetSuite manages quantities, not money-based draw-downs from POs. If you want to handle money-based draw-downs, you might need to use a workaround like setting the quantity to a large number and the rate to $1.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
04/02/2025, 3:17 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823413849
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.82300204
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819620669
Celigo AI
04/02/2025, 3:17 AM