/** Update Remesa */
private boolean updateRemesa() {
// Update Remesa
String sql =
"UPDATE C_Remesa "
+ " SET TotalAmt="
+ " (SELECT COALESCE(SUM(rl.LineNetAmt),0) FROM C_RemesaLine rl GROUP BY rl.C_Remesa_ID HAVING rl.C_Remesa_ID="
+ getC_Remesa_ID()
+ ")"
// + " FROM C_Remesa rm"
+ " WHERE C_Remesa_ID="
+ getC_Remesa_ID();
int no = DB.executeUpdate(sql);
return no == 1;
} // updateHeaderTax
/**
* Set Processed. Propergate to Lines/Taxes
*
* @param processed processed
*/
public void setProcessed(boolean processed) {
if (getID() == 0) return;
String set = "SET C_Remesa_ID='" + getC_Remesa_ID() + "' WHERE ";
log.fine("En MRemesa la sql q ejecuta es: UPDATE C_InvoicePaySchedule" + set);
int noLine = DB.executeUpdate("UPDATE C_InvoicePaySchedule " + set, get_TrxName());
} // setProcessed
