16.17.1 Corporate Enterprise Reporting Module Overview
The Corporate Enterprise Module allows companies to
· Select one of three methods to have their parts list and BOMs automatically synchronized (including all indexes) across the world in real time.
· Switch from one division to another by selecting that division from the drop down menu.
· Print out consolidated financial reports for all divisions, business units, and the entire corporation. Currencies are automatically reconciled if pc/MRP’s Alternate Currency Module is active.
The consolidated reports include:
· Profit and Loss (current period and YTD with variance to budget for current period and YTD for all divisions)
· YTD Expense and Revenue (current period and YTD with variance to budget for current period and YTD for all divisions)
· Trial Balance (current month and YTD for all reporting divisions)
· Balance Sheet (for all reporting divisions)
· General Ledger (for the period for all reporting divisions)
· GL Transactions (for the period for all reporting divisions)
16.17.2 Activating the Corporate Enterprise Reporting Module
Select Configuration, Module Activation, and then Corporate Reporting Module from the menu. To activate this module:
Call Software Arts (408-226-7321) to obtain your activation code number. Press the “Activate” button and enter your activation code number.
16.17.3 Setting the default settings for the Corporate Enterprise Reporting Module
16.17.4 Creating Business Units
A company must create one or more Business Units. Business Unit(s) report to the entire corporation. Divisions report to the Business Unit(s).
To enter a new Business Unit, click on the “New Unit” button. Enter the two-character Unit ID field and the Business Unit Name. If the Headquarters Division has pc/MRP’s Alternate Currency Module, select the currency for the new Business Unit. The Base Currency is the currency used by the Headquarters division. The 2-character Unit ID field must be unique among both Divisions and Business Units.
To remove a Business Unit, select the Business Unit and then click on the “Remove Unit” button. All Divisions reporting to that Business unit will be removed as well.
16.17.5 Creating Divisions
Divisions report to Business Units. One division must be checked as the Headquarters Division. This division is the only division that will contain an active Corporate Report Module. This division must exist in the current default directory when it is created.
To enter a new Division, click on a Business Unit and then click on the New Division button. Enter the 2-character Division ID field and the Division Name. The 2-character Unit ID field must be unique among both Divisions and Business Units.
You can scroll through your network to get a UNC path or a mapped drive to get a drive path to the folder containing the division’s pc/MRP files. The UNC path is preferable because not all computers may have similar mapped drives.
If the Headquarters Division has pc/MRP’s Alternate Currency Module, select the currency for that division. The Headquarters Division must select “Base Currency”. If other divisions work in the same currency as the Headquarters Division, you must select “Base Currency” as their currency.
You cannot create more divisions that you are licensed for. To increase your division license count you must call Software Arts to purchase an additional copy of pc/MRP and an additional enterprise license. Software Arts will give you a new activation code number. You can then increase your division count by following one of the two methods below:
Method 1. Select the HQ Division. Select Configuration, Module Activation, select Corporate Report module, and select Deactivate. Then reactivate the Corporate Report module with your new activation code number by selecting Configuration, Module Activation, Corporate Report, Activate, and enter your new activation code number. (To get the activation code, Software Arts personnel must set the seat count to the total number of divisions and check the Corporate Reporting checkbox.)
Method 2. Select the HQ Division. Select Optional, Corporate Reporting, and Settings, Select the HQ division, double click on the word Properties, and enter your new activation code number.
If none of your divisions use alternate currency, there is no need to purchase pc/MRP’s Alternate Currency Module.
If one or more of the divisions use a different currency than the HQ division, the HQ division should purchase pc/MRP’s Alternate Currency module. The HQ division and all divisions using the same currency as the HQ division must be set to Base Currency. Divisions using alternate currency must be set to that currency. These alternate currency divisions do not need to purchase pc/MRP’s base currency module, unless they have vendors and or customers that use alternate currencies. The alternate currency divisions would always set their own currency as their base currency in their own copy of pc/MRP’s Alternate Currency module.
16.17.6 Setting part and BOM synchronization settings
Select the “Synchronization Settings” tab and select the method you wish to use to synchronize your part numbers and BOMs between divisions.
Selecting the top radio button will allow each division to control their own partmaster and BOM database files with no synchronization between divisions.
Selecting the middle radio button will allow only the HQ division to create part numbers and BOMs. If HQ edits a part, the Part Number, Description, and Part Assembly fields are propagated. The new and edited part numbers and BOMs will be propagated to all other divisions within seconds. The other divisions can edit all of the fields for a part with the exception of the part number, description, and part type fields. Other divisions are not allowed to edit BOMs with this option.
Selecting the third radio button will allow all divisions to create part numbers. The new part numbers will be propagated to all other divisions within seconds. Only the HQ division can create and edit BOMs.
16.17.7 Propagating Additional Partmaster Fields
Select the Inventory Sync Fields button to check the fields you want propagated. The Part Number, Description, and Part/Assembly fields are propagated to the other divisions automatically when a part is created. The fields selected by the Inventory Sync List are propagated when a part is created but not when a part is edited. If you edit a part, the Part Number, Description, and Part Assembly fields are propagated.
Check the additional fields you want propagated. The Part Number, Description, and Part/Assembly fields are automatically propagated to the other divisions when a part is created. The fields selected by the Inventory Sync List are propagated when a part is created but not when a part is edited. If you select a cost field to be propagated, and the HQ division has pc/MRP’s Alternate Currency module, the costs will be propagated in each division’s currency.
16.17.8 Setting up Passwords
Select the “Password Settings” tab to enter and edit passwords for the entire corporation. Each division must have their own pc/MRP password module. The above passwords are simply a consolidation of each division’s Password Module.
If the “Control password accounts at the Corporate Level” checkbox is not checked, passwords are managed at the division level. If it is checked, all passwords are controlled at the HQ division.
To enter a new password, click the “New” button. If the password’s Location references another division, that division’s password module will be updated.
If a person is to have access to multiple divisions, you should set up the same name and password for each division. That way if a user changes his password, it is automatically propagated to all divisions and he will be allowed to switch from division to division without re-logging in.
16.17.9 Print/Display Consolidated Corporate Enterprise Reports
To print consolidated corporate financial reports, select the “Print Corporate Reports” option on the “Corporate Reports” menu. pc/MRP will display the “Corporate Consolidated Financial Reports” window shown above. Select the Entire Corporation or one of the Business Units. Check which reports you want to display and or print. Select the report period.
If you have the Alternate Currency Module, press the “Currency Exchange Rates” button to check and or set the currency rate as of the last date of the period being consolidated. The rates are stored along with the consolidation data. If you were to reprint this period’s consolidation reports, the stored rates would be used again, unless you were to adjust the rates again.
All divisions must have the same start of fiscal year. Not all divisions have to close on the same date. A warning message will be displayed if one or more of the divisions do not have a close for that period, however, pc/MRP will give you the option to print or display consolidated reports without those divisions. Select Display or Print output and press the OK button.
16.17.10 Corporate Profit and Loss Report
The Corporate Profit and Loss report includes revenue and expense totals for the Current Month, YTD, Budget, YTD Budget, Variance, and YTD Variance for every division reporting to the Business Unit selected or the entire corporation.
16.17.11 Corporate YTD Expense and Revenue Report
The YTD Expense and Revenue report includes all revenue and expense charts of accounts and totals for the Current Month, YTD, Budget, YTD Budget, Variance, and YTD Variance for every division reporting to the Business Unit selected or the entire corporation.
16.17.12 Corporate Balance Sheet Report
The Corporate Balance Sheet report includes all the asset, liability, and equity accounts for all the divisions belonging to the Business Unit selected or for the entire corporation.
16.17.13 Corporate Trial Balance Sheet Report
The Corporate Trial Balance report includes the trial balances for the current month and YTD for every division belonging to the Business Unit selected or all divisions for the entire corporation.
16.17.14 Corporate General Ledger Report
The Corporate General Ledger report contains the starting balance for the year, the starting balance for the month, all transactions for the period, the ending balance for the month, and the ending balance for the year for every division belonging to the Business Unit selected or all divisions for the entire corporation.
16.17.15 Corporate Transaction Report
The Corporate Transaction report contains the every transaction entered during the period for every division belonging to the Business Unit selected or all divisions for the entire corporation.