Tag: Scripts

In my last blog I talked about how to fix timeless activities to show the correct date in sdata grids. A different fix needs to be put in place in order to have these same dates show correctly if they are added to a column in a group layout for the Infor CRM 8.3.09 web client. Luckily a similar approach to...

We had an issue with the Database Manager on our 8.3.6 Infor system where the Database Manager would start to open all of the tables but at the last table, it would hang and eventually crash the Administrator or the Architect.  The tables would open correctly in SQL Management Studio so we felt certain the database was not corrupted.

In a previous post I discussed using the slxprofiler to find bottlenecks in SalesLogix sql statements. Today we will examine one query and create an Index with the Database Engine Tuning Advisor.

In older databases, the main tables are locked down, which is why we always used extension tables. However, you can get around that by setting the UserDef field in the SecTableDefs table to "T" for all records where tablename = Whatever tablename your looking at. If there's a specific requirement for those fields to be in the main table, then we'll temporarily make that change to the sectabledefs data to add the fields.

It comes up quite frequently that there are records owned by a user so you cannot retire that user. If you have reassigned all activity records and realigned all account and contact records with the territory realignment tool then there may be private records owned by this user

In SalesLogix 7.5 you only get one chance to select your adhoc contact group for Intellisync, usually that group is SyncSalesLogix. What if you selected the incorrect group

There was an issue reported by a customer when running the Current Activities - Sample report on the network client, namely, he could not select a start or end date using the date picker. The system immediately returned

Here is a problem we found with the SalesLogix 7.2 Web client. After logging in, the login screen goes away but an error message is thrown before any other screen appears

I wrote a blog post two weeks ago that described a problem with the Email Ticket Information button when contacts were imported into SalesLogix 7.5. That issue was found in the LAN client. Here is a similar issue we found in the Web Client.

There may be a time that you want to upload a database but would prefer not to share all of your data. This script will leave all of the SalesLogix customizations intact but will remove