OSDir


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

Re: Fineract, Overdrawn Saving Account crashes further Debit/Credit and Job Post Interest for Savings


Thank you very much.

Regards,

Louis


On Tue, Jul 24, 2018 at 13:18 Santosh Math <santosh@xxxxxxxxxxxxxxxxxxxxxxx>
wrote:

> Hi Louis,
>
> Thanks for clarification. I raised enhancement ticket here:
>
> https://issues.apache.org/jira/browse/FINERACT-641
>
>
>
> On Tue, Jul 24, 2018 at 12:20 PM, Louis Niyongabo <lniyongabo@xxxxxxxxx>
> wrote:
>
> > Hi Santosh,
> >
> > (1) Do your operations require that savings account must have overdrawn
> > feature as well as withdrawal fee?
> > It's only one specific product "Current Account" that requires that
> > feature.
> > Nominal Annual Interest Rate                            =0
> > Interest Compounding Period                             =Daily
> > Interest Posting Period                                 =Monthly
> > Interest Calculated Using                               =Daily Balance
> > Days in Years                                           =365 Days
> > Allow Overdraft                                 =true
> > Max Overdraft limit                                     =10,000
> > Nominal annual interest for overdraft                   =18
> > Min Overdraft Required For Interest Calculation =0
> > Withdrawal Fee                                  =Flat, 200
> >
> > (2) Do you charge withdrawal fee for overdrawn amount?
> > Yes, if it's cash withdrawal
> >
> > (3) Is it because of this you had to close culprit account and move the
> > balance to new account rather than just reversing the overdrawn
> transaction?
> > Reversing the overdrawn transaction would have worked, but the account
> was
> > closed to re-open another one without withdrawal fee.
> >
> > Thanks,
> >
> > Louis
> >
> > -----Original Message-----
> > From: Santosh Math [mailto:santosh@xxxxxxxxxxxxxxxxxxxxxxx]
> > Sent: Tuesday, July 24, 2018 05:10
> > To: Dev <dev@xxxxxxxxxxxxxxxxxxx>
> > Subject: Re: Fineract, Overdrawn Saving Account crashes further
> > Debit/Credit and Job Post Interest for Savings
> >
> > Hi Louis,
> >
> > "Post Interest for Savings" job debits the interest from overdrawn
> account
> > (based on interest defined for overdrawn account)   and credits interest
> to
> > the savings account (based  on the average daily balance  or daily
> > balance) if the account is not overdrawn.
> >
> > Do your operations require that savings account must have overdrawn
> > feature as well as withdrawal fee? Do you charge withdrawal fee for
> > overdrawn amount? Is it because of this you had to close culprit account
> > and move the balance to new account rather than just reversing the
> > overdrawn transaction?
> >
> > ​
> > --
> > 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
> >
> >
> >
> >
> > On Mon, Jul 23, 2018 at 4:07 PM, Louis Niyongabo <lniyongabo@xxxxxxxxx>
> > wrote:
> >
> > > Hi Santosh,
> > >
> > > Thanks for this clarification. I run into this when I was trying to
> > > derive some functionalities of Current Account from Saving Accounts.
> > >
> > > My problem is that when the Withdrawal Fee is enabled and the account
> > > is overdrawn the first time, further debits/credits cannot go through
> > anymore.
> > > I get this error message: Charges for Savings have Broken the
> > > accounting code. The same affect the job "Post Interest for Savings".
> > >
> > > It's fixed by reversing the overdrawing transaction, closing the
> > > culprit account and moving the balance to a new account without the
> > Withdrawal Fee.
> > >
> > > Am I doing something wrong?
> > >
> > > Thanks,
> > >
> > > Louis
> > >
> > > -----Original Message-----
> > > From: Santosh Math [mailto:santosh@xxxxxxxxxxxxxxxxxxxxxxx]
> > > Sent: Monday, July 23, 2018 12:04
> > > To: Dev <dev@xxxxxxxxxxxxxxxxxxx>
> > > Subject: Re: Fineract, Overdrawn Saving Account crashes further
> > > Debit/Credit and Job Post Interest for Savings
> > >
> > > Hi Louis,
> > >
> > > You're right. Cash withdrawal fee only applicable for savings
> withdrawal.
> > > For overdrawn amounts interest can be applied.
> > >
> > > Thanks
> > > Santosh
> > >
> > > On Sat, Jul 21, 2018 at 3:07 PM, Louis Niyongabo
> > > <lniyongabo@xxxxxxxxx>
> > > wrote:
> > >
> > > > It's finally narrowed down to single charge per transaction. A
> > > > saving account cannot be overdrawn through Cash Withdrawal if it has
> > > > Cash Withdrawal Fee Charge attached to it.
> > > >
> > > >
> > > >
> > > > From: Louis Niyongabo [mailto:lniyongabo@xxxxxxxxx]
> > > > Sent: Friday, July 20, 2018 11:37
> > > > To: dev@xxxxxxxxxxxxxxxxxxx
> > > > Subject: RE: Fineract, Overdrawn Saving Account crashes further
> > > > Debit/Credit and Job Post Interest for Savings
> > > >
> > > >
> > > >
> > > > For the debit and credit, the error message comes from this
> > > > org/apache/fineract/accounting/journalentry/service/
> > > > AccountingProcessorHelper.java.
> > > >
> > > >
> > > >
> > > > And there're comments in there:
> > > >
> > > >
> > > >
> > > > "        // TODO Vishwas: Remove this validation, as and when
> > appropriate
> > > > Junit
> > > >
> > > >         // tests are written for accounting
> > > >
> > > >         /**
> > > >
> > > >          * Accounting module currently supports a single charge per
> > > > transaction,
> > > >
> > > >          * throw an error if this is not the case here so any
> > > > developers
> > > >
> > > >          * changing the expected portfolio behavior would also take
> > > > care of
> > > >
> > > >          * modifying the accounting code appropriately
> > > >
> > > >          **/
> > > >
> > > > "
> > > >
> > > > Any idea on how to go passed this? Is related to the failing of the
> > job?
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > >
> > > >
> > > > Louis
> > > >
> > > >
> > > >
> > > > From: Louis Niyongabo [mailto:lniyongabo@xxxxxxxxx]
> > > > Sent: Friday, July 20, 2018 09:53
> > > > To: dev@xxxxxxxxxxxxxxxxxxx
> > > > Subject: Fineract, Overdrawn Saving Account crashes further
> > > > Debit/Credit and Job Post Interest for Savings
> > > >
> > > >
> > > >
> > > > Minimum Opening Balance=1,000
> > > >
> > > > Allow Overdraft=true
> > > >
> > > > Max Overdraft limit=10,000
> > > >
> > > > Nominal annual interest for overdraft=18
> > > >
> > > > Withdrawal Fee=Flat & 200
> > > >
> > > >
> > > >
> > > > Accounting:
> > > >
> > > > *************
> > > >
> > > > Savings Reference(Assets)=Cash
> > > >
> > > > Overdraft Portfolio(Assets)=Retail Overdraft
> > > >
> > > > Savings Control(Liabilities)=Personal current acc
> > > >
> > > > Transfers in suspense(Liabilities)=Suspense - Proxy accounts
> > > >
> > > > Interest on Savings(Expenses)=Savings
> > > >
> > > > Write-off(Expenses)=Current accounts retail
> > > >
> > > > Income from Fee(Income)=Cash Withdrawal Fees
> > > >
> > > > Income from Penalties(Income)=Penalty on Retail Accounts
> > > >
> > > > Overdraft Interest Income(Income)=Int. Retail Overdraft
> > > >
> > > >
> > > >
> > > > 1. Create Saving Account that inherits these Savings Account
> > > > Products settings.
> > > >
> > > > 2. Approve and Activate Account
> > > >
> > > > 3. Debit and Credit of Minimum Opening Balance OK
> > > >
> > > > 4. Overdraw the Account, the posting is OK, rights accounts &
> > > > amounts debited/credited
> > > >
> > > > 5. Credit/Debit the account after (4.), see error below:
> > > >
> > > > ==>Recent Portfolio changes w.r.t Charges for Savings have Broken
> > > > the accounting code -
> > > >
> > > > 6. run job "Post Interest for Savings", see error below:
> > > >
> > > > ==>org.apache.fineract.infrastructure.jobs.exception.
> > > JobExecutionException:
> > > >
> > > >
> > > > failed to post interest for Savings with id 2 with message null
> > > >
> > > > at
> > > > org.apache.fineract.portfolio.savings.service.
> > > > SavingsSchedularServiceImpl.po
> > > > stInterestForAccounts(76)
> > > >
> > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(-2) at
> > > > sun.reflect.NativeMethodAccessorImpl.invoke(-1)
> > > >
> > > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(-1) at
> > > > java.lang.reflect.Method.invoke(-1)
> > > >
> > > > at org.springframework.util.MethodInvoker.invoke(269)
> > > >
> > > > at
> > > > org.springframework.scheduling.quartz.MethodInvokingJobDetailFactory
> > > > Bean$Met
> > > > hodInvokingJob.executeInternal(322)
> > > >
> > > > at org.springframework.scheduling.quartz.QuartzJobBean.execute(112)
> > > > at
> > > > org.quartz.core.JobRunShell.run(213)
> > > >
> > > > at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(557)
> > > >
> > > >
> > >
> > >
> > > --
> > > 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
>