UPDATE #Request.prefix_db_agency#.Payments SET Payment_Lock = 10 ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Payment_ID = #form.Payment_ID# AND Invoice_ID IN (SELECT Invoice_ID FROM #Request.prefix_db_agency#.Invoices WHERE Agency_ID = '#session.AgencyId#' AND Deleted <> 1) UPDATE #Request.prefix_db_agency#.Payments SET Amount = #NumberFormat(form.Paid,'_____.__')#, writeoffamount = #NumberFormat(form.WriteOff,'_____.__')#, PaymentDate = #CreateODBCDateTime(form.Date)# ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Payment_ID = #form.Payment_ID# AND (IFNULL(Payment_Lock,0) <> 1) UPDATE #Request.prefix_db_agency#.Invoices SET invoiceTotal = #NumberFormat(form.InvoiceTotal,'_____.__')# ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# WHERE Invoice_ID = #form.Invoice_ID# #form.Date#