Infor m3 custom list
CMS022 related tables Infor M3

CMS010 is at the heart of many solutions in modern Infor M3.

In this case, our main file is MPLINE, purchase order lines. Every record in this file is related to records from other files, listed above. To relate purchase transactions, we use a specific index to find the record that has the least progression in the flow (in case there are several receiving numbers on the same order line). User and Item file are related to fetch info, names, and phone numbers.

Lost in Infor M3 ? Use new tools for better directions - CMS012

Virtual fields are very powerful, giving the user the ability to add logic using formulae and calculations. This becomes even more interesting when exploring the possibilities of sequential fields, which allow the output from a virtual field with previous sequence number (see picture) to be used in subsequent calculations of fields with higher sequence numbers.

By taking advantage of this functionality, you can create relatively complex conditions using a combination of calculations and formulae. But while the conditions are complicated, implementing them is actually very straightforward.

For example, we can produce a virtual field, & AC40, which outputs one of three potential values – RECEIVE, QUALITY, PUTAWAY – depending on several predefined conditions. Now, you might argue that these conditions could be included in conditional styles (personalization), and that’s true. But I would strongly recommend you keep all logic as close to M3 as possible. Not only is it more robust, it’s also easier to change and deploy, and in many cases allows for more advanced customization.

Infor M3 virtual fields
Lost in Infor M3 ? Use new tools for better directions
Infor M3 example window
Lost in Infor M3 ? Use new tools for better directions  –VINCE

Link manager Infor M3

link manager m3 CMS100 CMA 100BC

Link Manager is used to enable a structured approach to the use of dynamic links from a specific personalisation such as a hyperlink, meaning links can be changed without the need to deploy new personalisations.

Link properties infor m3

In this case I’ve used the mforms automation to create dynamic links to several reporting programs (PPS300,-310,-320). The dynamic values taken from the screen are purchase order number (PUNO) and receiving number (REPN). You can also achieve this with bookmarks, but in this case the requisite panels were not bookmark-enabled in the relevant environment.

conditional styles  infor m3

By using virtual fields & Link Manager as described above, personalisations become very simple

Lost in Infor M3 ? Use new tools for better directions

Each style is associated with a condition on the corresponding field value.
And again, any changes to the logic can then be managed in the relevant virtual fields (of the custom list in CMS010). Complex conditions can sometimes spiral out of control if managed as conditional styles only.

Conditional styles m3 - Lost in Infor M3 ? Use new tools for better directions

And the corresponding link from Link Manager is pinpointed.

OK, that was it.
Please remember when dealing with link manager and personalizations you may need to close M3 program (in this case simulation of CMS010) in order for your updates to “bite”.

Good luck with your continuous use of M3 generic tools!

contact us to learn more

Go back to part 1? read it here

Download content as .PDF

Lost in Infor M3