.. |reembolso de pago desde el pdv| image:: resources/rs-40-0-generate-refund-from-pos.png .. _documento/versión-40-0: **rs-40-0** =========== **Fecha de Liberación:** 2022-02-07 ----------------------------------- .. data:: Soporte a Versiones: - ADempiereBase: Versión de Liberación: 3.9.3-rs-4.3 - CST-STD: Versión de Liberación: rs-31.2 - Consigned-Material: 1.2.9 - Exchange-Operation-System: 1.1.9 - Cloud-Service-Management: 1.1.3 - Cash-Management: 1.1.4 - Currency-Convert-Documents: 1.0.9 - Farmer-Assistance-Program: 1.2.5 - RethinkDB-Replicator-Client: 1.1.5 - Third-Party-Access: 1.0.5 - Fiscal-Printer: 1.4.7 - Sales-Force-Management: 1.0.6 - Delivery-Management-Service: 1.1.9 - Travel-Agency-Management: 1.0.9 - Withholding: 1.0.9 - Migration-Tools: 1.0.4 - LVE: 1.5.8 - Performance-Analysis: 1.1.1 - Queue-Manager: 1.0.6 - Notification-Queue: 1.1.6 - Point-Of-Sales-Improvements: 1.3.5 - Kafka-Replicator-Client: 1.0.9 - Kafka-Util: 1.0.2 - Core-Tools: 1.3.8 - Get-Weight:1.1.1 - Record-Weight: 1.0.5 - Raw-Material-Receipt: 1.1.4 - Additional-Reports: 1.2.3 - adempiere-customer-backend: 1.2.1 - Material-Management-Improvements: 1.1.4 - Warehouse-Management-System-Improvements: 1.1.4 - Import-Export-Management: 1.0.3 - Update-Management: 1.1.3 - Mini-Retail: 1.1.5 - Print-Queue: 1.0.8 - ERP-Payroll-Definition: 1.0.1 - Internal-Store: 1.0.4 - Telegram-Notifier: 1.0.5 - Costing-Engine-Improvements: 1.1.1 - Default-Attribute: 1.0.1 - Financial-Report: 1.0.1 - Json-Replicator-Client: 1.0.2 - Kubernetes-Cluster: 1.0.7 - ADempiere-Exporter: 1.0.5 - ADempiere-TelegramBot - e-Commerce-Queue: 1.0.6 - Vue-StoreFront-API: 1.0.4 - Mercado-Libre-Venezuela-API: 1.0.2 .. data:: Detalle Técnico: - LVE: Corrección de problema con transacciones en espera: ``` MWHWithholding.saveError: Error - ERROR: savepoint "jdbc_savepoint_2917" does not exist [77] ===========> Query.firstOnly: SELECT IsActive,Created,Updated,Value,EntityType,AD_Reference_ID,Description,ValidFrom,Name,ValidTo,AD_Ref_List_ID,AD_Org_ID,AD_Client_ID,CreatedBy,UpdatedBy,UUID FROM AD_Ref_List WHERE (AD_Reference_ID=? AND Value=?) [77] org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2497) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2233) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:446) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:370) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:149) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:108) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100) at com.sun.proxy.$Proxy49.executeQuery(Unknown Source) at org.compiere.model.Query.createResultSet(Query.java:781) at org.compiere.model.Query.firstOnly(Query.java:350) at org.compiere.model.MRefList.get(MRefList.java:62) at org.compiere.model.PO.set_Value(PO.java:874) at org.compiere.model.PO.set_Value(PO.java:755) at org.spin.model.X_WH_Withholding.setDocStatus(X_WH_Withholding.java:367) at org.compiere.process.DocumentEngine.prepareIt(DocumentEngine.java:412) at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:290) at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:258) caused by: org.postgresql.util.PSQLException: ERROR: savepoint "jdbc_savepoint_2917" does not exist; State=3B001; ErrorCode=0 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2497) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2233) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:446) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:370) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:311) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:297) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:274) at org.postgresql.jdbc.PgConnection.execSQLUpdate(PgConnection.java:440) at org.postgresql.jdbc.PgConnection.releaseSavepoint(PgConnection.java:1670) at com.mchange.v2.c3p0.impl.NewProxyConnection.releaseSavepoint(NewProxyConnection.java:1167) at org.compiere.util.Trx.releaseSavepoint(Trx.java:449) at org.compiere.model.PO.save(PO.java:2292) at org.compiere.model.PO.saveEx(PO.java:2310) at org.spin.util.AbstractWithholdingSetting.createWithholding(AbstractWithholdingSetting.java:431) at org.spin.util.AbstractWithholdingSetting.saveResult(AbstractWithholdingSetting.java:380) at org.erpya.lve.util.APInvoiceIVA.lambda$run$85(APInvoiceIVA.java:204) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.erpya.lve.util.APInvoiceIVA.run(APInvoiceIVA.java:193) at org.spin.util.WithholdingEngine.processWithholding(WithholdingEngine.java:216) at org.spin.util.WithholdingEngine.processWithholding(WithholdingEngine.java:191) ===========> Query.first: SELECT PriceLimit,PriceActual,QtyInvoiced,Created,Updated,C_ProjectPhase_ID,A_Asset_ID,IsActive,ReversalLine_ID,Description,FM_Amortization_ID,Processed,IsFixedAssetInvoice,C_ProjectTask_ID,GenerateTo,C_InvoiceLine_ID,User3_ID,User4_ID,IsPrinted,C_Project_ID,TaxAmt,LineTotalAmt,QtyEntered,User1_ID,C_Campaign_ID,C_Activity_ID,User2_ID,RRAmt,A_Processed,A_Asset_Group_ID,RRStartDate,IsDescription,A_CreateAsset,LineNetAmt,PriceEntered,A_CapvsExp,PriceList,AD_OrgTrx_ID,IsCollectiveAsset,Ref_InvoiceLine_ID,CreatedBy,C_Invoice_ID,AD_Client_ID,AD_Org_ID,Line,M_InOutLine_ID,C_Tax_ID,C_UOM_ID,C_Charge_ID,C_OrderLine_ID,M_Product_ID,S_ResourceAssignment_ID,M_RMALine_ID,M_AttributeSetInstance_ID,UpdatedBy,UUID,WM_InOutBoundLine_ID,InvoiceToAllocate_ID,DD_FreightLine_ID FROM C_InvoiceLine WHERE (C_InvoiceLine_ID = ?) [1743] org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2497) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2233) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:446) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:370) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:149) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:108) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100) at com.sun.proxy.$Proxy49.executeQuery(Unknown Source) at org.compiere.model.Query.createResultSet(Query.java:781) at org.compiere.model.Query.first(Query.java:315) at org.erpya.lve.model.LVE.modelChange(LVE.java:442) at org.compiere.model.ModelValidationEngine.lambda$null$15(ModelValidationEngine.java:376) at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382) at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482) caused by: org.postgresql.util.PSQLException: ERROR: savepoint "jdbc_savepoint_2917" does not exist; State=3B001; ErrorCode=0 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2497) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2233) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:446) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:370) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:311) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:297) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:274) at org.postgresql.jdbc.PgConnection.execSQLUpdate(PgConnection.java:440) at org.postgresql.jdbc.PgConnection.releaseSavepoint(PgConnection.java:1670) at com.mchange.v2.c3p0.impl.NewProxyConnection.releaseSavepoint(NewProxyConnection.java:1167) at org.compiere.util.Trx.releaseSavepoint(Trx.java:449) at org.compiere.model.PO.save(PO.java:2292) at org.compiere.model.PO.saveEx(PO.java:2310) at org.spin.util.AbstractWithholdingSetting.createWithholding(AbstractWithholdingSetting.java:431) at org.spin.util.AbstractWithholdingSetting.saveResult(AbstractWithholdingSetting.java:380) at org.erpya.lve.util.APInvoiceIVA.lambda$run$85(APInvoiceIVA.java:204) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.erpya.lve.util.APInvoiceIVA.run(APInvoiceIVA.java:193) at org.spin.util.WithholdingEngine.processWithholding(WithholdingEngine.java:216) at org.spin.util.WithholdingEngine.processWithholding(WithholdingEngine.java:191) ``` - Point-Of-Sales-Improvements: - Add browser "Generate Refund from (POS)" - Rename package of process from **org.spin.process** to **org.spin.pos.process** - Material-Management-Improvements: Fixed error with transit warehouse .. data:: Requerimientos: - Aplicar binario de la aplicación - Aplicar los XML's: - Point-Of-Sales-Improvements: - 09610_Rename_package_name.xml - 09620_Add_Generate_Refund_from_POS_Browser.xml - 09630_Add_columns_to_Generate_Refund_from_POS.xml .. data:: Novedades - Se agrega Visor para Generar Reembolsos desde el Punto de Ventas |reembolso de pago desde el pdv| .. data:: Correcciones - Corrección de problemas con transacciones en espera al momento de generar retenciones de cualquier tipo - Almacén incorrecto para reabastcimiento manual entre organizaciones del mismo grupo