Does anyone know if NetSuite natively provides a l...
# suitescriptd
Daniel Lloyd
04/21/2021, 3:40 AMDoes anyone know if NetSuite natively provides a link between lines when you transform? I'm transforming Vendor Bills to Vendor Credits and I don't see any linking IDs in the line data on the resulting Vendor Credit. There was orderdoc and orderline from PO to the Vendor Bill.
Would I have to add a UUID to the Vendor Bill lines and pick that up on the transformed credit?
b
battk
04/21/2021, 4:21 AMdo a search
battk
04/21/2021, 4:21 AMuse the applying transaction or applied to transaction join to get the related line
d
Daniel Lloyd
04/21/2021, 4:24 AMYou are right although wouldn't that mean I'd need to save the Bill Credit first?
b
battk
04/21/2021, 4:26 AMyes
d
Daniel Lloyd
04/21/2021, 4:26 AMthanks battk 🙂
b
battk
04/21/2021, 4:31 AMthere might be other fields used to link the two
battk
04/21/2021, 4:31 AMcheck on the transformed record before you save it
d
Daniel Lloyd
04/21/2021, 4:33 AMall good, I did save one earlier and xml viewed it to hunt for IDs, I don't think there'll be anything in the nlobjRecord scope object that wouldn't be in the data committed to the db, and if there were I'm not sure I trust it.
I've got a UUID generation function so I'm just going with that for now.
Appreciate the help very much :)
b
battk
04/21/2021, 4:40 AMsome fields are used by the record model but not returned by it
d
Daniel Lloyd
04/21/2021, 4:40 AMundocumented fields aren't they?
b
battk
04/21/2021, 4:41 AMnetsuite obviously stores the link between the 2 since the applying transaction join works, but it doesnt always return the same data between searches and records
d
Daniel Lloyd
04/21/2021, 4:41 AMyes, that's right
Daniel Lloyd
04/21/2021, 4:44 AMthe trouble is I can't save the record before editing the lines. I didn't know that data normally reserved for return in a search was available in the nlobjRecord returned from record.transform() and I don't know if it's documented if it is. I'm interested to learn about it but my company doesn't allow me a lot of time to get the work done.
Daniel Lloyd
04/21/2021, 4:45 AMI'd already written a UUIDv4 generator so I'm just going to use that with a new transaction column
Daniel Lloyd
04/21/2021, 4:46 AMnext time I come across it I'll dump out the nlobjRecord first and investigate that. You've taught me that much.
2 Views