how can i run a report on payments received that s...
# ask-stanley-ai
n
how can i run a report on payments received that shows the amount before discount was applied?
c
AI generated answer (using internal Slack threads):
To run a report on payments received that shows the amount before discount was applied, you can create a custom saved search in NetSuite. Here's a step-by-step guide on how to do it: 1. Navigate to
Reports > New Search
. 2. Select
Transaction
as the record type. 3. In the
Criteria
tab, set the
Type
to
Payment
. 4. In the
Results
tab, add the following fields: - `Name`: This will display the customer's name. - `Document Number`: This will display the invoice number. - `Amount`: This will display the payment amount. - `Gross Amount`: This will display the amount before discount was applied. 5. Save and run the search. Please note that the
Gross Amount
field represents the total amount of the transaction before any discounts are applied. If you want to see the discount amount, you can add the
Discount Total
field to the
Results
tab. Remember, saved searches are generally more powerful and flexible than standard reports in NetSuite. They allow you to create custom reports that fit your specific needs. ****** 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.841669738
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.825226486
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.817288458
Please provide your feedback on this answer.