Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Vendor/Supplier - Next Default Code Number
- Thread starter mlb90
- Start date
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
- Status
Similar threads
- Locked
- Question