M3 Browsable Fields Via H5 Scripting

Two years ago I had a requirement to make a field in CRS624/G browsable via H5 scripting. I managed to achieve this by using an external tool called jsGrid(http://js-grid.com/).

Then about a week ago, i learned from a colleague that the script I created was adopted and used by other consultants, being implemented on other environments. It got me to thinking in revisiting my code see if there is anything in there that can be improved.

Read More »

MI Transaction in H5 – Part 2

Following entry was created for old versions of H5 where MIService is not yet available

In our previous post, we saw how we can execute MI transaction in H5 using the MIUtiltool utility tool we created. In this post we will be expanding on this tool to include a helper in retrieving output fields on the executed transaction.

Let’s look back on the transaction we’ve executed

let miTrans = new MIUtilTool.Transact("CRS530MI");
miTrans.set("FCOM", userContext.CONO);
miTrans.set("TCOM", userContext.CONO);
miTrans.set("FEMN", "CSANTOS");
miTrans.set("TEMN", "Y500");
miTrans.execute("LstEmployee", this.onSuccess, this.onFail);
Read More »

MI Transaction in H5 – Part 1

Following entry was created for old versions of H5 where MIService is not yet available

To perform an MI Transaction in H5, we use ScriptUtil.ApiRequest(). It accepts three parameters: the url for the transaction, the callback when transaction succeeds and the callback when it fails. A sample usage of this would be like this

let userId = userContext.USID;
let url = "/execute/MNS150MI/GetUserData?USID=" + userId;
ScriptUtil.ApiRequest(url, this.onSuccess, this.onFail);
Read More »

How to set and get field values in H5

Since H5 is based on HTML and javascript, there are a couple of  ways in getting and setting the value of a field in H5. We can do this via ScriptUtil, IInstanceController, Jquery or via plain old javascript. This is for demonstration purposes since I would assume that Infor’s Product Development team will not advise in using the other three options other than ScriptUtil.

Read More »

ODBC Connection on MOM

Most of the time when the client wants to modify certain reports, they require fields that are not readily available in the streamfile. Personally for me, the best approach in doing so is to add the needed fields via MAK modification. This is the best method you can do to achieve this. But sometimes, clients request to do a direct SQL connection from the StreamServe instead, probably to avoid the additional license payment for MAK modifications or for some other reasons. There are also StreamServe consultants that are not familiar with MAK modifications and thus results to ODBC Connection.

Here i will try to show how to setup the environment in order to do a direct SQL statements from StreamServe.

Read More »