In a saved search, can you show what items are unb...
# ask-stanley-ai
t
In a saved search, can you show what items are unbilled on a sales order in netsuite? or what amount is unbilled?
c
AI generated answer (using internal Slack threads):
Yes, you can show what items are unbilled on a sales order in NetSuite using a saved search. You can leverage the 'Amount Unbilled' results field in your saved search on sales orders. This field will give you the unbilled amount for each sales order. Here is a step-by-step guide on how to do this: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select 'Transaction' as the record type. 3. In the Criteria subtab, set the following filters: - Type = Sales Order - Main Line = False (This will exclude the main line of the sales order and only show the line items) 4. In the Results subtab, add the following fields: - Name (This will show the name of the item) - Amount (This will show the total amount of the item) - Quantity Billed (This will show the quantity of the item that has been billed) - Amount Unbilled (This will show the unbilled amount of the item) You can also calculate the unbilled amount manually by using a formula. For example, you can use the formula
Amount - (Quantity Billed * Rate)
to calculate the unbilled amount. Please note that the 'Amount Unbilled' field is not available on the sales order record itself, but it is available in saved searches. ****** 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.865726829
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.860773683
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.856660783
Please provide your feedback on this answer.