I have been asked by our accounting team to create an alert to let them know if a Customer makes a payment and they make that payment outside of the designated terms period for a discount, but yet take the discount. While you can visually see it on the screen it is still very easy to miss if your making 100's of payments a day and are just cranking through them. But when I try to use the Disc. Date field in Apply Sublist in a formula, it either breaks the formula, or I get no results. Based on what I know, this field is auto calculated by NetSuite based on the terms the customer has set up. Anyone been able to utilize this field in a saved search formula?

Have you looked at this? Create Saved Search for Bills Paid Beyond Discount Period Granted it's on the AP side, not the AR side, but I think you could do basically the exact same thing there. To add onto this, do you really need that discount date? Can't you just evaluate the payment date against the terms?

We tried that and because the terms are different for various customers, we are not accurately able to pull just the section that indicates the discount time, for example, we have 2% 30 Net 31 and 10% 30 Net 31, we can never with accuracy pull just the 30.

and you tried pulling in the {termsdiscountdate} in a formula similar to what was done in the SuiteAnswers article?

Yes, just did and I get no results, but I should get 1 payment transaction.

if you just make a formula that only outputs {termsdiscountdate} does that give you anything/the values you are expecting?

No, it comes back blank or null, also, I am pulling it from Related records and the Applied To Transactions. There is no other way to pull the data from the Applied Sublist on a Customer Payment record into a search.

what if you run the base search on the customer invoice itself and then reach to the paying transaction to get all the payment details/fields, similar to what they are doing in the help article? Or are you doing additional joins that are not to the invoice from the payment record?

Have not tried that, doing a Payment Type Transaction

Sounds like that might be the only way to do this via saved search, but give it a test and see what you get. Might have some different options if you were open to doing this as a SuiteAnalytics Workbook instead. 🤔

Thanks @James Morris - doing it via the Invoice gave me exactly what I wanted. Thank you so much!

Happy to help. Glad it worked out!