How to make new account dimension use user element?

[Hiep Lq]

Hi everyone.

I want view all expense for each order_line.

because i think about make a new dimension is order_line_id.

I find a guideline http://www.adempiere.com/Setup_Custom_Account_Combination_using_User_List#Create_new_Accounting_Schema_Element_.28new_Dimension.29

I read "User Element will allow you to define any Table's Column to be used as a new dimension" and think i is suitable, because i want make column order_line_id as a dimension.

but i also read "As for User Element, it is quite simple and straight forward and is not the intention of this tutorial."

I don't know "simple and straight forward" :) because I don't begin try setup it.

please help me if you can.

thanks.

[Carlos Antonio Ruiz Gomez]

you define a new element in the account element, define the elements and tree in second tab and just use it.

[Hiep Lq]

Hi Carlos.

I flow your advice.

I make a new element in "Account element". 

in second tab, I don't know make what account.

I also see any relate to user element and sale order id.

I find a guideline http://sourceforge.net/p/adempiere/discussion/610548/thread/f770ef10

but don't make it work.

please help me detail guideline.

many thanks for support!

[Carlos Antonio Ruiz Gomez]

Hiep, I just set up a new Dimension for an Account Element called Industry on http://demo.idempiere.com

You can check the setup there.

As that configuration will be gone on next db refresh I would suggest to create a wiki page to document that configuration if possible.

Regards,

Carlos Ruiz

[Sam-Hem]

Dear Carlos,

This is a gud job, i was searching for this sort of a feature.

I need to create two dimensions that is 'Cost Center' & 'Department" to capture financial transactions.

I have a issue on adding these dimensions to transaction windows and also to reports as parameters.

Do i need to add these one by one to to transaction windows or is there any single process to add these dimensions to all transaction windows.

Thanks. 

[Carlos Antonio Ruiz Gomez]

See window Accounting Schema, tab Account Schema Element

[Hiep Lq]

Hi Carlos.

I have see your sample. It is for user1_id (user list) 

This way is also ok with me. but current i see new element of tree is manual create.

how to make it auto as is org, business partner,..

In tree window, field type|area i see use1->user4

maybe link it to order_line_id?

I will update wiki when i complete.

[Mohamad Iqbal]

Hi Everyone,

I need to make my custom table as a new account dimension. I try to use User Element type approach as pointed here ;

1. Create new Account schema dimension in Accounting Schema window
2. Chose User Column 1 Type, and
3. Select my custom ID column.

But then I found out that UserElement1_ID element is only used on C_ValidCombination and Fact_Acct. In GL_JournalLine is in active and there isn't used in any other table like Invoice or Payment.

So is User Element type approach for custom account dimension still valid?

Then I try to use User List type as last posted in this post. My questions are:

1. How to link new element with custom table? ( so user can zoom into custom table)
2. Is there a way to automatically create element based on custom table? (instead of create manually)

Thank you for your help.

Regards,

Iqbal

[Suman Kharel]

Hi Iqbal,

If I understand you correctly, you are looking to add a new accounting dimension by using User column 1/2. The problem here is "User column 1" doesn't appear in all the documents. And User element allows only Account Element. 

I think this can be solved by adding a key column field wherever you need it and when the document is complete the system automatically captures column data and writes in Facts Acct table User Column field. I have been using the same approach to track charges/expenses linked with Assets etc.

Hope this helps!!

Regards,

Suman