You’re offline. This is a read only version of the page.
580
Has anyone successfully inserted customers into HQ programmatically? We need to do this to insert employees as customers from an outside source. It seems fairly simple, even incrementing that ID/HQID (1073741825) number manually. However, when one of the stores adds a global customer locally, it adds it to HQ with an existing ID/HQID. This causes havoc, duplicating and overwriting a customer at the same time between the stores and HQ. Is there a table with a counter in it in the RMS database that I'm missing? Any help is appreciated. I am an RMS certified partner.
thanks,
Mary
*This post is locked for comments
Ramy,
Thanks!
I was never programmatically creating customers with duplicate ID's, but when the store added new customers (rarely), it created ones with duplicate ID/HQID's. Now I understand why.
I looked at a Customer insert program I wrote ten years ago and I used that formula - AutoID + 1073741824. For some reason with this client, I used Max(ID) + 1. It hasn't been a problem until recently. I guess we just got lucky.
Thanks for fast replay, but I got confused because of 24 and 25 numbers are very rare. whatever, when you add any new customer to HQ you must add ID = AutoID + 1073741824 also for HQID to get a unique id for both ID and HQID.
if you are using this formula then no duplication will occur.
I think that's what I said I did. So is the database corrupt? Has anyone else seen this happen?
thanks,
Mary
when customer added to store it takes local ID after that when customer record uploaded to HQ and globalization confirmed from HQ the id changed at HQ and reflected ID to the same and another stores next upload time so no duplication will occurred if you defined from HQ but you must take in consideration the last ID generated from HQ.
no another tables is required to define customer without accounting information or details.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (