InforCRM has had the ability to define boolean entity properties as either True/False or Yes/No for a long time, however in a recent project, I found that displaying such an entity property as a bound field in a Data Grid would always display True or False (or nothing, if not set) regardless if it was set as a Yes/No data type.
When creating a group in the Infor 8404 web client, I noticed an issue when using a date field in the query conditions. Regardless of the date value selected, saving the condition results in the date value of 12/30/1899 being saved and used as the group condition. This is obviously an issue depending on […]
This post lists current Plugins, as well as depreciated Plugins and their type numbers for the InforCRM LAN environment.
Within lead records in InforCRM, there are a number of DoNotContact fields, such as Do Not Solicit, Do Not Mail, Do Not Phone, etc... InforCRM provides an area to set up a default value for the Do Not Solicit value on new Leads, however it does not do anything with the other Do Not Contact fields. In InforCRM, the DoNotSolict value supersedes the other Do Not Contact fields, so it shouldn't matter, however some of our clients find it confu...
When creating a bundle manifest recently, I needed to include new roles and secured actions. In the bundle actions area of a new manifest, there are options to add Role(s) and to add Secured Action(s). When adding roles, there is an option to "Include related secured actions", however selecting this options does not actually add the related secured actions.
There is an interface in the Administrator application to allow the Admin to set various defaultvalues, including this one. The issue I bumped into is that it only allows you to set a boolean default to "True" or "False", while in ICRM, boolean values are stored as "T" or "F".
One thing I find myself doing frequently is enabling/disabling triggers in an InforCRM database, especially with users who are not utilizing any of the newer ERP integration features found in current versions of InforCRM.
The Infor v8.4 Action Items bundle inserts a number of new Security profiles into the secprofiles table. Unfortunately, in doing so it also clears all the old profiles, which is an issue if you have custom security profiles that you use in your system.
In many interfaces, numeric values tend to be right justified. In InforCRM however, all controls display their information with the text aligned to the left of the control. Recently I was asked about changing the text alignment of numeric controls to display the text to the right in the control. While InforCRM doesn't expose a text-alignment property in their controls, it is possible to set the style.textAlign property of the composite N...
I recently bumped into an issue with the order in which the utility (CreateUnicodeDB) creates database objects. SQL Users and schemas are processed first, followed by SQL tables, followed by the other SQL objects. In this particular database, there were scalar UDFs being used to create computed columns in a number of the SQL tables. Since the utility creates Tables before UDFs, it would error out on any table referencing that non-existent U...
Yesterday, Kris posted about a new issue in 8.309 regarding URL controls. To check for this condition, I put together a quick SQL function that can be used to check url values to see if they would be affected by this bug.
My colleague, Kris, recently posted an article about using a custom CSS file to fix Misaligned Toolbar buttons in InforCRM web client dialogs. There is an additional step needed in order for InforCRM. In the core.master file located in the Model/Portal/SlxClient/SupportFiles/Masters folder, the following line needs to be added after line 305 in that file
I wanted to take a moment to briefly document how to install web manifests in InforCRM. This is pretty basic functionality, but I thought it would be helpful to have it documented here as a reference. So, without further ado:
For anyone who works with InforCRM SNC, the loose definition of the "boolean" is familiar. Basically, InforCRM treats "Booleans" as single character strings, rather than a bit datatype in SQL, allowing "T" and "F" values, as well as null.
An unusual error cropped up with a single Crystal Report in InforCRM. Other reports were running fine, and I was having quite a bit of trouble figuring out what the issue was.
Recently, I had a request to build functionality that would allow a user to send an email based on information in a datagrid row. Here is an outline of how I put that functionality together. The form contains a standard datasource/datagrid setup (Note, this does not work with an editable datagrid). In addition to any other functionality on the form, we also need to add two objects: A Hidden Text control, and a button on the form. The Hidde...
I was working on an editable datagrid, adding two new columns from a couple of field properties that I had just added to the entity model. After I made my changes, built the web platform and deployed, my new columns were not showing up in the datagrid. "Oh well", I thought, "Sometimes you have to rebuild everything for a change to come across". So, I deleted everything from my build folders to force a full rebuild. I also deleted everything f...
Occasionally, it may become necessary to rebuild the XMLSchema to fix issues with groups in Infor CRM. I wanted to take the opportunity to document here how to rebuild the XMLSchema in version 8.x of Infor CRM:
In today's post, I'll be outlining a procedure to add an Address field to Account Asset (Product) record. To add an address field to Account assets (products) that allows a user to define an existing Account Address for an Asset (AccountProduct) record. The addressed will be stored in the AccountProduct.Userfield1 field.
I recently had a project that required me to be able to check if a user belonged to a particular team. A previous post by Ryan showed me how to query team membership, but rather than setting this up as a Business Rule, I wanted to create it as a Global function that could be called from anywhere without having to worry about instantiating an entity to access the business rule. Instead of creating a business rule, I created a Global CS script...