OSDir


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

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


All set, thanks!



On Thu, Jul 26, 2018 at 4:35 PM Santosh Math <
santosh@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

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