Untitled Document
Microsoft Dynamics RMS Experts
  Register   Login
 Search
RMS Experts
 
  You are Here: Dynamics RMS Community ... Dynamics RMS and POS Forums
 
RMS and POS Forums
Subject: HQIDs in Customer table in HQ database

You are not authorized to post a reply.   
Author Messages
DavidFromAdvantage
Posts:1

04/28/2008 1:21 AM Alert 

Does anyone know how RMS HQ assigns HQIDs and StoreID/IDs to items in the customer table?

 

We're trying to insert customers into the table programmatically, but HQ will assign its own value for the HQID, and I can't figure out where it gets its IDs from.  If we insert an item with the next consecutive value, HQ will also use that value if the user adds a new customer, causing a duplicate HQ.  If we use a HQID that is nowhere near what RMS is using, it will overwrite the HQID to some other value if the user edits the record, which could cause duplicates at the stores.

Any ideas?

You are not authorized to post a reply.
Forums > Microsoft RMS and POS > General RMS and POS Discussion > HQIDs in Customer table in HQ database



ActiveForums 3.6
Sponsor
HeroPointsSkyscraper160x600
Get RMS Training today!
(c) 2006-2012 Retail Hero ®