git.net

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

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


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

S3598
image.png
L7130
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
> >
>