Melvin
02/11/2025, 11:13 PMCeligo AI
02/11/2025, 11:13 PMAI generated answer (using internal Slack threads):To create a report that shows Unbilled AR by customer, you can leverage the power of NetSuite's Saved Search functionality. Here's a step-by-step guide on how you can do this: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select the "Transaction" record type. 3. On the Criteria subtab, set the following filters: - Type: Any Of Sales Order - Main Line: Yes - Status: Any Of Sales Order:Pending Billing 4. On the Results subtab, add the following fields: - Name (this represents the customer) - Amount Unbilled 5. (Optional) On the Summary subtab, you can group the results by customer and sum the unbilled amount. 6. Save and Run the search. This will give you a list of all Sales Orders that are pending billing, grouped by customer, with the total unbilled amount for each customer. Please note that this is a basic setup and might need to be adjusted based on your specific business processes and NetSuite configuration. For example, if you also have cash sales or direct invoices, you might need to adjust the criteria accordingly. ****** 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
02/11/2025, 11:14 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.844967186
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.832584
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.82741046
Celigo AI
02/11/2025, 11:14 PM