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!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Problem with Account addresses

Lou
Posts: 81

Problem with Account addresses Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Apr 08 9:42 AM

This is for v6.2.6.

We had a situation in which several accounts and contacts lost their addresses. Because the entire address record is lost, users cannot find the account when they perform a lookup. The account still exists, but it does not show up in the lookup results. This can be fixed for each account (one-by-one) if we get a new ID for the ADDRESS table and fill in the street, city, state, and ZIP.

When tried to do this to fix all of the accounts at once, we failed. The address records were inserted, but you cannot see the accounts in the lookup results.

Does this sound like something that anyone else has encountered? Please let me know if I need to provide any more details or if you have any suggestions.

THANKS!

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Problem with Account addresses Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Apr 08 10:49 AM

Yikes!

A good idea to fix this might be to run the integrity checker in the administrator. This does check for accounts that are not properly linked to an address record. Give that a try and it will likely fix this.

-Ryan

[Reply][Quote]

Dan Carvin
Posts: 227

Re: Problem with Account addresses Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Apr 08 10:49 AM

Your fix needs to put the accountid into addresss.entityid as well as the addressid into account.addressid. You may also need to have one and only one address per account have isprimary = 'T'.

[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): 8/23/2025 10:26:29 AM