Opening an inventory items errors -'The value property cannot be set ...outside the range ...MinValue .. MaxValue ...'

Owned by Beth Blok (Unlicensed)
Last updated: Sept 09, 2016
1 min read

Problem

Loading, drilling to scrolling to an inventory item errors and then loads

Solution

The issues may be caused by IN_Main.DecimalPlaces being > 6 (6 is the limit in version 7)  and/or IN_Main.DirectTax being a negative number e.g. -1.00 (permitted in version 6 but not in 7)

Run one of both of these script to corrects

  1. UPDATE IN_Main SET DecimalPlaces = 6 WHERE DecimalPlaces > 6

  2. UPDATE IN_Main SET DirectTax = '0.000000' where DirectTax < '0.000000'