Setup/Setting Up Multi-Level Chart Of Accounts
Multi-Level Chart Of Accounts
Creating a Management View
Location
Setup > Accounts > Multi-Level COA
Action
> Click SETUP activity
> Click ACCOUNTS
> Click MULTI-LEVEL COA module
> Click NEW
CODE enter MV01NAME enter Management View
Setting up Default Group
Location
Setup > Accounts > Multi-Level COA
Action
> Click on Std 1 Lvl
As default, Level One Group is created.
The system will take a few seconds to generate the list from the all your Chart of Accounts.
Location
Setup > Accounts > Multi-Level COA
Action
You can create a New Group by:
> Right-click on a GROUP
> Select GROUP
> Add Grouping in Lower Level> Add Grouping in Same Level
> CODE enter a unique code
> DESCRIPTION enter
Location
Setup > Accounts > Multi-Level COA
Action
Deleting a Group
> Right-click on a GROUP
> Select REMOVE
Removing an
Account from
a Group
Location
Setup > Accounts > Multi-Level COA
Action
> Click and Hold on the ACCOUNT you want to remove.
> Drag it to the Available Accounts box.
> Let go to remove the ACCOUNT.
> Alternatively, Right-Click the ACCOUNT you want to remove.
> Select REMOVE
Adding an
Account from
a Group
Location
Setup > Accounts > Multi-Level COA
Action
> SEARCH BOX enter Misc
This will filter from Box B this list of Accounts which is not been Grouped.
> Click on the Group
(that you wish the account to be
grouped)
> Double-Click on the Account
(that you want to group)
> Close Module
Creating a Standard View with Your Sorting Order
Location
Setup > Accounts > Multi-Level COA
Action
> Click SETUP activity
> Click ACCOUNTS
> Click MULTI-LEVEL COA module
> Click NEW
CODE enter STD01NAME enter Standard View
> Click CREATE STANDARD ZERO LEVEL
> Click on [v] or [^]
This will arrange the order that they are listed. Hence, whenever you generate a Profit & Loss or Balance Sheet Reports with Standard View, it will follow this order.
> Click ADD
Applying the Multi-Level COA on Profit & Loss
Location
Report > Financial > Profit/Loss
Action
> Click on REFRESH
> Click on REPORT
Choose By Month (Financial Year) -PL-S0102
> Choose your Financial Year
> Choose your Chart Group
Click on MV01 - Management ViewNotice those created at Multi-Level Chart of Accounts can be applied here.
> Choose your Chart Level
Click on 1
> Click on PRINT
Notice that only Group Names are displayed.
> Close the Print Dialog box
> Choose your Chart Level
Click on 2
> Click on PRINT
Notice that the Accounts in the Grouping are now displayed.
Applying the Multi-Level COA on Balance Sheet
Location
Report > Financial > Balance Sheet
Action
> Click on REFRESH
> Click on REPORT
Choose Balance Sheet - BS-S0001
> Choose your Financial Year
> Choose your Chart Group
Click on MV01 - Management ViewNotice those created at Multi-Level Chart of Accounts can be applied here.
> Choose your Chart Level
Click on 1
> Click on PRINT
Notice that only Group Names are displayed.
> Close the Print Dialog box
> Choose your Chart Level
Click on 2
> Click on PRINT
Notice that the Accounts in the Grouping are now displayed.
Related Articles
Setup/ Setting Up Chart Of Accounts
Creating an Expense Account Location Setup Activity> Account Module Action > Click SETUP activity > Click ACCOUNTS > Click CHART OF ACCOUNT module > Click NEW > CODE enter EXP3301 Enter EXP as it is an expense account, and a unique number > CATEGORY ...Accounting Multi level Chart Of Account
Training PDF can be downloaded from 'Attachment' section below.Report / Multi-Year Project
Multi-Year Project Create a Chart of Account for Project Claim In order for you to capture the value of the progress claimed, you are required to a chart of account to monitor it. Location Setup >Accounts > Chart of Account Action > Click SETUP ...Multi Currency / Setting Bank, Mode & Business Partner in Foreign Multi Currency
Creating a Bank Account in Foreign Multi Currency Location > Setup > Chart of Account Action > Click SETUP activity > Click ACCOUNTS > Click CHART OF ACCOUNT module > Select Bank 2 > Click EDIT > DESCRIPTION rename Bank USD > CURRENCY select USD > ...Report / Budgeting
Budgeting Location Budget Action > Budget Group This enables you to give a name to your budget. You may have as many Budget Groups as you like. E.g. Sales 2012 Budget, Expense 2012 Budget, etc. > Budget Registration This enables you to give a name to ...