We're looking to run a report of customer payments...
# ask-stanley-ai
c
We're looking to run a report of customer payments received that includes what invoice the payment was applied to.
c
AI generated answer (using internal Slack threads):
To run a report of customer payments received that includes what invoice the payment was applied to, you can use the 'Saved Search' feature in NetSuite. Here's a general guideline on how to do it: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select 'Transaction' from the list. 3. In the 'Criteria' tab, set the 'Type' to 'Payment'. 4. In the 'Results' tab, add the fields you want to display in your report. For instance, you might want to include 'Name', 'Date', 'Amount', 'Invoice Number', etc. 5. Use the 'Applying Transaction' join to link the payment to the invoice it was applied to. This can be done in the 'Results' tab by selecting 'Applying...' from the 'Field' dropdown and then selecting the specific fields you want to include in your report (e.g., 'Applying Transaction', 'Applying Transaction Number', 'Applying Transaction Amount', etc.). 6. Save and run the search. This will give you a report of all customer payments and the invoices they were applied to. You can further customize this search to suit your specific needs, such as adding filters, conditional highlighting, and formulas. ****** 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.860717893
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.847900569
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.844543576
Please provide your feedback on this answer.