Craig
06/18/2025, 10:14 AMtexmc
06/18/2025, 7:10 PMJacob D
06/18/2025, 10:55 PMJacob D
06/18/2025, 10:58 PM"MIN(formulanumeric)":"0","MIN(formulanumeric)_1":"0","MIN(formulanumeric)_2":"0"
I've tried formulanumeric, formulanumeric_1, formulanumeric_2, but that doesn't work. I've tried creating the columns in the script and giving it a custom name, but that doesn't work either...Jacob D
06/18/2025, 11:03 PMnSearch.createColumn({
name: 'formulanumeric1',
summary: 'MIN',
formula: 'CASE WHEN {memberitem.inventorylocation} = {memberitem.preferredlocation} THEN NVL({memberitem.locationquantityavailable}, 0) END'
})
Armanda
06/19/2025, 3:03 AMSarim Khan
06/19/2025, 9:56 AMSlava
06/19/2025, 10:46 AMSimon
06/19/2025, 3:11 PMJosé Gómez
06/19/2025, 6:15 PMCraig
06/20/2025, 10:58 AMsoFulfillment.getCurrentSublistSubrecord({
sublistId: 'item',
fieldId: 'inventorydetail',
});
The resulting IF now has inventory details set on each of the fulfilled lines that matches the quantitycommited from the lines on the sales order.
I thought I would have to set the quantity and status but the transform appears to be pulling those through automatically after adding the above code.
I appreciate getCurrentSublistRecord actually adds the sublist record if not already present, I am surprised that the above code is enough to make the IF pull through the status and quantity though.veenasa garimella
06/23/2025, 9:43 PMMuhammad Kamran
06/24/2025, 7:46 AMBoris
06/24/2025, 5:39 PMemail.mergeEmail()
but I'm not sure how to add data sources to email.
in pdf template, we add data source by renderer.addRecord()
and renderer.addCustomDataSource()
And we can use that in PDF template by record.fieldid,
Could someone help me how to do those same things in email renderer please?Boris
06/24/2025, 6:02 PMGojo
06/25/2025, 6:34 AMcreece
06/25/2025, 4:23 PMColeenjae Moralidad
06/26/2025, 6:30 AMMarwan
06/27/2025, 1:02 PMshree sashti
06/30/2025, 12:40 PMdarrenhillconsulting
06/30/2025, 4:20 PMArmanda
07/01/2025, 10:08 AMLuis
07/01/2025, 2:00 PMStefan Holodnick
07/02/2025, 2:41 PM<?xml version="1.0"?>
<!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd">
<pdfset>
<pdf src="<https://xxxxxxxxxx.app.netsuite.com/core/media/media.nl?id=7901&c=xxxxxxxxxx&h=_ekndKfcsGcfW9OA3F270Vh_ZprbeZ8iUBD6ZovktckNAN8c&_xt=.pdf>" />
<pdf src="<https://xxxxxxxxxx.app.netsuite.com/core/media/media.nl?id=7363&c=xxxxxxxxxx&h=-EbGbJlGJ346A2DNt6C7S31ELWc8VwDg-5UP-CJb4GQr1xTy&_xt=.pdf>" />
</pdfset>
I have generated the files as available without login.
Any suggestions on what is wrong here?Kristopher Wood
07/02/2025, 7:45 PMshree sashti
07/03/2025, 4:49 AMFelix Divall
07/03/2025, 7:39 AMIsaac M
07/03/2025, 4:45 PMEdgar Valdes
07/03/2025, 8:43 PMJeff Subat
07/05/2025, 4:31 PM