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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Saved Search for Sales Order Billing Schedule Dates
Is there a way to create a saved search that would pull all the bill dates under the Billing Schedule sublist? (We have Advanced Billing feature turned on)
Our navigation is view Sales Order > Billing subtab > Schedule sublist.
I could only pull the Next Bill date and no other dates!
I am wondering if an alternate solution would be to calculate based on a saved search formula. Perhaps check the Start Date and use sql functions to split up Bill Dates according to the Billing Schedule (quarterly, twice a month, annually, etc) but that sounds like a very convoluted way to do it.
4