Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Customer Report
We have created a custom customer field called "Date of Installation" (We install residential roofs). We need a report (saved search) that shows us customers in which no payments, deposits etc have been applied to the invoice within 3 days of the "Date of Installation". We need this report to stay consistent even if payments are made but after the 3 day time frame. (Management needs for sales rep commission purposes).
I have tried to create another field that automatically adds 3 days to the date of installation to come up with a new date field, but did not succeed.
Any help on how to create this report would be greatly appreciated.
0