ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon Prerequisites & Introduction
DrillDown Icon Access Levels
DrillDown Icon General Ledger
DrillDown Icon Fiscal Year Calendar
DrillDown Icon GL Account Types & Ranges
DrillDown Icon GL Divisions/Departments
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields and Definitions
DrillDown Icon How To .......
DrillDown Icon Setup the GL Divisions for Headquarters
DrillDown Icon Setup the GL Departments for Secondary Divisions
DrillDown Icon GL Account Setup
DrillDown Icon GL Post Defaults
DrillDown Icon A/R-A/P Setup
DrillDown Icon Bank Setup
DrillDown Icon Inventory Setup
DrillDown Icon FAQs - Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Setup the GL Departments for Secondary Divisions
To setup the Secondary ManEx System you can follow the steps in Article #288 along with the steps described below.  
 
Enter SQLACCTSETTING.EXE  (within the ManEx root directory)
  

This action will then prompt the user for a password
The following screen will be displayed, enter the G.Ledger/G/L Departments
 
The following screen will be displayed:
 
 
 
First add the Headquarters Division.  Depress the Edit button and the "Add New Division" button will become editable.   Depress the "Add New Division" button  Enter the Division Number and name for the Headquarters division in the fields provided.   When setting up the Headquarters Division in the Secondary ManEx System  "This is the local division" or "This is the Headquarters division" boxes are NOT to be checked. 

Depress the "Save New Division" button.  To add a department depress the "Add New Department" button.  The Division number will default in, user then can enter in a Department Number and a Department Name in the fields provided.  There can be as many as 99 divisions.  Each Division can have up to 99 departments. 

Depress the "Save New Department" button.  The depress the Save button at the top of the screen.    




To add the Secondary division to the Secondary ManEx System  depress the Edit button and the "Add New Division" button will become editable.   Depress the "Add New Division" button  Enter a Division Number (other than '00' or the division number setup for the headquarters division) and a Division Name in the fields provided, when setting up the Secondary division to the Secondary ManEx System  the "This is the local division" box  MUST be checked. Depress the "Save New Division" button.  

To add a department depress the "Add New Department" button.  The Division number will default in and user may then enter a Department Number and a Department Name.  

After one or more divisions have been added, the user may EDIT a division, or ADD a Department to a division.  The division capability is intended to be used in conjunction with multi plant / division operations.  It can also be used without Multi plant / division module, however.  There can be as many as 99 divisions.  Each Division can have up to 99 departments. 

Highlight the Secondary Division and Check the "This is the local division" box.  This box MUST be checked when setting up the Secondary division in the Secondary ManEx System.  




User will need to "Update the General Ledger" information for the Secondary Divisions 02, 03, etc. 

Highlight the Secondary Divison and depress the "Update General Ledger" button located at the bottom of the screen.   




Depress the Edit button, select the Division, Department, and the GL Account Type from the pull downs. 
 
 
Depress the Edit button, select the Division, Department, and the GL Account Type from the pull downs.
 
 
Once these items have been selected user may then depress the   "Auto-create accounts for selected Div/Dep & GL Account Type" button, and the following screen will appear: 
 
 
 

All of the accounts to be generated will appear on the screen for the new Divison and Department.  If there are some accounts you want to exclude, turn the selection to “No”.

Note: You will want to exclude all Titles, Headings, Totals and Closing accounts, leaving only the Posting accounts.  (Otherwise you will have duplicate titles, etc. on the reports.) 

Depress the  Abandon changes button to abandon the changes.

Depress the "Generate and Save account numbers for those items marked "Yes"  and the following message will be displayed: 
 


Continue the above steps, starting with "Auto Create Accounts ..."   until ALL of the accounts have been created for all the New Divisions and/or New Departments. 
 
If the accounts have not been setup in the GL or the accounts for the department have been generated the following prompt will be displayed: 
 
 
User MUST then update AP accounts, with the correct account number for the Secondary ManEx system. 
 
 
AR Accounts
 
 
 
Bank Accounts
 
 
 
Inventory Default Accounts
 
 
 
 
After completing this section:  Print the Chart of Accounts to be sure that all of the accounts desired were added.  There should be account numbers xxxxxxx-00-00 for all of the accounts.  Then there should be account numbers xxxxxxx-01-xx for all of the accounts created for the Headquarters division and xxxxxxx-02-xx for all of the accounts created for the Secondary divisions, etc. 
 
 
 
 
Where Used:  This Setup is required to be completed prior to establishing a Chart of Accounts.

            «Mark as Completed in RoadMap  Section C Item 2-c»

 
 
 
 
 
 
 
Article ID: 4378