Anyone notice the documentation is missing (as far...
# suitescripte
ec
01/12/2023, 6:59 PMAnyone notice the documentation is missing (as far back as I can tell) for this in the Records Browser?
https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2022_2/script/record/itemvendorprice.html
“HTTP method GET is not supported by this URL”
This is for the subrecord on the Inventory Part
ec
01/12/2023, 9:14 PMIn this vein, though, I am having trouble writing to the Vendor Prices sublist on an Item. I get the following error:
Copy code
message: "Invalid vendorcurrency reference key 4."
name: "INVALID_KEY_OR_REF"b
battk
01/12/2023, 9:20 PMmake the vendor that you are trying to create in the ui
battk
01/12/2023, 9:20 PMthen load it in script so that you can inspect the vendor price subrecord to se what it looks like
e
ec
01/12/2023, 9:22 PMthanks. i did this in the ui first, then am testing by loading that exact item and simply editing the first line in the subrecord. trying to play it as safe as possible.
even when I just edit the Vendor Price as below, it for some reason complains about missing the currency (even though I’m editing the line and currency is saved on that line)
SUBREC.setSublistValue({ sublistId: 'itemvendorpricelines', fieldId: 'vendorprice', line: 0, value: 1000 });ec
01/12/2023, 9:22 PMand yes i inspected it (just wanted to let NS know that the docs are - and seemingly always have been - missing this)
b
battk
01/12/2023, 9:22 PMwhat does the subrecord look like while inspecting it
e
ec
01/12/2023, 9:27 PMvar REC = record.load({ type: record.Type.INVENTORY_ITEM, id: 96946 });
console.log(‘vendorcurrencyname’, REC.getSublistValue({ sublistId: ‘itemvendor’, fieldId: ‘vendorcurrencyname’, line: 0 }));
var vendor = REC.getSublistValue({ sublistId: ‘itemvendor’, fieldId: ‘vendor’, line: 0 });
var preferred = REC.getSublistValue({ sublistId: ‘itemvendor’, fieldId: ‘preferredvendor’, line: 0 });
var SUBREC = REC.getSublistSubrecord({ sublistId: ‘itemvendor’, fieldId: ‘itemvendorprice’, line: 0});
var currency = Number(SUBREC.getSublistValue({ sublistId: ‘itemvendorpricelines’, fieldId: ‘vendorcurrency’, line: 0 }));
var price = SUBREC.getSublistValue({ sublistId: ‘itemvendorpricelines’, fieldId: ‘vendorprice’, line: 0 });
console.log(vendor, preferred);
console.log( currency, price);
SUBREC.setSublistValue({ sublistId: ‘itemvendorpricelines’, fieldId: ‘vendorprice’, line: 0, value: 1000 });
SUBREC.setSublistValue({ sublistId: ‘itemvendorpricelines’, fieldId: ‘vendorcurrency’, line: 0 , value:currency });
REC.save();
ec
01/12/2023, 9:28 PM(doing this in the console - could that be my issue???)
i can read in the currency, and actually used that exact value for currency to set the vendorcurrency (with or without wrapping it in Number as you see above) and still failed
b
battk
01/12/2023, 9:28 PMthere are 2 choices you have
battk
01/12/2023, 9:28 PMyou can log your subrecord into the console
battk
01/12/2023, 9:28 PMor you can use the debugger to see what the subrecord should look like
e
ec
01/12/2023, 9:29 PMi was jsut logging into Script Debugger
ec
01/12/2023, 9:30 PMMy problem isn’t inspecting the record anymore; my problem here is that it errors out when writing to the currency field on that subrecord.
ec
01/12/2023, 9:31 PMit errors out on this line
SUBREC.setSublistValue({ sublistId: 'itemvendorpricelines', fieldId: 'vendorcurrency', line: 0 , value:currency });b
battk
01/12/2023, 9:32 PMare you trying to create or edit your item
e
ec
01/12/2023, 9:34 PMhere i am editing just for trial (prob will use this on create later once i get it working)
ec
01/12/2023, 9:37 PMhere’s the stringified value of the subrecord’s sublist
b
battk
01/12/2023, 9:38 PMyou would probably have an easier time creating a new item
e
ec
01/12/2023, 9:38 PMi see currency is a string value ‘4’ - but even when writing that to the line, it’s too tough. Hmm. I’ll try create, thanks. Get back to you later @battk thanks for your help!
b
battk
01/12/2023, 9:38 PMyou are trying to do an operation that you couldnt actually do in the ui
e
ec
01/12/2023, 9:39 PMof course i can…
ec
01/12/2023, 9:39 PM?
b
battk
01/12/2023, 9:39 PMyou wouldnt be able to set the currency field to the same value
e
ec
01/12/2023, 9:39 PMi edit the item, pop up the prices, and boom
ec
01/12/2023, 9:39 PM?
ec
01/12/2023, 9:39 PMsame line
b
battk
01/12/2023, 9:39 PMyou arent changing the currency field to the same value
battk
01/12/2023, 9:39 PMits something you cant actually in the ui
e
ec
01/12/2023, 9:39 PMi TRIED to simply edit the price, and it barked
ec
01/12/2023, 9:40 PMeither way, i tried also to ADD the line (before it existed), but it also didn’t accept. my whole entire issue is the fact that it is rejecting my Currency value and i don’t know why
ec
01/12/2023, 9:40 PMi may be better off in create mode
b
battk
01/12/2023, 9:41 PMwhat you shared so far looks to be an attempt at adding multiple lines with the same currency
battk
01/12/2023, 9:41 PMyou cant actually do that in the ui
e
ec
01/12/2023, 11:04 PMworks in create mode, so we can set this to sleep. who is in charge of documentation though? Records Browser is indeed broken (broken link)
ec
01/12/2023, 11:04 PMthanks @battk again!
4 Views