How to update the commitment amount on deposits via front end and SQL?
There is a requirement to keep updating the deposit amount (commitment amount) once created. This should be able to be updated via front end and SQL. Let me give an example.
1-Aug-2016 - Create a deposit with commitment amount = $3000
20-Aug-2016 - Customer pays $3000, receipt created and applied on deposit
10-Sep-2016 - Increase the commitment amount to $5000
Please advise how to handle the same. Thanks in advance