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

Anyone with a code snippet for grouping same items as one line item in the pdf template and summing up the quantity and amount? Just want to have a starting point for grouping items. Thanks.

<https://gist.github.com/michoelchaikin/0cbe70c350e6078a356b516bc4f8ab38>

That's an example of grouping by class but should be straightforward enough to adapt to item

It’s easiest/best if you sort the list by the element you’ll be grouping on, that way, they will all be consecutive, and you can look for changes to the field as an indicator of when to switch.

<@U29QCJQF3> is it possible to present the item just once? For example, if my invoice has 2 lines in the UI:

Service Item A 100 qty
Service Item A -5 qty

I would like to show it as one liner in the pdf:

Service Item A 95 qty

I think the code you shared still presents all lines but add a subtotal line per group of item?

Sure, you can adapt the technique from my snippet but only print the "subtotal"