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.

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