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
