This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

for every item on your order, loop through the rows and count quantity

Best to get qty committed from a search otherwise I’m looping through every line item over and over again. Some sales orders are around 800 lines

Thats horrific, but you only need to loop once if you are willing to store the item counts

How would I do that? I’d need to look at index[0].id then do if id===id for every item

then if there’s match, I do total = item.qty + item.qty

That said, i would prefer doing the first thing I said and remember which lots are assigned. You would have to do it anyways if you are dealing with duplicate items

So yeah, keep track of each lot qty then minus the lot quantity by how much I just assigned

have to allocate inventory based on earliest lot expiry date