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!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: My Accounts

sandeep
Posts: 3

My Accounts Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Jul 08 6:52 AM

My Accounts tab is accidently deleted from SLX client. Can somebody please suggest me how to restore the same or give me the formula by adding a new group

[Reply][Quote]

Steve Robertson
Posts: 146

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

Posted: 25 Jul 08 8:17 AM

Hi Sandeep,

You could restore a back up of the database and create a bundle containing your group then apply to your system. You will need to clear out the synch stuff so that you do not contaminate your live remotes.

The group SQL is:

SELECT A1.ACCOUNTID, A1.ACCOUNT, A2.CITY A2_CITY, A2.STATE A2_STATE, A1.MAINPHONE, A1.TYPE, A1.SUBTYPE, A1.STATUS, A1.ACCOUNTMANAGERID, A1.SECCODEID, A1.ACCOUNT_UC FROM ACCOUNT A1 INNER JOIN ADDRESS A2 ON (A1.ADDRESSID=A2.ADDRESSID) WHERE (A1.ACCOUNTMANAGERID=:userid) ORDER BY A1.ACCOUNT_UC ASC

Add a condition to the Group:
Account.Accountmanagerid = :userid
Use value as a literal is checked
Case Sensitive Compare is checked

Cheers,

Steve

[Reply][Quote]

Phil Parkin
Posts: 819

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

Posted: 27 Jul 08 6:19 PM

DB restore is a bit drastic! I suggest you just recreate and release the group as necessary ... as per the SQL above.

Phil

[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 © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/26/2024 3:25:11 PM