Custom List against MILOC using filters from MITMAS

I am trying to create a custom list (CMS100) and a custom list API (CMS100MI) against the inventory file (MITLOC), but with filters from MITMAS (ITTY, ITGR, ITCL).

Has anyone done something like this?

I am looking into using key searches, but without success so far, and I am not sure if these can be used in the API. Does anyone have more information on how to use these key searches?

Fons

Find more posts tagged with

Accepted answers

All comments

Maxime Richard

Hi Fons,

You can check the warning message you get in CMS015 when trying to create a CMS100MI verb that would use IES search (OP & Cloud) :

So, seems not possible to search in related tables with CMS100MI IES API.

If you want more information about key searches, you can have a look at the videos from Magnus Tallqvist; look in inforxtreme, solution 1598752

Legacy Contributor

If you're looking for the syntax of the sqry fields, I'm sorry, I don't have a link, but KB article 1687355 has some documentation on how to enter the fields.

Copyright © 2025 Infor. All rights reserved.