formula to show the disposal date in lease payment saved search

AI generated answer (using internal Slack threads):

Based on the conversations provided, there isn't a direct discussion about a formula to show the disposal date in lease payment saved search. However, there are discussions about creating formulas in saved searches for different purposes. For instance, one user was trying to create an alert for payments made outside of the designated terms period for a discount. They were advised to try using the

{termsdiscountdate}

in a formula, similar to what was done in a SuiteAnswers article. Another user was trying to recreate a formula in a saved search and was suggested to use a formula field like this:

FLOOR(NVL({paymentdate},{today})-{invoicedate})

and make the summary type of the field = average; show totals for the saved search. Lastly, a user was looking for a formula in saved searches for the number of business days. They were suggested to use the following formula:

Formula(Numeric) | to_char(last_day(trunc({today})),'DD')-((trunc(last_day({today}),'IW')-trunc(trunc({today},'MONTH'),'IW'))/7*2)-(decode(to_char(last_day(trunc({today})),'D'),1,2,7,1,0))+(decode(to_char(trunc({today},'MONTH'),'D'),1,1,0))

. To show the disposal date in lease payment saved search, you might need to create a formula that references the disposal date field in your lease payment records. However, without more specific information about your NetSuite setup and the fields available in your lease payment records, it's difficult to provide a more specific formula. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******