Vendor/Supplier - Next Default Code Number

[mlb90]

Is there *any* way to reset what the next default code number is for vendors/suppliers (to a lower number)? Any way at all?

 

[flutepic]

SELECT stringvalue, * FROM bacosettings

WHERE settingname = 'accountcodenextnumber'

--to find the next account number (vendor/supplier, customer/debtor)

Update bacosettings Set stringvalue = ###

WHERE settingname = 'accountcodenextnumber'

--CAUTION! Keep in mind that there may also be a Synergy database involved in where this next account number will pull
If you go too low, you may run into the case of the account number already existing as well