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.
Detecting total deposits on a SalesOrder
Hello All,
I'm working on a routine to determine the total amount of deposits against a SalesOrder. Here's what I have so far. I'd love a second set of eyes on this to see if there is a better way to handle this or if there are any edge cases I'm missing.
Thanks in advance!
function getCustomerDepositTotalForSalesOrder(salesOrderId) { var filters = [ new nlobjSearchFilter('salesorder', null, 'anyof', salesOrderId) ]; var columns = [ new nlobjSearchColumn('total', null, 'sum') ]; var results = nlapiSearchRecord( 'customerdeposit', null, filters, columns ); if(!results) { log("no deposits found for record: " + salesOrderId) return 0; } return results[0].getValue('total', null, 'sum') } 0