What can you do with it?

Efficiently manage ERP operations with Infor M3, allowing users to read values, search customers, retrieve customer basic data, and perform various ERP functions including inventory management, customer orders, and supply chain operations within the Infor M3 platform.

How to use it?

Basic Command Structure

/your-inform3-connection [action] [required-parameters] [optional-parameters]

Parameters

Required:

  • action - The operation to perform (search-customer, get-customer-basic-data)

Optional:

  • search-query - Search query for customer lookup
  • customer-number - Customer number for data retrieval
  • company-number - Company context (default: varies by operation)
  • date-format - Date format (YMD8, YMD6, MDY6, DMY6, YWD5, YMD8-)
  • exclude-empty - Exclude empty fields from response
  • max-records - Maximum number of records returned
  • format - Output JSON format (UNFORMATTED, COMPACT, PRETTY)

Tools

Search Customer

Search for customers using LES (Lawson Expert Search) queries

Parameters:

  • search-query (required) - Search query using Infor M3 syntax
  • date-format (optional) - Date format (default: YMD8)
  • exclude-empty (optional) - Exclude empty fields (default: false)
  • format (optional) - Output format (default: PRETTY)

Example:

/your-inform3-connection
action: search-customer
search-query: CUNO:9* RGDT:20210714 ECAR:NC RESP:WWONG
date-format: YMD8
exclude-empty: false
format: PRETTY

Response:

{
  "results": [
    {
      "transaction": "SearchCustomer",
      "records": [
        {
          "CUNO": "9192705806",
          "CUNM": "JHON DOE",
          "STAT": "20",
          "CUCL": "Y01",
          "CUTP": "0",
          "PYNO": "",
          "SMCD": "",
          "RESP": "WWONG",
          "BLCD": "0",
          "RGDT": "20210714",
          "CSCD": "US",
          "ECAR": "NC",
          "FRE1": "",
          "RSMC": "",
          "RPYN": "",
          "DPOT": "",
          "SRES": "",
          "PGNM": "CRS610",
          "FILE": "OCUSMA",
          "KSTR": "OKCONO,222,OKCUNO,9192705806"
        },
        {
          "CUNO": "9845007439",
          "CUNM": "MARIA JOSE",
          "STAT": "20",
          "CUCL": "Y01",
          "CUTP": "0",
          "PYNO": "",
          "SMCD": "",
          "RESP": "WWONG",
          "BLCD": "0",
          "RGDT": "20210714",
          "CSCD": "US",
          "ECAR": "NC",
          "FRE1": "",
          "RSMC": "",
          "RPYN": "",
          "DPOT": "",
          "SRES": "",
          "PGNM": "CRS610",
          "FILE": "OCUSMA",
          "KSTR": "OKCONO,222,OKCUNO,9845007439"
        }
      ]
    }
  ],
  "wasTerminated": false,
  "nrOfSuccessfullTransactions": 1,
  "nrOfFailedTransactions": 0
}

Get Customer Basic Data

Retrieve detailed customer basic data for a specific customer

Parameters:

  • customer-number (required) - Customer number (10 characters)
  • company-number (optional) - Company number (3 digits)
  • date-format (optional) - Date format (default: YMD8)
  • exclude-empty (optional) - Exclude empty fields (default: false)
  • format (optional) - Output format (default: PRETTY)

Example:

/your-inform3-connection
action: get-customer-basic-data
customer-number: 8588691050
company-number: 222
date-format: YMD8
exclude-empty: false
format: PRETTY

Response:

{
  "results": [
    {
      "transaction": "GetBasicData",
      "records": [
        {
          "CONO": "222",
          "DIVI": "",
          "LNCD": "GB",
          "CUNO": "8588691050",
          "CUNM": "H FURMAN",
          "CUA1": "302 PROSPECT STREET",
          "CUA2": "1",
          "CUA3": "SAN DIEGO  CA  92037",
          "CUA4": "United States",
          "PONO": "92037",
          "PHNO": "8588691050",
          "PHN2": "",
          "TFNO": "",
          "CUTP": "0",
          "ALCU": "8588691050",
          "YREF": "",
          "YRE2": "",
          "MAIL": "",
          "CSCD": "US",
          "ECAR": "CA",
          "CFC1": "RETAIL",
          "CFC2": "0.00",
          "CFC3": "",
          "CFC4": "",
          "CFC5": "",
          "CFC6": "",
          "CFC7": "0.00",
          "CFC8": "",
          "CFC9": "",
          "CFC0": "",
          "CESA": "",
          "STAT": "20",
          "LMDT": "20220419",
          "PYOP": "1",
          "TOWN": "SAN DIEGO",
          "CUCD": "USD",
          "MCOS": "1",
          "FRCO": "",
          "CUSU": "",
          "EALO": "0",
          "RASN": "",
          "SPLE": "",
          "LSID": "",
          "LSAD": "",
          "MEAL": "",
          "HAFE": "",
          "TXID": "0",
          "RGDT": "20210714"
        }
      ]
    }
  ],
  "wasTerminated": false,
  "nrOfSuccessfullTransactions": 1,
  "nrOfFailedTransactions": 0
}

Notes

Infor M3 uses specific interface codes like CRS610MI for customer operations, MMS310MI for inventory, OIS100MI for orders, and MWS410MI for delivery management. Search queries use Lawson Expert Search (LES) syntax with field:value pairs. Customer numbers are 10-character identifiers. Company numbers (CONO) provide context for multi-company environments. Date formats support various regional standards. Universal parameters like maxrecs, dateformat, excludeempty, and righttrim can be applied to all endpoints for customized output formatting.