You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by reza sohbati <so...@gmail.com> on 2020/06/23 06:04:30 UTC
The Payment-Type definition in saving products and defining the GL account
Hi all.
I have a question about Fineract functionality and I don't know is this a
right place to ask my question !!!
As my understandings, In saving products we can define payment types and
assign an ASSET GL account to it.
Also in Client Account when we do a DEPOSIT or WITHDRAW, we have the
ability of choosing a payment type.
In cash deposit transaction I supposed to see the payment-type GL
account(which I set in production definition) transactions(Maybe instead
of cash account), but I saw a normal cash deposit entry.
My question is : In definition of Saving product we can define a
payment-type and set a GL account to it. why we set this configuration to
the product?
Thank you.
Re: The Payment-Type definition in saving products and defining the
GL account
Posted by Ankit Muellner <an...@muellners.org>.
Reza, your expectation is correct.
However, the Advanced Accounting Rule has an overide over normal accounting
mapping (feature right above Adv.) in Savings product. For this specific
reason, you get an undesired result of Cash dB instead of Cheque JL debit
entries.
Now this can be fixed by letting the system know to follow the normal
accounting map before letting Adv. Accounting rules to trigger JL entries
or vice versa, whichever case set you will require.
If you debug at code level, an old comment by Apache contributor leaves
dominance of Adv. Accounting Rule over normal account mapping. But this has
not been tested thoroughly leaving a gap here.
Such a solution framework also has critical utilities in
publishing sequential JL entries (where multiple CoA detail has to hit) e.g
w.r.t other Adv. Accounting rules such as Specific Income mapping.
We have recently fixed a bug on Specific Income and also the issue with
Adv. Over normal mapping. We will be posting the latter PR soon.
Let me know if you need me to pinpoint anything.
On Fri, Jun 26, 2020 at 1:17 PM reza sohbati <so...@gmail.com> wrote:
> Thank you Joseph and Ed for your guidance.
> I have got how to configure advancing accounting rules in a saving
> product and configuring payment-types as well.
> But let me do step by step to explain my question again:
> 1- In advanced accounting rules of saving-product definition map a
> Payment-type(CHEQUE) to a GL chequeBook(already defined GL).
> 2- In the client account list, create a new account from the defined
> saving product.
> 3- Approve and activate the account.
> 4- Make a deposit to newly created account and select the CHEQUE payment
> type
>
> Actual result : System makes a deposit and transactions entries contains
> two legs (Cr saving account and Dr CASH GL account)
> My Expected result is : after making deposit the transaction should be( *Cr
> saving account and Dr CEQUE GL account* )
>
> Is my expectation true? if not, please show me how to use payment-types.
> I used the online version(cui.fineract.dev
> <https://cui.fineract.dev/?baseApiUrl=https://demo.fineract.dev&tenantIdentifier=default> )
> to do the above test .
>
> Thanks for your help.
>
> Reza
>
>
>
> On Fri, Jun 26, 2020 at 4:20 AM Ed Cable <ed...@mifos.org> wrote:
>
>> Thanks Joseph for replying to Reza.
>>
>> Reza, to add to what Joseph says, you first define your GL accounts and
>> then when configuring your loan or savings products, if you enable cash or
>> accrual accounting, you can then specify with respective GL accounts get
>> debited and credits for various portfolio-related financial transactions
>> (interest expense, savings liability, etc.)
>>
>> As Joseph noted, when configuring accounting, you can set up advanced
>> accounting rules whereby for specific payment types you can map the
>> transaction to a specific source of funds so you're not limited to one
>> source of funds for that savings product but can have a different source of
>> funds debited/credited based on payment type. You first must also configure
>> the payment types that you support so they become available in the payment
>> type dropdown.
>>
>> Cheers,
>>
>> Ed
>>
>> On Thu, Jun 25, 2020 at 4:39 PM Joseph Cabral <jo...@gmail.com>
>> wrote:
>>
>>> Hi,
>>>
>>> You can map a GL account to a payment type using the Advanced Accounting
>>> Rules feature in Savings Product.
>>> [image: image.png]
>>>
>>> Regards,
>>>
>>> Joseph
>>>
>>> On Tue, Jun 23, 2020 at 2:05 PM reza sohbati <so...@gmail.com> wrote:
>>>
>>>> Hi all.
>>>> I have a question about Fineract functionality and I don't know is this
>>>> a right place to ask my question !!!
>>>>
>>>> As my understandings, In saving products we can define payment types
>>>> and assign an ASSET GL account to it.
>>>> Also in Client Account when we do a DEPOSIT or WITHDRAW, we have the
>>>> ability of choosing a payment type.
>>>>
>>>> In cash deposit transaction I supposed to see the payment-type GL
>>>> account(which I set in production definition) transactions(Maybe instead
>>>> of cash account), but I saw a normal cash deposit entry.
>>>>
>>>> My question is : In definition of Saving product we can define a
>>>> payment-type and set a GL account to it. why we set this configuration to
>>>> the product?
>>>>
>>>> Thank you.
>>>>
>>>>
>>>>
>>
>> --
>> *Ed Cable*
>> President/CEO, Mifos Initiative
>> edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
>>
>> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
>> <http://facebook.com/mifos> <http://www.twitter.com/mifos>
>>
>>
--
Ankit Müllner
Muellners Europe
+4581929792
This mail is governed by Muellners® IT policy.
The information contained in this e-mail and any accompanying documents may
contain information that is confidential or otherwise protected from
disclosure. If you are not the intended recipient of this message, or if
this message has been addressed to you in error, please immediately alert
the sender by reply e-mail and then delete this message, including any
attachments. Any dissemination, distribution or other use of the contents
of this message by anyone other than the intended recipient is strictly
prohibited. All messages sent to and from this e-mail address may be
monitored as permitted by applicable law and regulations to ensure
compliance with our internal policies and to protect our business. E-mails
are not secure and cannot be guaranteed to be error free as they can be
intercepted, amended, lost or destroyed, or contain viruses. You are deemed
to have accepted these risks if you communicate with us by e-mail.
Re: The Payment-Type definition in saving products and defining the
GL account
Posted by reza sohbati <so...@gmail.com>.
Thank you Ankit Muellner for response*.*
*Ed Cable, *I created a new product "حساب قرض الحسنه" its Persian(sorry
its not an English name).
In product payment-type mapping, we can only map an ASSET type JL account
to a payment type, why only ASSET? Am I be able to choose a LIABILITY type
account here for example?
On Fri, Jun 26, 2020 at 11:37 PM Ed Cable <ed...@mifos.org> wrote:
> Reza, which products had you configured on cui.finerat.dev? The customer
> and vendor savings products?
>
> I was trying to troubleshoot your configuration.
>
> Ed
>
> On Fri, Jun 26, 2020 at 4:17 AM reza sohbati <so...@gmail.com> wrote:
>
>> Thank you Joseph and Ed for your guidance.
>> I have got how to configure advancing accounting rules in a saving
>> product and configuring payment-types as well.
>> But let me do step by step to explain my question again:
>> 1- In advanced accounting rules of saving-product definition map a
>> Payment-type(CHEQUE) to a GL chequeBook(already defined GL).
>> 2- In the client account list, create a new account from the defined
>> saving product.
>> 3- Approve and activate the account.
>> 4- Make a deposit to newly created account and select the CHEQUE payment
>> type
>>
>> Actual result : System makes a deposit and transactions entries contains
>> two legs (Cr saving account and Dr CASH GL account)
>> My Expected result is : after making deposit the transaction should be( *Cr
>> saving account and Dr CEQUE GL account* )
>>
>> Is my expectation true? if not, please show me how to use payment-types.
>> I used the online version(cui.fineract.dev
>> <https://cui.fineract.dev/?baseApiUrl=https://demo.fineract.dev&tenantIdentifier=default> )
>> to do the above test .
>>
>> Thanks for your help.
>>
>> Reza
>>
>>
>>
>> On Fri, Jun 26, 2020 at 4:20 AM Ed Cable <ed...@mifos.org> wrote:
>>
>>> Thanks Joseph for replying to Reza.
>>>
>>> Reza, to add to what Joseph says, you first define your GL accounts and
>>> then when configuring your loan or savings products, if you enable cash or
>>> accrual accounting, you can then specify with respective GL accounts get
>>> debited and credits for various portfolio-related financial transactions
>>> (interest expense, savings liability, etc.)
>>>
>>> As Joseph noted, when configuring accounting, you can set up advanced
>>> accounting rules whereby for specific payment types you can map the
>>> transaction to a specific source of funds so you're not limited to one
>>> source of funds for that savings product but can have a different source of
>>> funds debited/credited based on payment type. You first must also configure
>>> the payment types that you support so they become available in the payment
>>> type dropdown.
>>>
>>> Cheers,
>>>
>>> Ed
>>>
>>> On Thu, Jun 25, 2020 at 4:39 PM Joseph Cabral <jo...@gmail.com>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> You can map a GL account to a payment type using the Advanced
>>>> Accounting Rules feature in Savings Product.
>>>> [image: image.png]
>>>>
>>>> Regards,
>>>>
>>>> Joseph
>>>>
>>>> On Tue, Jun 23, 2020 at 2:05 PM reza sohbati <so...@gmail.com> wrote:
>>>>
>>>>> Hi all.
>>>>> I have a question about Fineract functionality and I don't know is
>>>>> this a right place to ask my question !!!
>>>>>
>>>>> As my understandings, In saving products we can define payment types
>>>>> and assign an ASSET GL account to it.
>>>>> Also in Client Account when we do a DEPOSIT or WITHDRAW, we have the
>>>>> ability of choosing a payment type.
>>>>>
>>>>> In cash deposit transaction I supposed to see the payment-type GL
>>>>> account(which I set in production definition) transactions(Maybe instead
>>>>> of cash account), but I saw a normal cash deposit entry.
>>>>>
>>>>> My question is : In definition of Saving product we can define a
>>>>> payment-type and set a GL account to it. why we set this configuration to
>>>>> the product?
>>>>>
>>>>> Thank you.
>>>>>
>>>>>
>>>>>
>>>
>>> --
>>> *Ed Cable*
>>> President/CEO, Mifos Initiative
>>> edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
>>>
>>> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
>>> <http://facebook.com/mifos> <http://www.twitter.com/mifos>
>>>
>>>
>
> --
> *Ed Cable*
> President/CEO, Mifos Initiative
> edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
>
> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
> <http://facebook.com/mifos> <http://www.twitter.com/mifos>
>
>
Re: The Payment-Type definition in saving products and defining the
GL account
Posted by Ed Cable <ed...@mifos.org>.
Reza, which products had you configured on cui.finerat.dev? The customer
and vendor savings products?
I was trying to troubleshoot your configuration.
Ed
On Fri, Jun 26, 2020 at 4:17 AM reza sohbati <so...@gmail.com> wrote:
> Thank you Joseph and Ed for your guidance.
> I have got how to configure advancing accounting rules in a saving
> product and configuring payment-types as well.
> But let me do step by step to explain my question again:
> 1- In advanced accounting rules of saving-product definition map a
> Payment-type(CHEQUE) to a GL chequeBook(already defined GL).
> 2- In the client account list, create a new account from the defined
> saving product.
> 3- Approve and activate the account.
> 4- Make a deposit to newly created account and select the CHEQUE payment
> type
>
> Actual result : System makes a deposit and transactions entries contains
> two legs (Cr saving account and Dr CASH GL account)
> My Expected result is : after making deposit the transaction should be( *Cr
> saving account and Dr CEQUE GL account* )
>
> Is my expectation true? if not, please show me how to use payment-types.
> I used the online version(cui.fineract.dev
> <https://cui.fineract.dev/?baseApiUrl=https://demo.fineract.dev&tenantIdentifier=default> )
> to do the above test .
>
> Thanks for your help.
>
> Reza
>
>
>
> On Fri, Jun 26, 2020 at 4:20 AM Ed Cable <ed...@mifos.org> wrote:
>
>> Thanks Joseph for replying to Reza.
>>
>> Reza, to add to what Joseph says, you first define your GL accounts and
>> then when configuring your loan or savings products, if you enable cash or
>> accrual accounting, you can then specify with respective GL accounts get
>> debited and credits for various portfolio-related financial transactions
>> (interest expense, savings liability, etc.)
>>
>> As Joseph noted, when configuring accounting, you can set up advanced
>> accounting rules whereby for specific payment types you can map the
>> transaction to a specific source of funds so you're not limited to one
>> source of funds for that savings product but can have a different source of
>> funds debited/credited based on payment type. You first must also configure
>> the payment types that you support so they become available in the payment
>> type dropdown.
>>
>> Cheers,
>>
>> Ed
>>
>> On Thu, Jun 25, 2020 at 4:39 PM Joseph Cabral <jo...@gmail.com>
>> wrote:
>>
>>> Hi,
>>>
>>> You can map a GL account to a payment type using the Advanced Accounting
>>> Rules feature in Savings Product.
>>> [image: image.png]
>>>
>>> Regards,
>>>
>>> Joseph
>>>
>>> On Tue, Jun 23, 2020 at 2:05 PM reza sohbati <so...@gmail.com> wrote:
>>>
>>>> Hi all.
>>>> I have a question about Fineract functionality and I don't know is this
>>>> a right place to ask my question !!!
>>>>
>>>> As my understandings, In saving products we can define payment types
>>>> and assign an ASSET GL account to it.
>>>> Also in Client Account when we do a DEPOSIT or WITHDRAW, we have the
>>>> ability of choosing a payment type.
>>>>
>>>> In cash deposit transaction I supposed to see the payment-type GL
>>>> account(which I set in production definition) transactions(Maybe instead
>>>> of cash account), but I saw a normal cash deposit entry.
>>>>
>>>> My question is : In definition of Saving product we can define a
>>>> payment-type and set a GL account to it. why we set this configuration to
>>>> the product?
>>>>
>>>> Thank you.
>>>>
>>>>
>>>>
>>
>> --
>> *Ed Cable*
>> President/CEO, Mifos Initiative
>> edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
>>
>> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
>> <http://facebook.com/mifos> <http://www.twitter.com/mifos>
>>
>>
--
*Ed Cable*
President/CEO, Mifos Initiative
edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
*Collectively Creating a World of 3 Billion Maries | *http://mifos.org
<http://facebook.com/mifos> <http://www.twitter.com/mifos>
Re: The Payment-Type definition in saving products and defining the
GL account
Posted by reza sohbati <so...@gmail.com>.
Thank you Joseph and Ed for your guidance.
I have got how to configure advancing accounting rules in a saving
product and configuring payment-types as well.
But let me do step by step to explain my question again:
1- In advanced accounting rules of saving-product definition map a
Payment-type(CHEQUE) to a GL chequeBook(already defined GL).
2- In the client account list, create a new account from the defined
saving product.
3- Approve and activate the account.
4- Make a deposit to newly created account and select the CHEQUE payment
type
Actual result : System makes a deposit and transactions entries contains
two legs (Cr saving account and Dr CASH GL account)
My Expected result is : after making deposit the transaction should be( *Cr
saving account and Dr CEQUE GL account* )
Is my expectation true? if not, please show me how to use payment-types.
I used the online version(cui.fineract.dev
<https://cui.fineract.dev/?baseApiUrl=https://demo.fineract.dev&tenantIdentifier=default>
)
to do the above test .
Thanks for your help.
Reza
On Fri, Jun 26, 2020 at 4:20 AM Ed Cable <ed...@mifos.org> wrote:
> Thanks Joseph for replying to Reza.
>
> Reza, to add to what Joseph says, you first define your GL accounts and
> then when configuring your loan or savings products, if you enable cash or
> accrual accounting, you can then specify with respective GL accounts get
> debited and credits for various portfolio-related financial transactions
> (interest expense, savings liability, etc.)
>
> As Joseph noted, when configuring accounting, you can set up advanced
> accounting rules whereby for specific payment types you can map the
> transaction to a specific source of funds so you're not limited to one
> source of funds for that savings product but can have a different source of
> funds debited/credited based on payment type. You first must also configure
> the payment types that you support so they become available in the payment
> type dropdown.
>
> Cheers,
>
> Ed
>
> On Thu, Jun 25, 2020 at 4:39 PM Joseph Cabral <jo...@gmail.com>
> wrote:
>
>> Hi,
>>
>> You can map a GL account to a payment type using the Advanced Accounting
>> Rules feature in Savings Product.
>> [image: image.png]
>>
>> Regards,
>>
>> Joseph
>>
>> On Tue, Jun 23, 2020 at 2:05 PM reza sohbati <so...@gmail.com> wrote:
>>
>>> Hi all.
>>> I have a question about Fineract functionality and I don't know is this
>>> a right place to ask my question !!!
>>>
>>> As my understandings, In saving products we can define payment types
>>> and assign an ASSET GL account to it.
>>> Also in Client Account when we do a DEPOSIT or WITHDRAW, we have the
>>> ability of choosing a payment type.
>>>
>>> In cash deposit transaction I supposed to see the payment-type GL
>>> account(which I set in production definition) transactions(Maybe instead
>>> of cash account), but I saw a normal cash deposit entry.
>>>
>>> My question is : In definition of Saving product we can define a
>>> payment-type and set a GL account to it. why we set this configuration to
>>> the product?
>>>
>>> Thank you.
>>>
>>>
>>>
>
> --
> *Ed Cable*
> President/CEO, Mifos Initiative
> edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
>
> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org
> <http://facebook.com/mifos> <http://www.twitter.com/mifos>
>
>
Re: The Payment-Type definition in saving products and defining the
GL account
Posted by Ed Cable <ed...@mifos.org>.
Thanks Joseph for replying to Reza.
Reza, to add to what Joseph says, you first define your GL accounts and
then when configuring your loan or savings products, if you enable cash or
accrual accounting, you can then specify with respective GL accounts get
debited and credits for various portfolio-related financial transactions
(interest expense, savings liability, etc.)
As Joseph noted, when configuring accounting, you can set up advanced
accounting rules whereby for specific payment types you can map the
transaction to a specific source of funds so you're not limited to one
source of funds for that savings product but can have a different source of
funds debited/credited based on payment type. You first must also configure
the payment types that you support so they become available in the payment
type dropdown.
Cheers,
Ed
On Thu, Jun 25, 2020 at 4:39 PM Joseph Cabral <jo...@gmail.com>
wrote:
> Hi,
>
> You can map a GL account to a payment type using the Advanced Accounting
> Rules feature in Savings Product.
> [image: image.png]
>
> Regards,
>
> Joseph
>
> On Tue, Jun 23, 2020 at 2:05 PM reza sohbati <so...@gmail.com> wrote:
>
>> Hi all.
>> I have a question about Fineract functionality and I don't know is this a
>> right place to ask my question !!!
>>
>> As my understandings, In saving products we can define payment types and
>> assign an ASSET GL account to it.
>> Also in Client Account when we do a DEPOSIT or WITHDRAW, we have the
>> ability of choosing a payment type.
>>
>> In cash deposit transaction I supposed to see the payment-type GL
>> account(which I set in production definition) transactions(Maybe instead
>> of cash account), but I saw a normal cash deposit entry.
>>
>> My question is : In definition of Saving product we can define a
>> payment-type and set a GL account to it. why we set this configuration to
>> the product?
>>
>> Thank you.
>>
>>
>>
--
*Ed Cable*
President/CEO, Mifos Initiative
edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649
*Collectively Creating a World of 3 Billion Maries | *http://mifos.org
<http://facebook.com/mifos> <http://www.twitter.com/mifos>
Re: The Payment-Type definition in saving products and defining the
GL account
Posted by Joseph Cabral <jo...@gmail.com>.
Hi,
You can map a GL account to a payment type using the Advanced Accounting
Rules feature in Savings Product.
[image: image.png]
Regards,
Joseph
On Tue, Jun 23, 2020 at 2:05 PM reza sohbati <so...@gmail.com> wrote:
> Hi all.
> I have a question about Fineract functionality and I don't know is this a
> right place to ask my question !!!
>
> As my understandings, In saving products we can define payment types and
> assign an ASSET GL account to it.
> Also in Client Account when we do a DEPOSIT or WITHDRAW, we have the
> ability of choosing a payment type.
>
> In cash deposit transaction I supposed to see the payment-type GL
> account(which I set in production definition) transactions(Maybe instead
> of cash account), but I saw a normal cash deposit entry.
>
> My question is : In definition of Saving product we can define a
> payment-type and set a GL account to it. why we set this configuration to
> the product?
>
> Thank you.
>
>
>