Openbravo Issue Tracking System - Openbravo ERP
As the c_tax_id is mandatory on c_orderline table the process fails.
The problem is on SRMOPickEditLines.java class.
getString("tax") return the "null" string instead of null value when there is no tax.
// tax
String taxId = selectedLine.getString("tax");
if (taxId == null) {
...
}
a3196480 347536 [TP-Processor7] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into C_OrderLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Order_ID, Line, DateOrdered, M_Product_ID, M_Warehouse_ID, DirectShip, C_UOM_ID, QtyOrdered, C_Currency_ID, PriceList, PriceActual, PriceLimit, Discount, ChargeAmt, IsDescription, PriceStd, CANCELPRICEAD, Iseditlinenetamt, M_Inoutline_ID, C_OrderLine_ID) values ('23C59575B9CF467C9620760EB255B389', 'E443A31992CB4635AFCAEABE7183CE85', 'Y', '2012-06-05 15:51:58.489000 +02:00:00', '100', '2012-06-05 15:51:58.489000 +02:00:00', '100', '84CF302B46DE43A28E4D5ED6E75E639F', '10', '2012-06-05 00:00:00.000000 +02:00:00', 'BDE2F1CF46B54EF58D33E20A230DA8D2', 'B2D40D8A5D644DD89E329DC297309055', 'N', '100', '-3', '102', '1.53', '1.53', '0', '0', '0', 'N', '1.53', 'N', 'N', '7CDC29AA7ADE4AB58B66D1C87A826574', 'DCDA26867C6E4F92AF11E9880498458C') was aborted. Call getNextException to see the cause.
a3196480 347567 [TP-Processor7] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: null value in column "c_tax_id" violates not-null constraint
a3196480 347570 [TP-Processor7] ERROR org.openbravo.common.actionhandler.SRMOPickEditLines - Could not execute JDBC batch update
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
2) Create a new Return for Customer for Hoteles Buenas Noches, S.A.
3) Click on Pick/Edit
4) Select goods shipment created on step 1)
5) Fully return the shipment.
6) Click on Done button
7) Error:
Could not execute JDBC batch update
Realize that the line is not inserted.
// tax
String taxId = selectedLine.getString("tax");
if (taxId == null) {
...
}
to
if ("null".equals(taxId)) {
Return_from_customer_Tax_null.png (70,378) 2012-06-05 15:58https://issues.openbravo.com/file_download.php?file_id=5279&type=bug