In a client script, I am trying to get MSRP price ...
# suitescriptb
b
10/02/2019, 4:33 PMIn a client script, I am trying to get MSRP price on the item record. I've tried item.findMatrixSublistLineWithValue but I am not getting any results.
sublist looks like this:
price1:Array[18]
0:Object
currency:"1"
price_1_:"9.99"
pricelevel:"1"
pricelevelname:"MSRP"
b
battk
10/02/2019, 4:36 PMpricing sublists are annoying to work with, send over the screenshot of what the sublist looks like
battk
10/02/2019, 4:37 PMalternativly, say which of the following features are enabled in your account
battk
10/02/2019, 4:37 PMMultiple Currencies
Multiple Prices
Quantity Pricing
b
b
10/02/2019, 4:37 PMHere is ui, yes, yes, yes but don't use
b
battk
10/02/2019, 4:38 PMouch, thats everything
b
b
10/02/2019, 4:38 PMmessage has been deleted
b
10/02/2019, 4:38 PMtell me about it
b
10/02/2019, 4:40 PMBeen driving me crazy, especially since it was so easy in a scheduled script using 'Base Price'
b
10/02/2019, 4:42 PMI'm trying to set the declared value on field change but maybe I just update them nightly with M/R script
b
battk
10/02/2019, 4:44 PMi believe you do
Copy code
Record.findSublistLineWithValue({
sublistId: "price1",
fieldId: "pricelevel",
value: "1"
});battk
10/02/2019, 4:45 PMto find which line has the price level you are looking for
b
b
10/02/2019, 4:45 PMI'll give it a try, thank you for helping!
b
10/02/2019, 4:46 PMI see, then once I have the line do I call getSublistValue?
b
battk
10/02/2019, 4:46 PMthen use getMatrixSublistField to get the matrix field
b
b
10/02/2019, 4:46 PMok
b
10/02/2019, 6:08 PMThank you for your help, I was able to get the MSRP value with this
b
battk
10/02/2019, 6:21 PM Copy code
var price = item.getMatrixSublistField({
sublistId: "price1",
fieldId: "price",
column: 0,
line: line
});b
b
10/02/2019, 6:22 PM@battk I tried that but price was undefined, I was able to pull it in using .getSublistValue
b
battk
10/02/2019, 6:28 PMwhoops
battk
10/02/2019, 6:28 PM Copy code
var price = item.getMatrixSublistValue({
sublistId: "price1",
fieldId: "price",
column: 0,
line: line
});battk
10/02/2019, 6:28 PMslightly different function name
64 Views