Updating MBMTrn

On this page you can update the selected mapping for each of the M3 API connections in the MBMTRN table.

To View the MBMTRNUpdate log, click the Update button, then click the Task Page link. You can also view the log on the Server > Task Menu, click the Note icon.

  1. Access Utilities and click the MBMTRN Update link.
  2. Select CUMULATIVE and an API Reference Name.
    Note: 

    Select the CUMULATIVE option to prevent BE data loss.

    If you select the Cumulative option, records will be added or changed in MBMTRN. If you clear this option, unused records in MBMTRN are deleted, or the status is set to 90.

    Use these guidelines to generate the data:

    First, get all data translation from the user functions.

    Second, write the event logs and update the table MBMTRN in all selected M3 API databases.

  3. Select an API Reference Name to update.

    You must select at least one API Reference name.

  4. Select a Mapping Name to update.
    Note: 

    Select at least one mapping to process and then select the Cumulative option. By default, all mappings will be processed if there is no mapping selected.

  5. Click Update. The view shows a link to the task page.
  6. Click the Task page link to open the Maintenance Task Status page.

    The view shows a table list of available tasks. You can view, save, or delete tasks from this page.

    • To view - click on the paper icon to view the MBMTrnUpdate Message log details.

    • To save - click on the diskette icon to save the log details.

    • To delete - in the Delete column, select a checkbox corresponding to one or several logs that you want to delete.

      Note: 

      Delete has no undo function. Use this feature with caution.