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 (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,
+
:* 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 | (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
 +
<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)

Ac acct element.jpg

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

Ac cost center.jpg

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.

Ac posting.jpg

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

Ac account info.jpg