slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Data & Imports Forums - T-SQL & Queries
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to T-SQL & Queries | New Thread

View: Search:

Author

Thread: ACCOUNTID conflicts

Steven Jowett
Posts: 10

ACCOUNTID conflicts Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Feb 08 9:57 AM

I have two independant SLX systems. One of these installations is for a company that is part owned by the other. The parent company would like to copy new accounts and contacts added during the day into the subsidiary company's SLX, into the parent's SLX.

For this I have set up a Linked Server on the Parent company's SQL Server to the Subsidiary's SQL Server via our WAN. No problem. The problem I am experiencing is that I now have a conflict of Ids, despite there being a Sync Server setup on the Parent system, with the Site Id of LO9E.

I expected the ACCOUNTID to be like A6LO9E000002 instead of A6LUJ9A000002, but this is not the case.

I would be grateful for any feedback.

[Reply][Quote]

Steven Jowett
Posts: 10

Re: ACCOUNTID conflicts Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Feb 08 11:28 AM

I found the reason for the conflict. The values of SITECODE column in the SITEKEYS table had not been updated

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 5/22/2025 8:36:58 PM