how can i create a report on customer payemnts and...
# ask-stanley-ai
n
how can i create a report on customer payemnts and deposits that shows the disc amount and disc taken amount?
c
AI generated answer (using internal Slack threads):
To create a report on customer payments and deposits that shows the discount amount and discount taken amount, you can use NetSuite's Saved Search functionality. Here's a step-by-step guide on how to do it: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select the record type you want to create a saved search for. In this case, select "Transaction". 3. In the Criteria subtab, set up your filters. You might want to include: - Type: is Payment - Status: any of Open, Pending, Paid In Full - Main Line: is True (to exclude line-level information and only include transaction-level information) 4. In the Results subtab, define the columns that you want to appear in the search results. You might want to include: - Name (to show the customer's name) - Document Number (to show the transaction number) - Amount (to show the transaction amount) - Discount Amount (to show the discount amount) - Discount Taken (to show the discount taken amount) 5. Optionally, in the Summary subtab, you can define summary type for each column in the search results. 6. Click Save & Run to save and run the saved search. Please note that the Discount Amount and Discount Taken fields might not be available in the standard NetSuite fields. If that's the case, you might need to create custom fields to capture this information. ****** 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.80240041
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.801178336
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.800472736
Please provide your feedback on this answer.