0037074: [RR17Q4] Layaway can't be retrieved after laid away twice

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #37074		[ All Revisions ] [ Back to Issue ]
Summary	0037074: [RR17Q4] Layaway can't be retrieved after laid away twice

Revision	2017-10-16 14:04 by inaki_garcia
Description	A Layaway ticket can't be opened after being laid away twice. This is, by creating a Receipt, making it Layaway and laying it away, opening it from the dropdown menu option, laying it away again, and then trying to reopen it. An error is shown saying that the layaway hasn't been completely synced in the backoffice, as depicted in the attached picture. The error collected in the "Errors While Importing POS Data" record in the backoffice are as follows: --- JSON order Data: {"hasbeenpaid":"Y","isbeingprocessed":"N","id":"72C6F06590A84578AACDFB1CD165EA5B","client":"39363B0921BB4293B48383844325E84C","organization":"3B187EC130A549A7A9388F8060EF156D","createdBy":"1D0E5A14E65D474FA8EC8311E009E253","updatedBy":null,"documentType":"044E078A49CB4B1192B849462ACB4624","orderType":0,"generateInvoice":false,"isQuotation":false,"oldId":null,"priceList":"496CF965DF9744D2A41248392D1DE407","priceIncludesTax":true,"currency":"102","currency$_identifier":"EUR","session":"B35F1E86AE4CCFC464EED494A7C0B770","warehouse":"5A61F38D57F147A3A28E4C606B66DC47","salesRepresentative":"1D0E5A14E65D474FA8EC8311E009E253","salesRepresentative$_identifier":"Central Mountains Store User","posTerminal":"5F413EBD3A6042C28708821D43C91D0B","posTerminal$_identifier":"CMS POS Terminal","orderDate":"2017-10-16T11:22:58.343Z","creationDate":"2017-10-16T11:22:51.348Z","documentnoPrefix":-1,"quotationnoPrefix":-1,"returnnoPrefix":-1,"documentnoSuffix":-1,"quotationnoSuffix":-1,"returnnoSuffix":-1,"documentNo":"CMS1\/0000013","bp":{"id":"9C211C965971481CA91FC948CBC83076","organization":"3B187EC130A549A7A9388F8060EF156D","searchKey":"CMS\/C0001","_identifier":"CMS Customer","name":"CMS Customer","firstName":"CMS Customer","lastName":null,"description":null,"taxID":null,"taxCategory":null,"paymentMethod":"45A202BF44884F05B8A1BF741E2063B6","paymentTerms":"D8955F8808A54C63BBF478A6843D834D","priceList":"496CF965DF9744D2A41248392D1DE407","invoiceTerms":"I","contactId":"6F8FF918D75F4A9A81AFBD41FE4C8FE2","phone":null,"email":null,"businessPartnerCategory":"B1DD8B371643421C987EF1D5B358D5E9","businessPartnerCategory_name":"Customer","creditLimit":0,"creditUsed":0,"taxExempt":false,"customerBlocking":false,"salesOrderBlocking":true,"priceIncludesTax":true,"priceListName":"The White Valley Group Sale Price List","loaded":"2017-10-16T11:22:21+00:00","birthDay":null,"birthPlace":null,"_filter":"CMS\/C0001###CMS Customer###","_idx":2,"shipLocName":"Alcala 123 2-1","shipLocId":"A25BDF8D987C4280858F71409DC09AA8","shipPostalCode":"38010","shipCityName":"Santa Cruz de Tenerife","shipCountryName":"Spain","shipCountryId":"106","shipRegionId":"6C67D807692046F6A2F59CA37131F1B5","locName":"Alcala 123 2-1","locId":"A25BDF8D987C4280858F71409DC09AA8","postalCode":"38010","cityName":"Santa Cruz de Tenerife","countryName":"Spain","locationModel":{"id":"A25BDF8D987C4280858F71409DC09AA8","bpartner":"9C211C965971481CA91FC948CBC83076","name":"Alcala 123 2-1","postalCode":"38010","cityName":"Santa Cruz de Tenerife","countryName":"Spain","countryId":"106","regionName":"SANTA CRUZ DE TENERIFE ","regionId":"6C67D807692046F6A2F59CA37131F1B5","isBillTo":true,"isShipTo":true,"_identifier":"Alcala 123 2-1","loaded":"2017-10-16T11:22:22+00:00","_filter":"Alcala 123 2-1###","_idx":0}},"lines":[{"product":{"originalStandardPrice":18.9,"id":"9F9BC6229E5C48D38F935D7FD5F5BA94","searchkey":"WVG\/L0001","uPCEAN":null,"uOM":"100","uOMsymbol":"Ud ","uOMstandardPrecision":0,"productCategory":"9BE78BE519494875B84A004EFD4B5ADC","taxCategory":"FF80818123B7FC160123B804AB88000B","imgId":"3D3D41EDE96D4BDEB89E0484BA77526F","description":"Ultralight LED headlamp.","obposScale":false,"groupProduct":true,"stocked":true,"showstock":false,"isGeneric":false,"generic_product_id":null,"brand":"121308E73E684428BF4E65B40629F0EF","characteristicDescription":"Object: Headlamps, Price: < 20€, Range: 29m max, Weight: Under 1Kg, Battery Life: 120h max, Use: Hiking & Trekking","showchdesc":true,"bestseller":true,"ispack":false,"listPrice":18.9,"standardPrice":18.9,"priceLimit":18.9,"cost":0,"algorithm":"S","_identifier":"Headlamp ultralight","currentStandardPrice":"undefined","productType":"I","includeProductCategories":null,"includeProducts":null,"printDescription":false,"oBPOSAllowAnonymousSale":true,"returnable":true,"overdueReturnDays":null,"isPriceRuleBased":false,"proposalType":null,"availableForMultiline":false,"isLinkedToProduct":false,"allowDeferredSell":false,"deferredSellMaxDays":null,"quantityRule":null,"isPrintServices":true,"hasAttributes":false,"isSerialNo":false,"_idx":75},"productidentifier":null,"uOM":"100","qty":1,"price":18.9,"priceList":18.9,"gross":18.9,"net":18.9,"description":"","id":"7CB72D3F2A6C50EFD4B24AC6C64ADBED","promotions":[],"priceIncludesTax":true,"hasRelatedServices":false,"warehouse":{"id":"5A61F38D57F147A3A28E4C606B66DC47","warehousename":"Central Mountains Store Warehouse"},"isEditable":true,"isDeletable":true,"grossListPrice":18.9,"productType":"I","discountPercentage":0,"pricePrecision":2,"remainingQuantity":0,"orderId":"72C6F06590A84578AACDFB1CD165EA5B","grossUnitPrice":18.9,"overdueReturnDays":999999999999,"deliveredQuantity":0,"returnable":true,"taxes":[{"taxId":"6A87420C02554D82B83595A74B73B4CB","identifier":"Entregas a Canarias,Ceuta y Melilla (%N=>0%)","taxAmount":0,"taxableAmount":18.9,"taxRate":0,"docTaxAmount":"D","lineNo":10,"cascade":false}],"linepos":0,"taxLines":{"6A87420C02554D82B83595A74B73B4CB":{"amount":0,"name":"Entregas a Canarias,Ceuta y Melilla (%N=>0%)","net":18.9,"rate":0}},"tax":"6A87420C02554D82B83595A74B73B4CB","taxAmount":0,"pricenet":18.9,"discountedNet":18.9,"linerate":1,"listPrice":0,"standardPrice":0,"lineGrossAmount":18.9}],"payments":[],"payment":0,"change":0,"qty":1,"gross":18.9,"net":18.9,"taxes":{"6A87420C02554D82B83595A74B73B4CB":{"amount":0,"cascade":false,"docTaxAmount":"D","lineNo":10,"name":"Entregas a Canarias,Ceuta y Melilla (%N=>0%)","net":18.9,"rate":0}},"description":"","print":true,"sendEmail":false,"isPaid":false,"creditAmount":0,"paidPartiallyOnCredit":false,"paidOnCredit":false,"isLayaway":true,"isEditable":false,"openDrawer":false,"totalamount":18.9,"approvals":[],"isPartiallyDelivered":false,"isNewReceipt":false,"cloningReceipt":false,"bpBillLocId":"A25BDF8D987C4280858F71409DC09AA8","iscancelled":false,"totalNetAmount":18.9,"bpLocId":"A25BDF8D987C4280858F71409DC09AA8","businessPartner$_identifier":"CMS Customer","orderid":"72C6F06590A84578AACDFB1CD165EA5B","loaded":"2017-10-16T11:22:56.643Z","receiptLines":[{"linegrossamount":18.9,"unitPrice":18.9,"warehouse":"5A61F38D57F147A3A28E4C606B66DC47","productType":"I","id":"9F9BC6229E5C48D38F935D7FD5F5BA94","description":"","name":"Headlamp ultralight","discountPercentage":0,"pricePrecision":2,"remainingQuantity":0,"quantity":1,"uOM":"100","orderId":"72C6F06590A84578AACDFB1CD165EA5B","lineId":"7CB72D3F2A6C50EFD4B24AC6C64ADBED","warehousename":"Central Mountains Store Warehouse","grossUnitPrice":18.9,"overdueReturnDays":999999999999,"baseNetUnitPrice":0,"deliveredQuantity":0,"returnable":true,"priceIncludesTax":true,"shipmentlines":[],"taxes":[{"taxId":"6A87420C02554D82B83595A74B73B4CB","identifier":"Entregas a Canarias,Ceuta y Melilla (%N=>0%)","taxAmount":0,"taxableAmount":18.9,"taxRate":0,"docTaxAmount":"D","lineNo":10,"cascade":false}],"promotions":[],"linepos":0}],"receiptPayments":[],"receiptTaxes":[{"taxid":"6A87420C02554D82B83595A74B73B4CB","rate":0,"net":18.9,"amount":0,"name":"Entregas a Canarias,Ceuta y Melilla (%N=>0%)","gross":18.9,"cascade":false,"docTaxAmount":"D","lineNo":10}],"approvedList":[],"recordInImportEntry":false,"skipApplyPromotions":true,"calculateReceiptCallbacks":[],"isBeingDiscounted":false,"reApplyDiscounts":false,"timezoneOffset":-120,"selectedPayment":"OBPOS_payment.cash","isBeingClosed":false,"created":1508152971348,"obposCreatedabsolute":"2017-10-16 13:22:51.348","movementDate":"2017-10-16T11:22:58.344Z","accountingDate":"2017-10-16T11:22:58.345Z","multipleUndo":null,"paymentMethodKind":null,"obposAppCashup":"FF06117E02CC7BD349D60DC4B842EE98","cashUpReportInformation":{"id":"FF06117E02CC7BD349D60DC4B842EE98","netSales":363.5,"grossSales":363.5,"netReturns":0,"grossReturns":0,"totalRetailTransactions":363.5,"creationDate":"2017-10-16T11:14Z","userId":"1D0E5A14E65D474FA8EC8311E009E253","objToSend":"{\"posterminal\":\"5F413EBD3A6042C28708821D43C91D0B\",\"posTerminal\":\"5F413EBD3A6042C28708821D43C91D0B\",\"id\":\"FF06117E02CC7BD349D60DC4B842EE98\",\"isprocessed\":\"N\",\"isbeingprocessed\":\"Y\",\"netSales\":363.5,\"grossSales\":363.5,\"netReturns\":0,\"grossReturns\":0,\"totalRetailTransactions\":363.5,\"cashPaymentMethodInfo\":[{\"paymentMethodId\":\"43F694DEE8484EB1A809199B61F26CA8\",\"id\":\"1B104755C1039FA9A4C32AAA3D43ECC6\",\"searchKey\":\"OBPOS_payment.card\",\"startingCash\":0,\"totalSales\":0,\"totalReturns\":0,\"rate\":\"1\",\"isocode\":\"EUR\",\"totalDeposits\":0,\"totalDrops\":0,\"paymentmethod_id\":\"43F694DEE8484EB1A809199B61F26CA8\"},{\"paymentMethodId\":\"AA4E033486E842E8B67DED8549C47A47\",\"id\":\"45FCFE590D66DA512E636AB92185B120\",\"searchKey\":\"OBPOS_payment.cash\",\"startingCash\":0,\"totalSales\":325.7,\"totalReturns\":0,\"rate\":\"1\",\"isocode\":\"EUR\",\"totalDeposits\":0,\"totalDrops\":0,\"paymentmethod_id\":\"AA4E033486E842E8B67DED8549C47A47\"},{\"paymentMethodId\":\"5EDB23AEA96845309D8072DFE0740E32\",\"id\":\"8C4DE0D87FB47B65BAF3245023ED3F83\",\"searchKey\":\"OBPOS_payment.voucher\",\"startingCash\":0,\"totalSales\":0,\"totalReturns\":0,\"rate\":\"1\",\"isocode\":\"EUR\",\"totalDeposits\":0,\"totalDrops\":0,\"paymentmethod_id\":\"5EDB23AEA96845309D8072DFE0740E32\"}],\"cashTaxInfo\":[{\"name\":\"Entregas a Canarias,Ceuta y Melilla (%N=>0%)\",\"amount\":0,\"orderType\":\"0\",\"cashupId\":\"FF06117E02CC7BD349D60DC4B842EE98\",\"id\":\"0CC0BDCA1A0273A6494B3CA5B0E0D2D3\"}],\"cashCloseInfo\":[],\"cashUpDate\":\"\",\"creationDate\":\"2017-10-16T11:14:00.000Z\",\"lastcashupeportdate\":\"2017-10-16T11:22:58.512Z\",\"userId\":\"1D0E5A14E65D474FA8EC8311E009E253\",\"organization\":\"3B187EC130A549A7A9388F8060EF156D\"}","isbeingprocessed":"Y","isprocessed":"N","posterminal":"5F413EBD3A6042C28708821D43C91D0B","_idx":null,"lastcashupeportdate":"2017-10-16T11:22:58.512Z"}} ----------------------------------------------------------------------- -- Error message: org.postgresql.util.PSQLException: ERROR: null value in column "em_obawo_pending_qty_picking" violates not-null constraint Detail: Failing row contains (7CB72D3F2A6C50EFD4B24AC6C64ADBED, 39363B0921BB4293B48383844325E84C, 3B187EC130A549A7A9388F8060EF156D, Y, 2017-10-16 11:22:51, 1D0E5A14E65D474FA8EC8311E009E253, 2017-10-16 11:22:59.943, 1D0E5A14E65D474FA8EC8311E009E253, 72C6F06590A84578AACDFB1CD165EA5B, 10, 9C211C965971481CA91FC948CBC83076, null, 2017-10-16 00:00:00, null, null, null, , 9F9BC6229E5C48D38F935D7FD5F5BA94, 5A61F38D57F147A3A28E4C606B66DC47, N, 100, 1, 0, 0, 0, null, 102, 0, 18.9, 0, 18.90, 0, 0, null, 0, 6A87420C02554D82B83595A74B73B4CB, null, null, null, N, null, null, null, 0, N, null, N, null, null, null, 18.9, 18.9, 18.9, null, 18.9, null, null, null, null, null, null, null, null, N, N, N, null, N, null, N, null, null, null, null, null, N, N, null, null). at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:2534) at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:138) at com.sun.proxy.$Proxy24.executeBatch(Unknown Source) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) at org.openbravo.dal.service.OBDal.flush(OBDal.java:260) at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:563) at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:200) at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:154) at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:86) at org.openbravo.mobile.core.process.MobileImportEntryProcessorRunnable.processEntry(MobileImportEntryProcessorRunnable.java:53) at org.openbravo.retail.posterminal.importprocess.OrderImportEntryProcessor$OrderLoaderRunnable.processEntry(OrderImportEntryProcessor.java:59) at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.doRunCycle(ImportEntryProcessor.java:363) at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.run(ImportEntryProcessor.java:285) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748)

Revision	2017-10-16 14:01 by inaki_garcia
Description	A Layaway ticket can't be opened after being laid away twice. This is, by creating a Receipt, making it Layaway and laying it away, opening it from the dropdown menu option, laying it away again, and then trying to reopen it. And error is shown saying that the layaway hasn't been completely synced in the backoffice, as shown in the attached picture. The error collected in the "Errors While Importing POS Data" record in the backoffice are as follows: --- JSON order Data: {"hasbeenpaid":"Y","isbeingprocessed":"N","id":"72C6F06590A84578AACDFB1CD165EA5B","client":"39363B0921BB4293B48383844325E84C","organization":"3B187EC130A549A7A9388F8060EF156D","createdBy":"1D0E5A14E65D474FA8EC8311E009E253","updatedBy":null,"documentType":"044E078A49CB4B1192B849462ACB4624","orderType":0,"generateInvoice":false,"isQuotation":false,"oldId":null,"priceList":"496CF965DF9744D2A41248392D1DE407","priceIncludesTax":true,"currency":"102","currency$_identifier":"EUR","session":"B35F1E86AE4CCFC464EED494A7C0B770","warehouse":"5A61F38D57F147A3A28E4C606B66DC47","salesRepresentative":"1D0E5A14E65D474FA8EC8311E009E253","salesRepresentative$_identifier":"Central Mountains Store User","posTerminal":"5F413EBD3A6042C28708821D43C91D0B","posTerminal$_identifier":"CMS POS Terminal","orderDate":"2017-10-16T11:22:58.343Z","creationDate":"2017-10-16T11:22:51.348Z","documentnoPrefix":-1,"quotationnoPrefix":-1,"returnnoPrefix":-1,"documentnoSuffix":-1,"quotationnoSuffix":-1,"returnnoSuffix":-1,"documentNo":"CMS1\/0000013","bp":{"id":"9C211C965971481CA91FC948CBC83076","organization":"3B187EC130A549A7A9388F8060EF156D","searchKey":"CMS\/C0001","_identifier":"CMS Customer","name":"CMS Customer","firstName":"CMS Customer","lastName":null,"description":null,"taxID":null,"taxCategory":null,"paymentMethod":"45A202BF44884F05B8A1BF741E2063B6","paymentTerms":"D8955F8808A54C63BBF478A6843D834D","priceList":"496CF965DF9744D2A41248392D1DE407","invoiceTerms":"I","contactId":"6F8FF918D75F4A9A81AFBD41FE4C8FE2","phone":null,"email":null,"businessPartnerCategory":"B1DD8B371643421C987EF1D5B358D5E9","businessPartnerCategory_name":"Customer","creditLimit":0,"creditUsed":0,"taxExempt":false,"customerBlocking":false,"salesOrderBlocking":true,"priceIncludesTax":true,"priceListName":"The White Valley Group Sale Price List","loaded":"2017-10-16T11:22:21+00:00","birthDay":null,"birthPlace":null,"_filter":"CMS\/C0001###CMS Customer###","_idx":2,"shipLocName":"Alcala 123 2-1","shipLocId":"A25BDF8D987C4280858F71409DC09AA8","shipPostalCode":"38010","shipCityName":"Santa Cruz de Tenerife","shipCountryName":"Spain","shipCountryId":"106","shipRegionId":"6C67D807692046F6A2F59CA37131F1B5","locName":"Alcala 123 2-1","locId":"A25BDF8D987C4280858F71409DC09AA8","postalCode":"38010","cityName":"Santa Cruz de Tenerife","countryName":"Spain","locationModel":{"id":"A25BDF8D987C4280858F71409DC09AA8","bpartner":"9C211C965971481CA91FC948CBC83076","name":"Alcala 123 2-1","postalCode":"38010","cityName":"Santa Cruz de Tenerife","countryName":"Spain","countryId":"106","regionName":"SANTA CRUZ DE TENERIFE ","regionId":"6C67D807692046F6A2F59CA37131F1B5","isBillTo":true,"isShipTo":true,"_identifier":"Alcala 123 2-1","loaded":"2017-10-16T11:22:22+00:00","_filter":"Alcala 123 2-1###","_idx":0}},"lines":[{"product":{"originalStandardPrice":18.9,"id":"9F9BC6229E5C48D38F935D7FD5F5BA94","searchkey":"WVG\/L0001","uPCEAN":null,"uOM":"100","uOMsymbol":"Ud ","uOMstandardPrecision":0,"productCategory":"9BE78BE519494875B84A004EFD4B5ADC","taxCategory":"FF80818123B7FC160123B804AB88000B","imgId":"3D3D41EDE96D4BDEB89E0484BA77526F","description":"Ultralight LED headlamp.","obposScale":false,"groupProduct":true,"stocked":true,"showstock":false,"isGeneric":false,"generic_product_id":null,"brand":"121308E73E684428BF4E65B40629F0EF","characteristicDescription":"Object: Headlamps, Price: < 20€, Range: 29m max, Weight: Under 1Kg, Battery Life: 120h max, Use: Hiking & Trekking","showchdesc":true,"bestseller":true,"ispack":false,"listPrice":18.9,"standardPrice":18.9,"priceLimit":18.9,"cost":0,"algorithm":"S","_identifier":"Headlamp ultralight","currentStandardPrice":"undefined","productType":"I","includeProductCategories":null,"includeProducts":null,"printDescription":false,"oBPOSAllowAnonymousSale":true,"returnable":true,"overdueReturnDays":null,"isPriceRuleBased":false,"proposalType":null,"availableForMultiline":false,"isLinkedToProduct":false,"allowDeferredSell":false,"deferredSellMaxDays":null,"quantityRule":null,"isPrintServices":true,"hasAttributes":false,"isSerialNo":false,"_idx":75},"productidentifier":null,"uOM":"100","qty":1,"price":18.9,"priceList":18.9,"gross":18.9,"net":18.9,"description":"","id":"7CB72D3F2A6C50EFD4B24AC6C64ADBED","promotions":[],"priceIncludesTax":true,"hasRelatedServices":false,"warehouse":{"id":"5A61F38D57F147A3A28E4C606B66DC47","warehousename":"Central Mountains Store Warehouse"},"isEditable":true,"isDeletable":true,"grossListPrice":18.9,"productType":"I","discountPercentage":0,"pricePrecision":2,"remainingQuantity":0,"orderId":"72C6F06590A84578AACDFB1CD165EA5B","grossUnitPrice":18.9,"overdueReturnDays":999999999999,"deliveredQuantity":0,"returnable":true,"taxes":[{"taxId":"6A87420C02554D82B83595A74B73B4CB","identifier":"Entregas a Canarias,Ceuta y Melilla (%N=>0%)","taxAmount":0,"taxableAmount":18.9,"taxRate":0,"docTaxAmount":"D","lineNo":10,"cascade":false}],"linepos":0,"taxLines":{"6A87420C02554D82B83595A74B73B4CB":{"amount":0,"name":"Entregas a Canarias,Ceuta y Melilla (%N=>0%)","net":18.9,"rate":0}},"tax":"6A87420C02554D82B83595A74B73B4CB","taxAmount":0,"pricenet":18.9,"discountedNet":18.9,"linerate":1,"listPrice":0,"standardPrice":0,"lineGrossAmount":18.9}],"payments":[],"payment":0,"change":0,"qty":1,"gross":18.9,"net":18.9,"taxes":{"6A87420C02554D82B83595A74B73B4CB":{"amount":0,"cascade":false,"docTaxAmount":"D","lineNo":10,"name":"Entregas a Canarias,Ceuta y Melilla (%N=>0%)","net":18.9,"rate":0}},"description":"","print":true,"sendEmail":false,"isPaid":false,"creditAmount":0,"paidPartiallyOnCredit":false,"paidOnCredit":false,"isLayaway":true,"isEditable":false,"openDrawer":false,"totalamount":18.9,"approvals":[],"isPartiallyDelivered":false,"isNewReceipt":false,"cloningReceipt":false,"bpBillLocId":"A25BDF8D987C4280858F71409DC09AA8","iscancelled":false,"totalNetAmount":18.9,"bpLocId":"A25BDF8D987C4280858F71409DC09AA8","businessPartner$_identifier":"CMS Customer","orderid":"72C6F06590A84578AACDFB1CD165EA5B","loaded":"2017-10-16T11:22:56.643Z","receiptLines":[{"linegrossamount":18.9,"unitPrice":18.9,"warehouse":"5A61F38D57F147A3A28E4C606B66DC47","productType":"I","id":"9F9BC6229E5C48D38F935D7FD5F5BA94","description":"","name":"Headlamp ultralight","discountPercentage":0,"pricePrecision":2,"remainingQuantity":0,"quantity":1,"uOM":"100","orderId":"72C6F06590A84578AACDFB1CD165EA5B","lineId":"7CB72D3F2A6C50EFD4B24AC6C64ADBED","warehousename":"Central Mountains Store Warehouse","grossUnitPrice":18.9,"overdueReturnDays":999999999999,"baseNetUnitPrice":0,"deliveredQuantity":0,"returnable":true,"priceIncludesTax":true,"shipmentlines":[],"taxes":[{"taxId":"6A87420C02554D82B83595A74B73B4CB","identifier":"Entregas a Canarias,Ceuta y Melilla (%N=>0%)","taxAmount":0,"taxableAmount":18.9,"taxRate":0,"docTaxAmount":"D","lineNo":10,"cascade":false}],"promotions":[],"linepos":0}],"receiptPayments":[],"receiptTaxes":[{"taxid":"6A87420C02554D82B83595A74B73B4CB","rate":0,"net":18.9,"amount":0,"name":"Entregas a Canarias,Ceuta y Melilla (%N=>0%)","gross":18.9,"cascade":false,"docTaxAmount":"D","lineNo":10}],"approvedList":[],"recordInImportEntry":false,"skipApplyPromotions":true,"calculateReceiptCallbacks":[],"isBeingDiscounted":false,"reApplyDiscounts":false,"timezoneOffset":-120,"selectedPayment":"OBPOS_payment.cash","isBeingClosed":false,"created":1508152971348,"obposCreatedabsolute":"2017-10-16 13:22:51.348","movementDate":"2017-10-16T11:22:58.344Z","accountingDate":"2017-10-16T11:22:58.345Z","multipleUndo":null,"paymentMethodKind":null,"obposAppCashup":"FF06117E02CC7BD349D60DC4B842EE98","cashUpReportInformation":{"id":"FF06117E02CC7BD349D60DC4B842EE98","netSales":363.5,"grossSales":363.5,"netReturns":0,"grossReturns":0,"totalRetailTransactions":363.5,"creationDate":"2017-10-16T11:14Z","userId":"1D0E5A14E65D474FA8EC8311E009E253","objToSend":"{\"posterminal\":\"5F413EBD3A6042C28708821D43C91D0B\",\"posTerminal\":\"5F413EBD3A6042C28708821D43C91D0B\",\"id\":\"FF06117E02CC7BD349D60DC4B842EE98\",\"isprocessed\":\"N\",\"isbeingprocessed\":\"Y\",\"netSales\":363.5,\"grossSales\":363.5,\"netReturns\":0,\"grossReturns\":0,\"totalRetailTransactions\":363.5,\"cashPaymentMethodInfo\":[{\"paymentMethodId\":\"43F694DEE8484EB1A809199B61F26CA8\",\"id\":\"1B104755C1039FA9A4C32AAA3D43ECC6\",\"searchKey\":\"OBPOS_payment.card\",\"startingCash\":0,\"totalSales\":0,\"totalReturns\":0,\"rate\":\"1\",\"isocode\":\"EUR\",\"totalDeposits\":0,\"totalDrops\":0,\"paymentmethod_id\":\"43F694DEE8484EB1A809199B61F26CA8\"},{\"paymentMethodId\":\"AA4E033486E842E8B67DED8549C47A47\",\"id\":\"45FCFE590D66DA512E636AB92185B120\",\"searchKey\":\"OBPOS_payment.cash\",\"startingCash\":0,\"totalSales\":325.7,\"totalReturns\":0,\"rate\":\"1\",\"isocode\":\"EUR\",\"totalDeposits\":0,\"totalDrops\":0,\"paymentmethod_id\":\"AA4E033486E842E8B67DED8549C47A47\"},{\"paymentMethodId\":\"5EDB23AEA96845309D8072DFE0740E32\",\"id\":\"8C4DE0D87FB47B65BAF3245023ED3F83\",\"searchKey\":\"OBPOS_payment.voucher\",\"startingCash\":0,\"totalSales\":0,\"totalReturns\":0,\"rate\":\"1\",\"isocode\":\"EUR\",\"totalDeposits\":0,\"totalDrops\":0,\"paymentmethod_id\":\"5EDB23AEA96845309D8072DFE0740E32\"}],\"cashTaxInfo\":[{\"name\":\"Entregas a Canarias,Ceuta y Melilla (%N=>0%)\",\"amount\":0,\"orderType\":\"0\",\"cashupId\":\"FF06117E02CC7BD349D60DC4B842EE98\",\"id\":\"0CC0BDCA1A0273A6494B3CA5B0E0D2D3\"}],\"cashCloseInfo\":[],\"cashUpDate\":\"\",\"creationDate\":\"2017-10-16T11:14:00.000Z\",\"lastcashupeportdate\":\"2017-10-16T11:22:58.512Z\",\"userId\":\"1D0E5A14E65D474FA8EC8311E009E253\",\"organization\":\"3B187EC130A549A7A9388F8060EF156D\"}","isbeingprocessed":"Y","isprocessed":"N","posterminal":"5F413EBD3A6042C28708821D43C91D0B","_idx":null,"lastcashupeportdate":"2017-10-16T11:22:58.512Z"}} ----------------------------------------------------------------------- -- Error message: org.postgresql.util.PSQLException: ERROR: null value in column "em_obawo_pending_qty_picking" violates not-null constraint Detail: Failing row contains (7CB72D3F2A6C50EFD4B24AC6C64ADBED, 39363B0921BB4293B48383844325E84C, 3B187EC130A549A7A9388F8060EF156D, Y, 2017-10-16 11:22:51, 1D0E5A14E65D474FA8EC8311E009E253, 2017-10-16 11:22:59.943, 1D0E5A14E65D474FA8EC8311E009E253, 72C6F06590A84578AACDFB1CD165EA5B, 10, 9C211C965971481CA91FC948CBC83076, null, 2017-10-16 00:00:00, null, null, null, , 9F9BC6229E5C48D38F935D7FD5F5BA94, 5A61F38D57F147A3A28E4C606B66DC47, N, 100, 1, 0, 0, 0, null, 102, 0, 18.9, 0, 18.90, 0, 0, null, 0, 6A87420C02554D82B83595A74B73B4CB, null, null, null, N, null, null, null, 0, N, null, N, null, null, null, 18.9, 18.9, 18.9, null, 18.9, null, null, null, null, null, null, null, null, N, N, N, null, N, null, N, null, null, null, null, null, N, N, null, null). at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:2534) at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:138) at com.sun.proxy.$Proxy24.executeBatch(Unknown Source) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) at org.openbravo.dal.service.OBDal.flush(OBDal.java:260) at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:563) at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:200) at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:154) at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:86) at org.openbravo.mobile.core.process.MobileImportEntryProcessorRunnable.processEntry(MobileImportEntryProcessorRunnable.java:53) at org.openbravo.retail.posterminal.importprocess.OrderImportEntryProcessor$OrderLoaderRunnable.processEntry(OrderImportEntryProcessor.java:59) at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.doRunCycle(ImportEntryProcessor.java:363) at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.run(ImportEntryProcessor.java:285) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) at java.lang.Thread.run(Thread.java:748)