Updating a specific record in the database

Use the Update Database tab to view or modify the content of a specific record in the M3 Business Engine database.

  1. On the Business Engine Data Management page, click the Update Database tab.
  2. Specify the name of the applicable table and click Open. If the table belongs to a different accounting entity than the default company and division, change these settings before specifying the table:
    1. Click the Settings icon.
    2. In Settings, select the applicable combination of company and division, or select the Use default company and division check box.

    Once the table data is displayed, you can change sorting order from the menu.

  3. Optionally, you can filter records in the displayed table:
    1. Click the Filter records icon.
    2. Select a field and an SQL operator, and specify a value to match the field against.
      Note: Click the question mark for details on how the SQL operators are used.
    3. Click Add to add the filter. Multiple filters can be added.
    4. Click OK. The records that matches the filters are listed.

    Select the check box next to Filter records to enable the filtering. Clear the check box to disable the filter.

  4. Use the positioning fields above the column names to search for the record to edit, or browse through the table using Next and Previous.
  5. To update a record, select the record and click the Edit icon in the menu. A detailed view of the record is displayed.
  6. Make your changes and click Submit.
  7. Click Yes in the confirmation dialog box.