I have a question. How do I look up a related rec...
# suitescriptp
Phillip
04/17/2020, 5:49 PMI have a question. How do I look up a related record from a sublist? I am trying the following but its not working: var accountdata = search.lookupFields({
"type": "account",
"id": accounttype,
"columns": ["accttype"]
});
b
battk
04/17/2020, 5:54 PMdepending on the sublist, you might be able to load the record using N/record and get data using a sublist related method
battk
04/17/2020, 5:54 PMmore consistent is doing a search for equivalent data
p
Phillip
04/17/2020, 5:56 PMI am trying to do a search. How would I do a search to get the type of the account?
b
battk
04/17/2020, 5:56 PMrecordtype
battk
04/17/2020, 5:59 PMif you are looking for the column with the label
Account Typetypep
Phillip
04/17/2020, 6:03 PMI am looping through journal entry lines and I need to look up the account type for each line. what am I doing incorrectly?
k
Kevin
04/17/2020, 6:03 PMUntitled
Kevin
04/17/2020, 6:05 PMYou will get account type
b
battk
04/17/2020, 6:06 PMyour questions get weirder and weirder
battk
04/17/2020, 6:06 PMaccounttype is a field on the line sublist
✔️ 1
battk
04/17/2020, 6:06 PMyou dont need to do a search
k
Kevin
04/17/2020, 6:07 PMWhat is your intension to do with it
p
Phillip
04/17/2020, 6:10 PMI missed that. thank you!
Phillip
04/17/2020, 6:11 PMI am trying to set the journal entry approvals to route differently if its a system generated journal entry
k
Kevin
04/17/2020, 6:12 PMvar rec = nlapiLoadRecord(nlapiGetRecordType(), nlapiGetRecordId());Kevin
04/17/2020, 6:12 PMuse in console to see on any record type
Kevin
04/17/2020, 6:17 PMWell, you can check field
isreversalTp
Phillip
04/17/2020, 6:21 PMdo you know if you can filter out rev rec entries by looking at the reversal flag? do you know if a workflow or script runs first?
b
battk
04/17/2020, 6:26 PMmight want to do a search to see who created the record
p
Phillip
04/17/2020, 6:30 PMthanks
k
Kevin
04/17/2020, 6:30 PMAs per my understanding script will be first than workflow
p
Phillip
04/17/2020, 6:32 PMgreat. I think I have a plan now. thank you both for your help!
k
Kevin
04/17/2020, 6:32 PM4 Views