[
https://issues.apache.org/jira/browse/FINERACT-1147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17289513#comment-17289513
]
Francis Guchie commented on FINERACT-1147:
------------------------------------------
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 <
> 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)
