Vendor/Supplier - Next Default Code Number
Vendor/Supplier - Next Default Code Number
(OP)
Is there *any* way to reset what the next default code number is for vendors/suppliers (to a lower number)? Any way at all?
Are you a
Computer / IT professional?
Join Tek-Tips Forums!
Computer / IT professional?
Join Tek-Tips Forums!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts - Keyword Search
- One-Click Access To Your
Favorite Forums - Automated Signatures
On Your Posts - Best Of All, It's Free!
- Students Click Here
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Talk To Other Members
RE: Vendor/Supplier - Next Default Code Number
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