Difference between revisions of "Setup Custom Account Combination using User List"
From ADempiere
This Wiki is read-only for reference purposes to avoid broken links.
m (Created page with ''''Steps:''' * Create new Tree ** As Client, open Tree window and new record. <pre> Name: Cost Center Tree Type|Area: Element Value All Node: True </pre> * Create new Account El…') |
m |
||
Line 16: | Line 16: | ||
Tree: Cost Center Tree | Tree: Cost Center Tree | ||
</pre> | </pre> | ||
− | + | :* Add Element Value, as following, | |
<pre> | <pre> | ||
Search Key | Name | Search Key | Name | ||
Line 26: | Line 26: | ||
040 | Samui Island Sales Office | 040 | Samui Island Sales Office | ||
050 | Hui Hin Sales Office | 050 | Hui Hin Sales Office | ||
− | 999 | TOTAL COST CENTRE | + | 999 | TOTAL COST CENTRE (Summary Level) |
</pre> | </pre> | ||
[[File:ac_acct_element.jpg|600px]] | [[File:ac_acct_element.jpg|600px]] | ||
+ | * Create new Accounting Schema Element (or so call, Combination) | ||
+ | ** As Client, open Accounting Schema > Accounting Schema Element, new record | ||
+ | <pre> | ||
+ | Name: Cost Center | ||
+ | Type: User List 1 | ||
+ | Element: Cost Center | ||
+ | </pre> | ||
+ | * Change Label of "User List 1" to "Cost Center" | ||
+ | ** Re-login as System, open Element window and search for "User List 1" | ||
+ | ** Change name to "Cost Center" | ||
+ | |||
+ | Re-login again, now, in the Sales Order window you will see new field "Cost Center" with the list all cost center we have filled in previously. | ||
+ | |||
+ | [[File:ac_cost_center.jpg|500px]] | ||
+ | |||
+ | ;Summary of characters when we define the new Cost Center this way, | ||
+ | * The new Cost Center will be carried over automatically, i.e., when Invoice is created from this Sales Order. | ||
+ | * When document is posted, the new Cost Center will be in the Fact Account table. | ||
+ | [[File:ac_posting.jpg|500px]] | ||
+ | * This new Cost Center will also available in Account Info for analysis, | ||
+ | [[File:ac_account_info.jpg]] |
Revision as of 05:26, 16 October 2012
Steps:
- Create new Tree
- As Client, open Tree window and new record.
Name: Cost Center Tree Type|Area: Element Value All Node: True
- Create new Account Element
- As Client, open Account Element and new record.
Org: * Name: Cost Center Type: Account Tree: Cost Center Tree
- Add Element Value, as following,
Search Key | Name ------------------ 000 | No Cost Centre 010 | Phang Nga Office 020 | Khoa Lak Office 030 | Phuket Sales Office 040 | Samui Island Sales Office 050 | Hui Hin Sales Office 999 | TOTAL COST CENTRE (Summary Level)
- Create new Accounting Schema Element (or so call, Combination)
- As Client, open Accounting Schema > Accounting Schema Element, new record
Name: Cost Center Type: User List 1 Element: Cost Center
- Change Label of "User List 1" to "Cost Center"
- Re-login as System, open Element window and search for "User List 1"
- Change name to "Cost Center"
Re-login again, now, in the Sales Order window you will see new field "Cost Center" with the list all cost center we have filled in previously.
- Summary of characters when we define the new Cost Center this way,
- The new Cost Center will be carried over automatically, i.e., when Invoice is created from this Sales Order.
- When document is posted, the new Cost Center will be in the Fact Account table.
- This new Cost Center will also available in Account Info for analysis,