MO Query

MO Query

HelpID: 715822029

The MO Query window is opened by clicking on the “MO Selection Query” link in the Settings section of the window.

The MO Selection Query window is used to control which records are processed by MORI from the staging tables. By default, MORI processes “oldest first”, which it determines by sorting on W7158MOHdr.DEX_ROW_ID descending.

The MO Selection Query settings are saved by User ID, so if multiple MORI processors are running each one could have a different selection query. For example, a selection query might restrict a MORI processor to records for a specific Site.

Receipt Date On/Before User Date: when marked, MORI will use the W7158MOHdr.DATE1 column. It will only process receipts where DATE1 is on/before the GP User Date. This option allows you to integrate transactions with a current or future date while only processing “older” transactions. Normally this option should be UNMARKED.

Selection Query

The query can be created using fields from IV00101 (Item Master), IV40700 (IV Location Master), W7158MOHdr (MORI Import Header), and WO010032 (Work Order Master).

The Table/Field picker can be used to help select correct field names, but the query can also be manually entered into the text field.

All of the tables mentioned above are joined in the MORI query that retrieves the Next MO Number To Process. The text in the query box will be added to the Next MO query after a “where” clause, so the query should be written in such a way that it follows “where”.