Hi, got error when add discount item with custom p...
# suitescriptg
george085
03/01/2021, 10:08 PMHi, got error when add discount item with custom price level,{"type":"error.SuiteScriptError","name":"*INVALID_FLD_VALUE*","message":"*You have entered an Invalid Field Value -11.99% for the following field: porate*", Does anyone know what to do. I tried rate field too, get same error. thank you
b
battk
03/01/2021, 10:10 PMwhat does the code look like
g
george085
03/01/2021, 10:19 PMsaleOrderRecord.selectNewLine({
sublistId: 'item'
});
saleOrderRecord.setCurrentSublistValue({
sublistId: 'item'
, fieldId: 'item'
, value: 32667
});
saleOrderRecord.setCurrentSublistValue({
sublistId: 'item'
, fieldId: 'price'
, value: -1
});
saleOrderRecord.setCurrentSublistValue({
sublistId: 'item'
, fieldId: 'porate'
, value: '-11.99%'
});
saleOrderRecord.commitLine({
sublistId: 'item'
});
b
battk
03/01/2021, 10:22 PMbattk
03/01/2021, 10:23 PMand you probably want the rate column
g
george085
03/01/2021, 10:32 PMok, I will try and update with you later, thanks
george085
03/01/2021, 11:52 PM@battk not working, got new error {"type":"error.SuiteScriptError","name":"USER_ERROR","message":"Please enter a value for amount." tried on both rate and porate field
b
battk
03/01/2021, 11:57 PMand the code?
g
george085
03/01/2021, 11:59 PMsaleOrderRecord.selectNewLine({
sublistId: 'item'
});
saleOrderRecord.setCurrentSublistValue({
sublistId: 'item'
, fieldId: 'item'
, value: 32667
});
saleOrderRecord.setCurrentSublistValue({
sublistId: 'item'
, fieldId: 'price'
, value: -1
});
saleOrderRecord.setCurrentSublistText({
sublistId: 'item'
, fieldId: 'porate'
, value: '-11.9%'
});
saleOrderRecord.commitLine({
sublistId: 'item'
});
b
battk
03/02/2021, 12:05 AMmake both the changes i recommended
battk
03/02/2021, 12:05 AMand read the doc i listed earlier to see the differences in setCurrentSublistText and setCurrentSublistValue
battk
03/02/2021, 12:05 AMthey dont use the same parameters
g
george085
03/02/2021, 12:09 AMwow, didn't realise that. my bad
george085
03/02/2021, 1:46 AMnow the error is back to where I was at beginning
george085
03/02/2021, 1:47 AM Copy code
saleOrderRecord.selectNewLine({
sublistId: 'item'
});
saleOrderRecord.setCurrentSublistValue({
sublistId: 'item'
, fieldId: 'item'
, value: 32667 // 15560
});
saleOrderRecord.setCurrentSublistValue({
sublistId: 'item'
, fieldId: 'price'
// , value: 45 //COTD
, value: -1
});
// important use instead of 'rate'
saleOrderRecord.setCurrentSublistText({
sublistId: 'item'
, fieldId: 'porate'
, text: '-11.9%'
});
saleOrderRecord.commitLine({
sublistId: 'item'
});george085
03/02/2021, 1:47 AM"type":"error.SuiteScriptError","name":"INVALID_FLD_VALUE","message":"You have entered an Invalid Field Value -11.99% for the following field: porate",
george085
03/02/2021, 1:48 AMtried to both porate and rate fields
b
battk
03/02/2021, 2:03 AMand the error and code for rate?
g
george085
03/02/2021, 2:30 AM"type":"error.SuiteScriptError","name":"INVALID_FLD_VALUE","message":"You have entered an Invalid Field Value -11.99% for the following field: porate",
george085
03/02/2021, 2:31 AM Copy code
saleOrderRecord.selectNewLine({
sublistId: 'item'
});
saleOrderRecord.setCurrentSublistValue({
sublistId: 'item'
, fieldId: 'item'
, value: 32667 // 15560
});
saleOrderRecord.setCurrentSublistValue({
sublistId: 'item'
, fieldId: 'price'
// , value: 45 //COTD
, value: -1
});
// important use instead of 'rate'
saleOrderRecord.setCurrentSublistText({
sublistId: 'item'
, fieldId: 'porate'
, text: '-11.9%'
});
saleOrderRecord.commitLine({
sublistId: 'item'
});b
battk
03/02/2021, 2:31 AMnope
battk
03/02/2021, 2:31 AMthats for porate
battk
03/02/2021, 2:31 AMwhich is not rate
g
george085
03/02/2021, 2:31 AMI tried rate, had same error
b
battk
03/02/2021, 2:31 AMunlikely
battk
03/02/2021, 2:32 AMerror message should be different
g
george085
03/02/2021, 2:51 AMam trying set rate again, will let you know
s
Sciuridae54696d
03/02/2021, 5:56 AMwith the field explorer, if you're trying to set the prorate, it looks like a 2d.p currency field
Sciuridae54696d
03/02/2021, 5:58 AMg
george085
03/02/2021, 10:27 PM@battk setCurrentSublistText works, thank you very much
george085
03/02/2021, 10:32 PM@Sciuridae54696d it doesn't work on porate
george085
03/02/2021, 10:32 PMsalesOrder.setCurrentSublistValue({
sublistId: 'item'
, fieldId: 'porate'
, value: '-11.99'
});
george085
03/02/2021, 10:32 PMgot error "type":"error.SuiteScriptError","name":"USER_ERROR","message":"Please enter a value for amount.", from aborve
george085
03/02/2021, 10:34 PMwill get same error if do salesOrder.setCurrentSublistText({
sublistId: 'item'
, fieldId: 'porate'
, text: '-11.99'
});
b
battk
03/02/2021, 10:40 PMsetCurrentSublistText is for when fields have different behaviors for different values
battk
03/02/2021, 10:41 PMfor example, the rate is normally a currency field, but can also be set with percentages
battk
03/02/2021, 10:42 PMsetValue works for the currency side, setText for percentages
battk
03/02/2021, 10:44 PMits why i said in the beginning you have to do both of my suggestions
battk
03/02/2021, 10:45 PMporate is just a normal currency field and has no percentage related behavior
5 Views