fineract-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thisura (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (FINERACT-389) Arrange the accounts that fall under one account type in order of their GL codes
Date Mon, 10 Apr 2017 18:55:41 GMT

    [ https://issues.apache.org/jira/browse/FINERACT-389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15963344#comment-15963344
] 

Thisura commented on FINERACT-389:
----------------------------------

There is a limitation in implementing. In the database, we are storing only the "classification_enum"
in the "acc_gl_account"

Classification Enum has the following values for respective account types. 

{code}
ASSET - 1
LIABILITY - 2 
EQUITY - 3
INCOME - 4
EXPENSE - 5
{code}

The values can't be used to reflect the ascending order of names. Therefore ORDER BY "classification_enum"
won't work in the sql query.

There fore we have two options.

* Write a sorting function to sort the result set based on the classification_enum and then
on gl_code.
* Change the classification_enum values to reflect the ascending order of account types and
add ORDER BY classification_enum ASC, gl_code ASC
The changed enums will look like follows. 
{code}
ASSET - 1
LIABILITY - 5
EQUITY - 3
INCOME - 4
EXPENSE - 2
{code}

> Arrange the accounts that fall under one account type in order of their GL codes
> --------------------------------------------------------------------------------
>
>                 Key: FINERACT-389
>                 URL: https://issues.apache.org/jira/browse/FINERACT-389
>             Project: Apache Fineract
>          Issue Type: Improvement
>          Components: Accounting
>            Reporter: Santosh Math
>            Assignee: Markus Geiss
>            Priority: Minor
>              Labels: p2
>
> Reported by Mexina Daniel at https://mifosforge.jira.com/browse/MIFOSX-2825
> Original Description:
> Accounts in chart of accounts are arranged by their account type but those accounts in
the specific account type are randomly arranged.
> I was recommending for the accounts in the same account type to be arranged by their
GL code. Since the relating accounts will be under one header and so their GL codes will be
following each other and bring presentable arrangement. (accounts in the same header, their
GL codes should have relation)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message