You're probably looking for the `appliedtotransact...
# suitescripte
erictgrubaugh
09/02/2020, 2:14 PMYou're probably looking for the
appliedtotransactionđ 1
h
Henrik Ulvenäs
09/02/2020, 2:45 PMEverything seem to work except getting 'refnum' from apply sublist. It gives me a searchColumn error:
An nlobjSearchColumn contains an invalid column, or is not in proper syntax: refnnum.
I have tried 'otherrefnum' but that gives me nothing. Do you have any idea why 'refnum' gives me an error?
e
erictgrubaugh
09/02/2020, 2:47 PMI think
refnumtraniderictgrubaugh
09/02/2020, 2:50 PMalso that error message, if copy-pasted, says
refnnumnh
Henrik Ulvenäs
09/02/2020, 2:52 PMI already get the tranid from the body but also need 'refnum' to know which bill payment to confirm in a list.
Ah, thanks, I removed the 'n' but still same error.
e
erictgrubaugh
09/02/2020, 2:55 PMrefnumâ¤ď¸ 1
h
Henrik Ulvenäs
09/02/2020, 2:57 PMOk, how do I get 'refnum' from the apply sublist on the vendorpayment record in a search?
https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/script/record/vendorpayment.html
b
battk
09/02/2020, 5:27 PMif you are not interested in things like the credits sublist, then search could be an option for you
battk
09/02/2020, 5:33 PMgenerally the easiest way to find out which column you need is to build the search in the ui first
đ 1
battk
09/02/2020, 5:33 PMyou can run the search and see what data is in each column
h
Henrik Ulvenäs
09/03/2020, 5:11 AMThank you guys! I found the column I was looking for eventually via saved search:
search.createColumn({
name: "transactionname",
join: "appliedToTransaction",
label: "Transaction Name"
}),
21 Views