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!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Assess Finance Charges on Past Due Invoices versus Average Daily Balance
When we run the assess finance charge module, NetSuite creates an invoice based on all open invoices. It appears that it creates the finance charge based on average daily balance though this is not specifically called out anywhere:
(Finance Charge Fee Percent/365) * average daily balance
We need to assess finance charges on past due invoices, and not on invoices that are still current (not past due and still within Terms). For anyone offering client payment terms (Net 30, Net 45, Net 60 etc) this is the common approach. Any easy methods to do this natively in NetSuite?
((Finance Charge Fee Percent/365) * past due invoice) * days past due
0