osdir.com

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Fineract, Standing Order Loan Repayment generates an extra journal entry


Hi Louis,
Nice to know you figure it out by yourself and thanks for sharing it with
Community.

Do u have any other doubts?

On Thu 26 Jul, 2018, 7:58 PM Louis Niyongabo, <lniyongabo@xxxxxxxxx> wrote:

> HI Santosh,
>
> I think I know now where it came from, thanks to recreating the same
> scenario in Staging using a different chart of accounts.
> It appears as if the same account was debited, credited then debited again
> simply because the account set in Financial Activity/ Liability Transfer
> was the same as the account set in Savings Control while defining the
> Savings Product. The account in  Financial Activity/ Liability Transfer
> acts as a Funds Transit Account to hold first the funds from savings before
> repaying the loan.
>
> Thanks,
>
> Louis
>
>
>
>
>
>
>
> On Thu, Jul 26, 2018 at 3:27 PM Louis Niyongabo <lniyongabo@xxxxxxxxx>
> wrote:
>
>> Hi Santosh,
>>
>> I created the same scenario in staging, see screenshot below. It does not
>> necessary has to be through Standing Order, even repaying loan using saving
>> account (one time transfer) has the same type of entries.
>> The redundant one is S3598, the L7130 entry should be be enough (Client =
>> 000000142)
>>
>> [image: image.png]
>>
>> *S3598*
>> [image: image.png]
>> *L7130*
>> [image: image.png]
>>
>>
>>
>>
>> On Thu, Jul 26, 2018 at 12:08 PM Louis Niyongabo <lniyongabo@xxxxxxxxx>
>> wrote:
>>
>>> ignore last message, finally logged in.
>>>
>>>
>>> On Thu, Jul 26, 2018 at 12:07 PM Louis Niyongabo <lniyongabo@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi Santosh,
>>>> It's the connection to the staging that's failing. I was trying to show
>>>> that even using local client to connect to the staging still fails, yet
>>>> demo works fine for both.
>>>>
>>>> On Thu, Jul 26, 2018 at 12:04 PM Santosh Math <
>>>> santosh@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>>>
>>>>> Hi Louis,
>>>>> Don't connect your local instance. Just reproduce same scenario on
>>>>> staging.
>>>>>
>>>>>
>>>>> On Thu 26 Jul, 2018, 2:57 PM Louis Niyongabo, <lniyongabo@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>> > Hi Santosh,
>>>>> > That link tries to load endlessly, it does not show the login page.
>>>>> > This http://localhost:9002/?baseApiUrl=https://staging.openmf.org#/
>>>>> > doesn't
>>>>> > go through either ( Couldn't connect to server. Make sure you are
>>>>> using
>>>>> > correct settings)
>>>>> > But, https://staging.openmf.org#/home and
>>>>> > http://localhost:9002/?baseApiUrl=https://demo.openmf.org#/home
>>>>> work just
>>>>> > fine.
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> > On Thu, Jul 26, 2018 at 11:01 AM Santosh Math <
>>>>> > santosh@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>>>> >
>>>>> > > Hi Louis,
>>>>> > >
>>>>> > > Could you recreate  the  scenario here and share the link?
>>>>> > >
>>>>> > > https://staging.openmf.org/#/home
>>>>> > >
>>>>> > > On Thu, Jul 26, 2018 at 2:25 PM, Louis Niyongabo <
>>>>> lniyongabo@xxxxxxxxx>
>>>>> > > wrote:
>>>>> > >
>>>>> > > > Hi Santosh,
>>>>> > > > The journal entry is viewable as well on UI, debit, credit, then
>>>>> > another
>>>>> > > > debit of the same account/amount.
>>>>> > > >
>>>>> > > > On Thu, Jul 26, 2018 at 9:16 AM Santosh Math <
>>>>> > > > santosh@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>>>> > > >
>>>>> > > > > Hi  Louis,
>>>>> > > > > Is this redundant journal entry  viewable on UI or it's just
>>>>> > creating
>>>>> > > it
>>>>> > > > > in database only?
>>>>> > > > >
>>>>> > > > > On Wed, Jul 25, 2018 at 8:50 PM, Louis Niyongabo <
>>>>> > lniyongabo@xxxxxxxxx
>>>>> > > >
>>>>> > > > > wrote:
>>>>> > > > >
>>>>> > > > > > Did anyone experience a redundant journal entry for a
>>>>> standing
>>>>> > order
>>>>> > > > > > repaying a loan installment?
>>>>> > > > > >
>>>>> > > > > >
>>>>> > > > > >
>>>>> > > > > > In the  transactions of repayment of a loan installment from
>>>>> a
>>>>> > saving
>>>>> > > > > > account, I noticed:
>>>>> > > > > >
>>>>> > > > > > 1.       1 Saving Transaction in
>>>>> m_savings_account_transaction
>>>>> > > > > >
>>>>> > > > > > 2.       1 Loan Transaction in m_loan_transaction
>>>>> > > > > >
>>>>> > > > > > 3.       2 Journal entries in acc_gl_journal_entry:
>>>>> > > > > >
>>>>> > > > > > a.       1 Saving entry: debit and credit of same liability
>>>>> > account,
>>>>> > > > but
>>>>> > > > > > for
>>>>> > > > > > the same installment amount
>>>>> > > > > >
>>>>> > > > > > b.      1 Loan entry: debit of the installment amount on the
>>>>> same
>>>>> > > > > liability
>>>>> > > > > > account against a credit of asset account (principal) and
>>>>> income
>>>>> > > > account
>>>>> > > > > > (interest)
>>>>> > > > > >
>>>>> > > > > >
>>>>> > > > > >
>>>>> > > > > > Did I miss something in the product/standing order setup or
>>>>> the
>>>>> > first
>>>>> > > > > > journal saving entry is a requirement by Fineract?
>>>>> > > > > >
>>>>> > > > > >
>>>>> > > > > >
>>>>> > > > > > Thanks,
>>>>> > > > > >
>>>>> > > > > >
>>>>> > > > > >
>>>>> > > > > > Louis
>>>>> > > > > >
>>>>> > > > > >
>>>>> > > > > >
>>>>> > > > > >
>>>>> > > > >
>>>>> > > > >
>>>>> > > > > --
>>>>> > > > > Thanks & Regards
>>>>> > > > >
>>>>> > > > > Santosh Math
>>>>> > > > >
>>>>> > > > > *QA Engineer*
>>>>> > > > >
>>>>> > > > > *Conflux Technologies Pvt Ltd <
>>>>> http://www.confluxtechnologies.com/>*
>>>>> > > > > | *Office*: +91-080-41208662 |
>>>>> > > > >
>>>>> > > > > *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st
>>>>> Block,
>>>>> > > > > Bengaluru, Karnataka, 560043 INDIA
>>>>> > > > >
>>>>> > > >
>>>>> > >
>>>>> > >
>>>>> > >
>>>>> > > --
>>>>> > > Thanks & Regards
>>>>> > >
>>>>> > > Santosh Math
>>>>> > >
>>>>> > > *QA Engineer*
>>>>> > >
>>>>> > > *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/
>>>>> >*
>>>>> > > | *Office*: +91-080-41208662 |
>>>>> > >
>>>>> > > *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block,
>>>>> > > Bengaluru, Karnataka, 560043 INDIA
>>>>> > >
>>>>> >
>>>>>
>>>>