Maintaining company and division

Use this procedure to rename, copy, or remove company and division from the database tables.

  1. Right-click your environment and select Database > Maintain Company and Division.
    Note:  You can also open the task by clicking Database > Maintain Company and Division on the dashboard.
  2. Perform either of these options depending on the status of the environment:

    • If the environment is running, the message "Set M3 BE in maintenance mode" is displayed.

    • If the environment is stopped, the environment will be started in maintenance mode.

      Note: The environment is in maintenance mode until the application is started, or set online.
  3. Click Next.
  4. Specify the user ID and password of the database administrator and click Next.
  5. The Select Configuration Option window is displayed. Select one of these options for importing data:
    Maintain company and division

    Select this option to maintain specific data.

    Maintain company and division using saved configuration

    Select this option to maintain specific data using saved configuration.

    Note: It is recommended to save the settings or configuration related to data that you frequently use, such as tables, to save you from providing the data again.
    Delete configuration

    Select this option if you want to remove a saved configuration.

    When the second or third options are selected, the Configuration field is enabled. It allows you to use or delete a saved configuration.

  6. Click Next. The Table Selection window is displayed.
  7. Specify this information:
    Component

    Select the component. For an additional component, select the component specified in the Environment Configurator Components pane (MNS104). For standard M3 BE without any modification, select the MVX component.

    Database schema

    Depending on your selection of component, the applicable schema is displayed in this field.

    Options

    Select one of these options for Table selection:

    • All tables - Maintain all the tables.

    • Enter table name - Maintain one specific table. Specify the name of the table.

    • Select tables - Displays all tables in a list. Select the tables to maintain.

  8. Click Next. The Rename, Remove or Copy Company and Division window is displayed.
  9. Specify this information:
    Rename, Remove or Copy company
    Select one of these options:
    • Rename Company
    • Remove Company
    • Copy Company
    Division filter

    Select one of these options:

    • All divisions

    • Selected division

    Source company number

    If you selected Rename or Copy company, you must specify a Source company number.

    Target company number

    If you selected Rename or Copy company, you must specify a Target company number.

  10. Click Next.
  11. The Advanced Copy Configuration window is displayed. Select the number of threads to be used.
  12. Click Next. The Save Configuration window is displayed.
  13. Specify a unique name for the configuration.

    The configurations for Maintain Company and Division are saved in the M3BE file structure in M3BE\_db_data\configuration\maintain\.

  14. Click Next. The Summary window is displayed.
  15. Verify the values provided and click Finish.
  16. When the task is finished, a window is displayed. Click OK or click View log. You can also go to the Logs tab to view the log file.