Difference between revisions of "Setup Custom Account Combination using User List"

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.
m
m
Line 1: Line 1:
==Steps:==
+
Accounting Dimension is a power tool for analytic accounting. Out of the box, ADempiere has provided many Accounting Dimensions, i.e., Sales Region, Product, Partner, Campaign, Project, etc. These dimension will account into Accounting Combination (i.e., HQ-12110-_-_-_-_) which will be used when doing account posting. Each dimension will allow us to analyze our business in different angle?
  
* Create new Tree
+
;What if we want to add new specific Dimension to our Account Combination?
** As Client, open Tree window and new record.
+
 
 +
To answer this question, ADempiere prepared 4 additional fields (already in Fact_Acct table). You can add new Dimension from Accounting Schema > Accounting Schema Element
 +
 
 +
;1) Type User Element (2 fields)
 +
 
 +
:* UserElement1_ID (User Element 1), UserElement2_ID (User Element 2)
 +
:* User Element will allow you to define any Table's Column to be used as a new dimension.
 +
 
 +
;2) Type User List (2 fields)
 +
 
 +
:* User1_ID (User List 1), User2_ID (User List 2)
 +
:* User List will allow you to use Account Code from Account Element
 +
 
 +
As for User Element, it is quite simple and straight forward and is not the intention of this tutorial. As such, in this tutorial, we will cover only of type User List.
 +
 
 +
;Follow below steps to create a new dimension of type User List,
 +
 
 +
===Create new Tree===
 +
 
 +
* As Client, open Tree window and new record.
 
<pre>
 
<pre>
Name: Cost Center Tree
+
Name             | Type|Area    | All node
Type|Area: Element Value
+
-------------------------------------------
All Node: True
+
Cost Center Tree | Element Vlue | True
 
</pre>
 
</pre>
* Create new Account Element
+
 
** As Client, open Account Element and new record.
+
===Create new Account Element===
 +
 
 +
* As Client, open Account Element and new record.
 
<pre>
 
<pre>
Org: *
+
Org | Name        | Type    | Tree
Name: Cost Center
+
-----------------------------------------------
Type: Account
+
*   | Cost Center | Account | Cost Center Tree
Tree: Cost Center Tree
+
 
</pre>
 
</pre>
:* Add Element Value, as following,
+
* Add our sample Element Value, as following,
 
<pre>
 
<pre>
 
Search Key | Name  
 
Search Key | Name  
Line 28: Line 48:
 
999        | TOTAL COST CENTRE (Summary Level)
 
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
+
===Create new Accounting Schema Element (or so call, Combination)===
 +
 
 +
* As Client, open Accounting Schema > Accounting Schema Element, new record
 
<pre>
 
<pre>
Name: Cost Center
+
Name       | Type        | Element
Type: User List 1
+
----------------------------------------
Element: Cost Center
+
Cost Center | User List 1 | Cost Center
 
</pre>
 
</pre>
* Change Label of "User List 1" to "Cost Center"
+
 
** Re-login as System, open Element window and search for "User List 1"
+
===Change Label of "User List 1" to "Cost Center"===
** Change name 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.
 
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.
Line 44: Line 70:
 
[[File:ac_cost_center.jpg|500px]]
 
[[File:ac_cost_center.jpg|500px]]
  
;Summary of characters when we define the new Cost Center this way,
+
 
 +
===Summary of characters when we define the new Cost Center using User List===
 +
 
 
* The new Cost Center will be carried over automatically, i.e., when Invoice is created from this Sales Order.
 
* 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.
 
* When document is posted, the new Cost Center will be in the Fact Account table.

Revision as of 20:16, 16 October 2012

Accounting Dimension is a power tool for analytic accounting. Out of the box, ADempiere has provided many Accounting Dimensions, i.e., Sales Region, Product, Partner, Campaign, Project, etc. These dimension will account into Accounting Combination (i.e., HQ-12110-_-_-_-_) which will be used when doing account posting. Each dimension will allow us to analyze our business in different angle?

What if we want to add new specific Dimension to our Account Combination?

To answer this question, ADempiere prepared 4 additional fields (already in Fact_Acct table). You can add new Dimension from Accounting Schema > Accounting Schema Element

1) Type User Element (2 fields)
  • UserElement1_ID (User Element 1), UserElement2_ID (User Element 2)
  • User Element will allow you to define any Table's Column to be used as a new dimension.
2) Type User List (2 fields)
  • User1_ID (User List 1), User2_ID (User List 2)
  • User List will allow you to use Account Code from Account Element

As for User Element, it is quite simple and straight forward and is not the intention of this tutorial. As such, in this tutorial, we will cover only of type User List.

Follow below steps to create a new dimension of type User List,

Create new Tree

  • As Client, open Tree window and new record.
Name             | Type|Area    | All node
-------------------------------------------
Cost Center Tree | Element Vlue | True

Create new Account Element

  • As Client, open Account Element and new record.
Org | Name        | Type    | Tree
-----------------------------------------------
*   | Cost Center | Account | Cost Center Tree
  • Add our sample 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)

Ac acct element.jpg

Create new Accounting Schema Element (or so call, Combination)

  • As Client, open Accounting Schema > Accounting Schema Element, new record
Name        | Type        | Element
----------------------------------------
Cost Center | User List 1 | 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.

Ac cost center.jpg


Summary of characters when we define the new Cost Center using User List

  • 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.

Ac posting.jpg

  • This new Cost Center will also available in Account Info for analysis,

Ac account info.jpg