245
We want to use a new Checkbook ID for all cash receipts received from customers (Sales module). The existing checkbook ID will still be used; but, not for these cash receipts.
Is there a way to do a mass update to change the existing checkbook ID from XXXX to YYYY?
Hi Patti!
There are a couple of ways.
Use SmartConnect to do a mass update on all of the customer records you want to have the new checkbook ID.
Run an UPDATE query using SQL on the RM00101 table for the customers you want to use the new checkbook:
UPDATE RM00101 SET CHEKBKID='name of new checkbook' where CUSTNMBR='the customer you want to change'
If you use customer classes, then you could run it on the whole class of customers instead:
UPDATE RM00101 SET CHEKBKID='name of new checkbook' where CUSTCLAS='the name of the customer class of the customers you want to change'
I hope this helps!
Thanks.
Joe
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,399
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
