Index: ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql =================================================================== diff -u -r37570 -r37571 --- ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql (.../5.0.20_5.0.21.sql) (revision 37570) +++ ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql (.../5.0.20_5.0.21.sql) (revision 37571) @@ -19,7 +19,7 @@ update InvoiceItem set settlementPrice=( select sum(price) from TousseInstance ti where ti.invoice_id=InvoiceItem.invoice_id and ti.tousseDefinition_id=InvoiceItem.tousseDefinitionId and ti.comboTousseInstanceId is not null ), settlementDiscountPrice =( -select sum(settlementDiscountPrice ) from TousseInstance ti where ti.invoice_id=InvoiceItem.invoice_id and ti.tousseDefinition_id=InvoiceItem.tousseDefinitionId and ti.comboTousseInstanceId is not null +select sum(discountPrice) from TousseInstance ti where ti.invoice_id=InvoiceItem.invoice_id and ti.tousseDefinition_id=InvoiceItem.tousseDefinitionId and ti.comboTousseInstanceId is not null ) where settlementPrice<>( select sum(price) from TousseInstance ti where ti.invoice_id=InvoiceItem.invoice_id and ti.tousseDefinition_id=InvoiceItem.tousseDefinitionId and ti.comboTousseInstanceId is not null