Hi All, Im trying to create inventory worksheet using script but for some items im getting below error:

Value -Infinity outside of valid min/max range for field invtnewunitcost

I'm not using this field to set the value in the script still im getting this error not sure why. Anyone have idea on this issue?

make the same change you are making in script in the ui

UI it is working as expected but in script only it is throwing error

just because you didnt set a field doesnt mean that you didnt set a different field that sources it

Yes I can understand but it is not showing the field in record also

which columns do you have on your adjustment sublist?

I tried to get field using field explorer and I didn’t find and I checked the record xml also

and what are their ids

Let me check once

new cost here would be the new value divided by the new quantity

Understand

your account may have other costing methods used, but average is the one likely to be causing division related problems

Got it..let me check from my side and get back to you. Thank you