I have a script that runs on Transactions that mat...
# suitescriptj
JacksonP
03/05/2021, 2:25 PMI have a script that runs on Transactions that matches that transaction type to a custom record via a List/Record Transaction Type field. The problem I'm having is that when I run a saved search to match the current transaction to the list record, the custom record transaction type field wants the internal id of the transaction type, not the text value ('salesorder'). Does anyone have a solution to match the record to one of these transaction types? (We also rename our transaction types so Sales Order is actually 'License')
s
Sandii
03/05/2021, 2:30 PMFirst thought is try using setText instead of setValue?
j
JacksonP
03/05/2021, 2:38 PMI'm not setting a value on a current record, im making a search to find the correct custom record.
b
battk
03/05/2021, 2:57 PMthe complicated solution is to have your list/record field have a source of
Scripted Record Typebattk
03/05/2021, 2:58 PMadd a filter on the field so that the
List/RecordSearch Typebattk
03/05/2021, 2:59 PMand then have another field that uses sourcing to source the script id so that you have your script id to search against
s
Sandii
03/05/2021, 3:00 PMI don't get what you are doing honestly; if you are not setting a value, why do you need to translate between the different ways record types are displayed?
j
JacksonP
03/05/2021, 3:21 PMOkay @battk thanks for the answer I'll try it out.
JacksonP
03/05/2021, 3:23 PM@Sandii I've built a script that basically just prints a pdf with an advanced pdf template on any record. There's a configuration record that holds the record type and list of advanced pdfs. The issue was matching the record type because netsuite requires an internal id of the sales order type and all I have on the current record is the text value.
b
battk
03/05/2021, 3:24 PMi forgot to mention the easier solution, which is to just hardcode a lookup between internal ids and script ids for the transaction type
j
JacksonP
03/05/2021, 3:25 PMWhat about other netsuite records that aren't transactions?
b
battk
03/05/2021, 3:26 PMtransaction type is not the list/record source you want if you want to include non transactions
j
JacksonP
03/05/2021, 5:32 PMThe intended goal is all records
b
battk
03/05/2021, 5:34 PMprobably just go for Scripted Record Type without the filter i mentioned
j
JacksonP
03/05/2021, 5:34 PMAlright I'll try it, thanks again.
4 Views