M3 Information Editor

Use this configuration to use basic API transactions for updating data.

1. Click Configure Widget.
2. Specify this information:

   Title

   Click unlock button and specify a widget title.

   Automatic Refresh Rate

   Select a refresh rate minute interval from the list.

3. Specify this information:

   Program

   Click the look-up button in this required field. Search for an M3 program, for example CRS610, and provide a description to filter the results. Click a record from the programs list and click Select.

   Get Transaction

   Click the look-up button in this required field. You can search for a transaction, for example SearchCustomer, and provide a description to filter the results. Click a record from the transactions list and click Select.

   Input

   Click the look-up button.

   On the data grid, you can perform these tasks:

   • Select Input to identify the input fields to be submitted to the API transaction.
   • Change the input field's value in the Value column.
   • Optionally, specify an entity type to require the widget to retrieve business context messages, for example, InforCustomerPartyMaster. And then specify an input in the Value field that uses the entity type enclosed in a bracket. This example shows the format: {InforCustomerPartyMaster}. The same input is reflected in the Id1 context message which you can use as an input field to run the API request.
     Note: Other supported macros are used in the Value field.

     See Supported macros for the input field in this document.

   Output

   Click the look-up button in this required field.

   On the datagrid, you can perform these tasks:

   • Select Output to identify the output fields to be submitted for the API transaction.
   • Specify a value under the View Order column to specify the order of the output fields for display, for example CUNO;CUNM;STAT;CUCL.
   • Change the display labels of columns through the Modify Description functionality. You can also specify a translation for the new label. For the translated label to reflect, you must set the equivalent language in the user settings of Infor OS.
   • Select a maximum record count.

   Update Transaction

   Click the look-up button in this required field. You can search for update transactions, for example ChgBasicData and provide a description to filter the results. Click a record from the transactions list and click Select.

   Update Program

   Specify an M3 program. When executing an edit API request, the Program value is overridden with this field. Normally, the values for Program and Update Program are similar, for example, CRS610. When Update Program is changed, the widget uses the Update Program value instead to construct the API request. This enables the widget to use other programs for updating records.

   Editable Fields

   Click the look-up button in this required field to switch to the Input/Output Parameters page.

   On the data grid, you can perform these tasks:

   • Select Input to identify input fields to be submitted to the API transaction.
   • Select Hidden to hide input fields submitted to an API transaction.
     Note: The hidden functionality only works if Input is selected.
   • Change the input field's value in the Value column.
   • Change the display labels of input fields through the Modify Description functionality. You can also specify a translation for the new label. For the translated label to reflect, you have to set the equivalent language in the user settings of Infor OS.
   • Optionally, configure a browse field.

     See Configuring a browse field in this document..

4. Click Save.

• Infor entities macros

  The macros for entities uses this format: {<infor_provided_entity_name>}. For example, {InforCustomerPartyMaster}. Take note that the user should also add the same entity name on the entity type column when configuring the input parameter.

• Location macros

  The macros for location uses this format: {<coordinate>, [<no_of_decimals>]} where the value inside the square brackets [] are optional.

  The types of location macros include:

  • {longitude}
  • {latitude}
  • {latitude, 3} where 3 is optional in this example
• Date macros

  The date macros uses this format: DATE(<integer>), where the value of integer calculates the time frame from the current date. For example:

  • DATE(-30): calculates date of 30 days behind from the current date
  • DATE(0): current date
  • DATE(+30): calculates date of 30 days ahead from the current date
• User context macros
  The macros for user context uses this format: {<user context fields>}.

  Note: The user context fields are retrieved from the current user records from (MNS150).

  This list contains the supported user context macros:

  • {CHNO} - change number for project ID
  • {CONM} - user's division name
  • {CONO} - user's company
  • {CSYS} - connected system
  • {CUNO} - customer
  • {DCFM} - user's decimal format
  • {DEPT} - user's department
  • {DEVD} - user's location
  • {DFMN} - user's start menu
  • {DIVI} - user's division
  • {DTFM} - user's date format
  • {EMAL} - user's email address
  • {EUID} - external user id
  • {EQAL} - user's equipment alias search sequence
  • {FACI} - user's facility
  • {FADT} - first active date
  • {FRF6} - free field 1
  • {FRF7} - free field 2
  • {FRF8} - free field 3
  • {LANC} - user's language
  • {LADT} - last active date
  • {MNVR} - user's menu version
  • {NAME} - user's full name
  • {PHNO} - telephone number
  • {PROE} - profile
  • {TFNO} - facsimile transmission number
  • {TIZO} - user's time zone
  • {TX40} - user's company name
  • {ULTP} - user license type
  • {USID} - user's ID
  • {USTA} - user's status
  • {USTP} - user's type
  • {WHLO} - user's warehouse

Use this procedure to configure a browse field and define how users can search for, filter, and select values from available data sources:

1. In the Input fields, click the look-up button.
2. Specify this information:

   Table

   Specify a table, for example OCUSMA.

   Field Override

   Specify any M3 API Field, for example CONO.

   Set as Browse

   Select the check box to set the parameter as browse field.

   Browse Field

   Click the Edit button to modify the browse field overrides.

   Field	Description
   Field Override	Contains M3 API fields, for example CONO.
   Parameter List Index	Contains an index of the available data.
   From Table	Contains M3 table values, for example {} or OCUSMA. This field is auto filled by the Parameter List Index.
   Browse Variant	Contains browse variant values, for example 00 or 01. This field is auto filled by the Parameter List Index.
   Add a filter	Selecting this check box enables you to specify filter fields.

   View Order

   Specify a value to specify the order of the input fields for display.

3. Click Save.

1. Open the M3 Information Editor widget.
2. Optionally, specify a value or a description in the Search field.
3. Click the available record from the list.
4. The displayed fields are based from the values gathered from the M3 Information Creator. You can modify values in the existing fields, for example Name field.
5. Click Submit.