Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0051441Localization Pack: SpainAEAT 190public2023-01-23 12:562023-01-25 09:51
Reporterpsanjuan 
Assigned Tomgonzalezh 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0051441: Error en el 190 - FIN_Payment_Detail_V.invoicePaymentPlan
DescriptionSi un cliente de la localización española, utiliza una versión posterior a 20Q2, obtendrá el error que se muestra debajo, ya que el campo

"FIN_Payment_Detail_V" de la vista invoicePaymentPlan (see image below)

se ha quitado.

Error:

java.lang.IllegalArgumentException: org.hibernate.QueryException: could not resolve property: invoicePaymentPlan of: FIN_Payment_Detail_V [ select new org.openbravo.module.aeat190.es.bean.PaymentInfoFor190(to_char(i.invoiceDate, 'YYYY'), i.id, sum(C_Currency_Convert(pdv.paidAmount, pdv.currency.id, i.currency.id, pdv.paymentDate, null, i.client.id)) ) from FIN_Payment_Detail_V pdv join pdv.invoicePaymentPlan.invoice i where i.posted='Y' and pdv.payment.status in ('PWNC', 'RPPC', 'PPM') and exists (select 1 from FinancialMgmtAccountingFact fa where i.id = fa.recordID and fa.accountingSchema.id = '07ECFE53213F49B48955C03F19CCFBC8' ) and exists (select 1 from InvoiceTax it where it.invoice.id = i.id and it.tax.id in ('4DF802123A4D4B6FA6F3CCAF44D2DC85','FA1E4A2148F54016B1CA2D1D15EE2E6B','27003118352848B5AD1A685FABC57683','CCB9F70FC9E741B0B3C8BB996A54219D','0184D0C6A0974827BC4DA167F4AC6285','9701D4BED3D1442883BD7D574E8DF790','AD69CB0C35554BDCB64E74E463B637B5','EF2061D4F5C04570B16B1F50E24BDC46','01E2D35C0C5745978B39773CF9C865E9','812FAB72D6FE4CE6A945410634685BC9','8F123583544D4542AAD1290DC8674A90','BCC57681C6AD4D1A834F96222660B50C','13D8A18F1D274C01887355FB36A6F026','3D6AD7CA8CC04052B1BB506E8F2BD0F6','FF80818123B7FC160123B804ABA00058','5D605918700944DEB0454907D71BA572','AD0284D8F869487E97029CED21C18BE2','3C233BC5CAF54A39AD3F778438A67063','DEFE5BFF895C4FBB94DDC3E8516549D0','F7E840860A9D451CABF0E6047C51C7AE','2B83D0A843474C2191984838D789FA3C','F507AC20F23045D9B6A57573CAE61B43')) and pdv.paymentDate >= :inipmntdate and pdv.paymentDate < :endpmntdate and i.accountingDate >= :iniacctdate and i.accountingDate < :endacctdate and i.organization in ('DC96B9129BCC456C975E4141519951D5') group by i.id, i.businessPartner, to_char(i.invoiceDate, 'YYYY') order by to_char(i.invoiceDate, 'YYYY') desc, i.businessPartner ]
Steps To ReproduceN/A
Proposed SolutionUsar el paymentPlanInvoice en su lugar. Ver: https://code.openbravo.com/erp/devel/pi/rev/3db254ac09aad11a29918aafd26c1ed3a19a2c10 [^]
Additional Information
TagsNo tags attached.
Relationships
blocks feature request 0050834 closed mgonzalezh New Design 190 2022  
Attached Filespng Screenshot from 2023-01-23 12-51-06.png (584,034) 2023-01-23 12:58
https://issues.openbravo.com/file_download.php?file_id=18056&type=bug
Issue History
Date ModifiedUsernameFieldChange
2023-01-23 12:56psanjuanNew Issue
2023-01-23 12:56psanjuanAssigned To => Jorge Bravo
2023-01-23 12:58psanjuanFile Added: Screenshot from 2023-01-23 12-51-06.png
2023-01-23 12:58psanjuanAssigned ToJorge Bravo => mgonzalezh
2023-01-23 12:59psanjuanProposed Solution updated
2023-01-23 15:49hgbotNote Added: 0145768
2023-01-23 16:09hgbotNote Added: 0145769
2023-01-23 16:15hgbotNote Added: 0145770
2023-01-23 17:58mgonzalezhRelationship addedblocks 0050834
2023-01-25 09:51hgbotNote Added: 0145819
2023-01-25 09:51hgbotNote Added: 0145820
2023-01-25 09:51vmromanosStatusnew => scheduled
2023-01-25 09:51vmromanosStatusscheduled => resolved
2023-01-25 09:51vmromanosResolutionopen => fixed
2023-01-25 09:51vmromanosStatusresolved => closed

Notes
(0145768)
hgbot   
2023-01-23 15:49   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat190.es/-/merge_requests/8 [^]
(0145769)
hgbot   
2023-01-23 16:09   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat190.es/-/merge_requests/8 [^]
(0145770)
hgbot   
2023-01-23 16:15   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat190.es/-/merge_requests/9 [^]
(0145819)
hgbot   
2023-01-25 09:51   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat190.es/-/merge_requests/9 [^]
(0145820)
hgbot   
2023-01-25 09:51   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat190.es [^]
Changeset: 100832026d1093d5eb601b957de7694dded110b5
Author: Maykel Gonzalez <maykel.gonzalez@smfconsulting.es>
Date: 25-01-2023 09:49:21
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat190.es/-/commit/100832026d1093d5eb601b957de7694dded110b5 [^]

Fix BUG-51441: Update deprecated field on Payment Detail View

---
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
M src/org/openbravo/module/aeat190/es/report/AEAT190ReportDao.java
---