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.
"Overdue Balance" for Child Entities
We use a Search to grab customers with overdues >10 and > 40 days overdue and email them a "friendly" reminder to pay us.
this works fine for individual customers but some customers we invoice are child entities.
eg ABC Group Ltd (parent)
ABC North (child)
ABC South (child)
ABC North overdue could be 1000
ABC South overdue could be 500
but if you look on the Financial tab of ABC North or ABC South it would show 1500 - this in itself is wrong but also the Search doesn't return ABC North or ABC South unless you set Overdue Balance in the Search to 0.0!
0