Use Update() instead of QuickSubmitToAux(). You'll also need to set a lock on the item.

Use Update() instead of QuickSubmitToAux(). You'll also need to set a lock on the item.

Thank you,  MichaelCFiala

I have tested the code. When I used the number value, the following statement worked without issues, but when I used the variable, the result wasn't correct.

balanceSelect.SetFieldValue("TS_BALANCE", 100);                           the value of BALANCE is changed to 100

balanceSelect.SetFieldValue("TS_BALANCE", timeTaken);                 the value of BALANCE isn't changed

The variable "timeTaken" was gotten from the field of primary table.

user.GetFieldValue("TS_ACTUAL_TIME_TAKEN", timeTaken);

The code I run:

def changeBalance(userId) {

var fldValue = int();
var timeTaken = int();
var user = Ext.CreateAppRecord (Ext.TableId("USR_LEAVE_REQUESTS"));
user.ReadWithWhere("TS_EMPLOYEE=${userId}");
user.GetFieldValue("TS_ACTUAL_TIME_TAKEN", timeTaken);
//Shell.Item().SetFieldValue("TEST", timeTaken);

var oldBalance =int();
var newBalance =int();
var balanceSelect = Ext.CreateAppRecord (Ext.TableId("USR_EMPLOYEE_VACTION_BALANCE"));

if(balanceSelect.ReadWithWhere("TS_EMPLOYEE=${userId}")){
balanceSelect.Lock(true);
balanceSelect.GetFieldValue("TS_BALANCE", oldBalance);
newBalance = oldBalance - timeTaken;
balanceSelect.SetFieldValue("TS_BALANCE", timeTaken);

var update = balanceSelect.Update();
balanceSelect.Unlock();

if(update) {
Ext.LogErrorMsg("Balance is changed!!!");
} else {
Ext.LogErrorMsg("Update failed!!!");
}
}
}

global u = int();
u = Shell.Item().GetFieldValue("Employee");
changeBalance(u);