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 […]
Prior to 8.3, the ExchangeRate table in the Infor CRM database used the column CurrencyCode as the primary ID of the table. Because of this in the custom Opportunity Smart part OpportunitySnapshot, there was a method to get the exchange rate called GetExchangeRateData that used the GetById method to return the ExchangeRate record based on […]
In the Infor CRM web client, we have gotten asked how to modify the address dialog that comes up when you click the pencil icon on the address control, like on the Account details screen. As usual things are a little more complicated than it seems. The Edit address screen is actually two different things […]
Breaking Campaign Target Logic In older version of the custom smart part LeadSearchAndConvert, there is code in the ConvertLeadToNewAccountAndContact method that converts lead campaign target data into the newly created contact record. In older version this code look like: In 8.3 that Lead business rule no longer exists. Instead there is a new method in […]