IMPORTANT |
It is extremely important that you set up and work within your own company to maintain your data integrity. If you work within any other company, your exercises will not function as intended and the data of other students might be affected. Predictable exercise results require that your data is isolated in your own company. |
Purpose: The purpose of this exercise is to set up the
structure of different segments for reporting purposes. Also define the
different connections to sub ledgers, such as Fixed Assets, Costing, Project
Accounting.
Windows:
Define Code String
Code Part | Internal Name | Code Used | Code Part Function | Logical Code Part | Max No of Char | Description |
A | Account | Yes | No Function | Not Used | 10 | Account |
B | Cost center | Yes | No Function | Cost center | 10 | Cost Center |
C | Sales | Yes | No Function | Not Used | 10 | Sales Representative |
D | Region | Yes | No Function | Not Used | 10 | Market, Regions and Internal Dept. |
E | Asset | Yes | Fixed Asset Accounting | Object | 10 | Asset |
F | Project | Yes | Project Accounting | Project | 10 | Project |
G | Currency | Yes | Currency Balance | Not Used | 10 | Currency |
H | Elimination | Yes | Internal Elimination | Not Used | 10 | Internal Company Elimination |
I | Product Family | Yes | No Function | Not Used | 10 | Product Family for Services and Products |
J | Consolidation | Yes | Consolidation | Not Used | 10 | Parent Company Consolidation |
Note: Select the Base for Project Cost/Revenue Element check box to set the corresponding cost/revenue element as the base for project cost/revenue elements.
Purpose: The purpose of this exercise is to categorize and set up default values for code part requirements for posting control reasons.
Windows:
Account Types
Code Part Demands | Requirement: |
Cost center | Mandatory |
Sales | Can |
Region | Can |
Asset | Blocked |
Project | Can |
Currency | Blocked |
Elimination | Can |
Product Family | Can |
Consolidation | Blocked |
Later on, the asset code part will be opened for depreciation cost accounts. Also, some revenue and cost accounts will have a more controlled posting control.
When saving your changes, click Yes to update the requirements for all accounts.
Purpose: The purpose of this exercise is to enter new
account groups and later on connect them to different accounts.
Windows:
Account Groups
Open the window and populate.
Click New and add the following groups (if they are not already entered):
Account Group | Description: |
303 | Discounts on sales |
420 | Purchase of goods and materials |
470 | Price reduction on purchase price |
170 | Prepaid expenses and accrued income |
Save the records.
Purpose: The purpose of this exercise is to enter new accounts and to connect these and other accounts to the previously created account groups.
Windows:
Account
Account | Description | Account Type | Account Group |
3032 | Sales discount - products | REVENUE | 303 |
3033 | Sales discount - services | REVENUE | 303 |
4702 | Purchase discount - products | COST | 470 |
4703 | Purchase discount - services | COST | 470 |
1700 | Prepaid expense | ASSET | 170 |
Purpose: The purpose of these exercises is to add new regions, sales representatives, product family segments and independent cost centers to the company.
Windows:
Code Part Values
Cost Center | Description |
100 | Finance |
200 | Sales |
210 | Sales East |
211 | Sales East 100 |
212 | Sales East 200 |
250 | Sales West |
251 | Sales West 100 |
252 | Sales West 200 |
300 | Maintenance |
400 | Manufacturing |
410 | Production |
420 | Planning |
430 | Inventory |
500 | Purchasing |
600 | Marketing |
700 | General & Administration |
Cost Center | Description |
101 | Accountancy |
102 | Financial administration |
103 | IT-services |
201 | Sales administration |
401 | Manufacturing department 1 |
402 | Manufacturing department 2 |
403 | Manufacturing department 3 |
501 | Human resources |
601 | Tele marketing |
602 | Marketing administration |
Sales | Description |
101 | Johnson |
102 | Koller |
201 | Jones |
901 | Internal |
Region | Description |
EAST | East of Mississippi |
WEST | West of Mississippi |
Product Family | Description |
CONS | Consulting |
CARS | Race cars |
TIRES | Tires |
MAINT | Maintenance and service agreements |