Hi all, How can we display the total amount of lin...
# generalj
Jericho Kyle Tamayo
09/26/2025, 6:39 AMHi all, How can we display the total amount of line items on the parent custom record form in NetSuite (not a transaction type) without using code?
c
christianRILECPQ
09/26/2025, 10:49 AMHey! To show total line item amount on a parent custom record form (non-transaction) without code, use a Saved Search as a Formula (Currency) field. Create a search on the child record, sum the amount field, and link it via a Summary Search field on the parent form under Custom Fields.
j
Jericho Kyle Tamayo
09/26/2025, 12:55 PMI already tried that one, but i can't see the saved search on the value
s
SunShine
09/26/2025, 4:53 PMColud you specifiy which custom record it is?
SunShine
09/26/2025, 4:54 PMYou want to expose those value on the saved search? or directly on the record?
SunShine
09/26/2025, 4:54 PMWe need to create the UE script to auto-generate that total amount of line-items on the AfterSubmit()
SunShine
09/26/2025, 4:54 PMWithout script it wont work.
SunShine
09/26/2025, 4:56 PMBecause that is the custom-record not Netsuite standard. So Netsuite standard transaction records like Sales Orders or Invoices have the default amount value to show the total of line-items. But since you create this as custom-record we may need customized script for this. Please DM me if this works or any questions. Thanks.
d
David Robinson
09/26/2025, 5:11 PMYou can display the total of child line items on a parent custom record without code by using a saved search with a SUM on the line item field, or by adding the child records as a sublist and enabling sublist totals. If the parent-child relationship is set up correctly, you can also use a roll-up summary field to store the total directly on the parent record.
2 Views