Starting in Infor CRM 8.3.04 they added a feature called Contour which can utilize either Google or Bing mapping APIs to geocode the ADDRESS table in Infor CRM and then allow you to map addresses and find other close records. Scott Weber has a nice demo of all the features here. I wanted to get […]
This was an oldie but a goodie that I originally wrote for slxdeveloper.com way, way back in 2005! While most of my work is geared towards developing in the web client now, every once in a while I have to dust of the VBScript brain cells and remember out how to do these things. In […]
In the Infor CRM web client the lookup control’s popup dialog defaults to being something like 750px wide. Sometimes this may not be wide enough to incorporate a lookup whose grid contains a lot of columns. You can modify this behavior by extending the base sDataLookup widget. In a previous post I talked about how […]
In the Infor CRM web client, each user can define for each Entity level what the default group is, as well as the group used in the Lookups. This is normally set by each user from within the web client under the Tools…Options menu item, and then accessing the Groups tab. If you want to […]
We recently had a customer who wanted to find out if there were any references to another SQL database within the SQL views and procedures that had been developed within their Infor CRM database. There is a way to do this by using the sql_modules. Objects of type Store Procedures, Replication Filter, View, Trigger, Scalar […]
I recently have run into a really frustrating behavior of the Currency control in the Infor CRM web client. Running in an 8.3.08 system, the following issues exist out of the box: If you bring up the edit screen for an Opportunity Product, you can see this issue with the Currency control. By default this […]
During the upgrade to Infor CRM 8.3.08 the upgrade process introduces a duplicate APPID row into the APPIDMAPPING table. This is because the APPIDMAPPING table does not contain a unique constraint on the ID (shame, shame): This results in the inability to manage the SData Sync Configuration. You will also see similar errors popping up […]
In the Attachment List’s client side code there were breaking changes to the code from version 8.1x to 8.3x, some of the highlights of this include: The date time columns in the grid are defined with a type attribute of “colDateTime” colDateTime in 8.1 was declared as ‘Sage/UI/Columns/DateTime’ colDateTime in 8.3 is now declared as […]
I thought I would show a way you can check to see if a user is in a specific Team or Department. While there are other ways of accomplishing this also, this is a pretty easy way to check. This may not be the most efficient way of doing it, especially if your teams and […]
The Infor CRM implementation of a checkbox does not use a standard ASP.Net CheckBox control. Instead it uses its own control implementation that inherits from the CheckBox control. One of the things that I struggled with recently was how to both change the text showing with the CheckBox as well as change the color of […]
How to align the toolbar icons that show in a dialog workspace in the Infor CRM web client.
In the Infor CRM web client, quick forms render controls inside of a div. The div is where a lot of the visual attributes are, like how a control’s label spans 40% of the overall width. There is no direct way to manipulate this server side since the divs do not contain IDs. Even doing […]
In the web client there is now a proximity search to find records within a specified distance of one another. There are 2 proximity searches- one for account and one for contacts. This functionality is in 2 custom smart parts both in the ProximitySearch folder: ContactDistanceSearch.ascx AccountDistanceSearch.ascx Searching on the Contact version has a problem […]
One of the new features introduced in 8.3.06 is the concept of favorite groups. Previously a user saw all groups that were released to them when they went to a page in the web client. This caused performance problems to load all of these groups when the page was rendered- especially once you got above […]
How to size a control within the tab workspace of the Infor CRM web client to fit the available height of the tab control.
“Service Sage.Platform.Application.IEntityContextService is not available in the current context” in Infor CRM web client
If you are trying to navigate to a page in the Infor CRM web client and get a message of: We apologize for the inconvenience, but your request cannot be completed. Service Sage.Platform.Application.IEntityContextService is not available in the current context. Fear not, nothing is wrong with your system. It is an unhandled error that is […]
In the web client you are able to retrieve the raw SQL statement of a group. At some point along the way in the life cycle of the web, the storage format of the SQL statement changed. There is a method GroupSQL that used to return the same SQL as what you would see if […]
A post showing how to use Linq to sum an entity collection quickly.
There is a problem adding quick forms to web manifest if they contain an image resource reference that does not match case.
I was recently working with a client who was having trouble installing the 8.3 Web Action items manifest (Infor v8.3 Action Items VFS.zip). Within this manifest are actions like create triggers or drop indexes. Whenever these Database Definition Language commands were attempted they would receive the dreaded and completely useless “Object Reference not Set to […]