osdir.com

[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


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