UPDATE INVN_SBS
update invn_sbs set max_disc_perc1 = 100
execute the above, wait for it to return a single blank cell. Then type
COMMIT
and execute that. At this point the database has been updated.
I had to use this for R3 v9 client who imported data from v8 up to v9. V8 has max disc of 100, v9 defaults to 0. Otherwise this client was receiving an error on every item that it was beyond it’s maximum discount percentage.