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 Prerequisites
DrillDown Icon Fields and Defintions
DrillDown Icon How To ......
DrillDown Icon Setup GL Account Types and Ranges
DrillDown Icon GL Divisions/Departments
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 GL Account Types and Ranges
Enter the 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 Account Types and Ranges
 
The following screen will be displayed:
 
 

Selecting the Add button allows the user to begin entry. 
 
Prepare the General Ledger account types (current assets & long term assets) by establishing lower and upper ranges of the account numbers. For example, cash is a current asset and all current assets are within a range of accounts from 1000000-00-00 to 1199999-00-00. Therefore create the title “Cash”.  This will be helpful later when searching for accounts in the accounting module.  What will happen is that ManEx will display the account types clicked on, the type of account desired, and then it will list all the accounts under that classification.  Once the ranges are created ManEx does NOT allow editing or changing the ranges.  Also, user cannot create a range that is within another range.  So, in setting up account ranges, it might be a consideration to leave some room between ranges in case there is a need for more at a later date (instead of setting it up so all possible account numbers are in some account type range, even if they are not yet created).
 
Selecting the Edit will allow the user to only modify the type of report in which it is included (Balance, Income) and the account signage (normally credit or debit) can be changed.    
 
Chart of accounts are setup in the GL Account Setup module.  In order for the sub-total Net Income Before Income Taxes to work correctly, a separate range must be set up and the Normal Balance must be defined as Credit, define the account as a CLOSING.  This rule also applies to Total Revenue, Gross Margin, Total Other Income/Expense, Net Income Before Taxes and Net Income.
 
Once the changes have been completed, depress the Save button to save changes, or the Abandon Changes button to abandon changes. 

Where Used:   This Setup is required to be completed prior to establishing a Chart of Accounts, and for processing all other accounting functions.

After completing this sectionMark as Completed in RoadMap  Section C Item 2-b»   

 
Article ID: 4370