Setup Custom Account Combination using User List

From iDempiere en

bring from adempiere wiki to complete

Accounting Dimension is a powerful 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 unique Dimension to our Account Combination?

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

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

Follow below steps to create a new dimension of type User Element (User Column)

Create new dimension table

for demo i use table Test (change data access level to all)

Create new Accounting Schema Element (new Dimension)

Name        | Type          | Column
Test        | User Column 1 | Test_ID
User Column 1 schema dimension .png

Add column Test_ID to window need add that dimension (invoice)

Test to invoice window.png
Add test column to invoice.png

now when you input test on invoice window then value will record to fact table when complete window

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

Create new Tree

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

Create new Account Element

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

Create new Accounting Schema Element (new Dimension)

  • We will be using the new Account Element we have created.
  • As Client, open Accounting Schema > Accounting Schema Element, add new record
Name        | Type        | Element
Cost Center | User List 1 | Cost Center
Cost Center schema dimension.png
  • That's all. We have enalbed User List 1 as new dimension and it will follow us in every account posting. Next we only want to make it more meaningful by changing the label.

Change Label of "User Element List 1" to "Cost Center"

  • Re-login as System, open Element window and search for "User Element List 1"
  • Change name to "Cost Center"
User1 ID.png

Re-login again, now, in the every document window, i.e., Sales Order, Invoice, etc..., you will see new field "Cost Center" with the list all cost center we have filled in previously.

Invoice for User Element 1.png

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

  • New dimension field will appear in every Document window.
  • 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.
Posted for User Element List 1.png
  • This new Cost Center will also available in Account Info for analysis,
Accounting for user element list 1.png
Cookies help us deliver our services. By using our services, you agree to our use of cookies.