This will have serious after effects if you go ahead do it directly in sql columns like that
On Mon, Dec 14, 2020 at 2:02 AM Francis Guchie <[email protected]> wrote: > Allen, > > At the moment there is no API. I am going straight to the table > called m_savings_account ( using Hiedi SQL - Thanks to @Michael Vorburger > <[email protected]> ) > and i edit 2 columns as follows > > > *Using the script below * > > SET @savingsAccountNo := '000000002'; *-- this is the savings account > number* > SET @said := (SELECT id FROM m_savings_account sa WHERE sa.account_no = > @savingsAccountNo); > SET @lowestBalance := (SELECT Min(sat.running_balance_derived) FROM > m_savings_account_transaction sat WHERE sat.savings_account_id = @said) + > *<put > the transaction amount you want to make>* ; > > *############ setting the overdraft use the line below but make sure ther > last line is commented ##################################### * > UPDATE m_savings_account sa SET sa.allow_overdraft = 1, sa.overdraft_limit > = @lowestBalance WHERE sa.id = @said > > *#### once am done i reverse the situation like this for this to work u > have to comment the update above ###############################* > UPDATE m_savings_account sa SET sa.allow_overdraft = 0, sa.overdraft_limit > = null WHERE sa.id = @said > > > > > My Kind Regards > > Francis Guchie Kirago > *Skype:* francisguchie > *Telegram: *232 79 19 44 07 > *Whatsapp: *232 79 19 44 07 > *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ > twitter: @FrancisGuchie > > > > > > > > > > On Sun, Dec 13, 2020 at 12:00 AM Allen Bailochan Tuladhar < > [email protected]> wrote: > >> Hi Francis, >> >> Which API would I use to allow overdraft into an account? >> >> Regards, >> Allen. >> >> -----Original Message----- >> From: Francis Guchie (Jira) <[email protected]> >> Sent: Sunday, December 13, 2020 2:50 AM >> To: Allen Bailochan Tuladhar <[email protected]> >> Subject: [jira] [Assigned] (FINERACT-1147) Insufficient Balance error >> even if account has a balance >> >> >> [ >> https://issues.apache.org/jira/browse/FINERACT-1147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel >> ] >> >> Francis Guchie reassigned FINERACT-1147: >> ---------------------------------------- >> >> Assignee: Rahul Pawar >> >> > Insufficient Balance error even if account has a balance >> > -------------------------------------------------------- >> > >> > Key: FINERACT-1147 >> > URL: >> https://issues.apache.org/jira/browse/FINERACT-1147 >> > Project: Apache Fineract >> > Issue Type: Bug >> > Components: Savings >> > Affects Versions: 1.2.0, 1.3.0, 1.4.0 >> > Reporter: Francis Guchie >> > Assignee: Rahul Pawar >> > Priority: Major >> > Labels: hard >> > >> > Fineract recomputes for all previous transactions and fails when it >> finds overdraft has been disabled. >> > This "error" will happen during >> > 1-pay charges, 2- withrawals, 3- Transfer of funds , 4- Post interest >> > on overdraft Or Any transaction that "takes" money out of the account >> > >> > In the meantime, users can allow overdrafts in that account and the >> transactions will work. >> > !image-2020-09-11-17-59-17-663.png! >> > >> >> >> >> -- >> This message was sent by Atlassian Jira >> (v8.3.4#803005) >> >> Mifos-developer mailing list >> [email protected] >> Unsubscribe or change settings at: >> https://lists.sourceforge.net/lists/listinfo/mifos-developer > > -- Saransh Sharma *Research Partner* *Muellner Internet Pvt Ltd * ---------------------------------------------------------------------------------------------- The idea of separation of me and you is amazing. ---------------------------------------------------------------------------------------------- *Company Website <https://www.muellners.com/> **Company Linkedin <https://www.linkedin.com/company/muellners> *Company Facebook <https://www.facebook.com/muellners> This mail is governed by Muellner® Internet Private Limited's IT policy. The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited. All messages sent to and from this e-mail address may be monitored as permitted by applicable law and regulations to ensure compliance with our internal policies and to protect our business. E-mails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. You are deemed to have accepted these risks if you communicate with us by e-mail.
