Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0051441
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Localization Pack: Spain] AEAT 190majoralways2023-01-23 12:562023-01-25 09:51
ReporterpsanjuanView Statuspublic 
Assigned Tomgonzalezh 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version7.x
OS VersionOpenbravo Appliance 14.04Database version9.3.xAnt version1.9.x
Product VersionSCM revision 
Merge Request Statusapproved
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary

0051441: 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 [^]
TagsNo tags attached.
Attached Filespng file icon Screenshot from 2023-01-23 12-51-06.png [^] (584,034 bytes) 2023-01-23 12:58

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks feature request 0050834 closedmgonzalezh New Design 190 2022  

-  Notes
(0145768)
hgbot (developer)
2023-01-23 15:49

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat190.es/-/merge_requests/8 [^]
(0145769)
hgbot (developer)
2023-01-23 16:09

 Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat190.es/-/merge_requests/8 [^]
(0145770)
hgbot (developer)
2023-01-23 16:15

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat190.es/-/merge_requests/9 [^]
(0145819)
hgbot (developer)
2023-01-25 09:51

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat190.es/-/merge_requests/9 [^]
(0145820)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2023-01-23 12:56 psanjuan New Issue
2023-01-23 12:56 psanjuan Assigned To => Jorge Bravo
2023-01-23 12:56 psanjuan OBNetwork customer => No
2023-01-23 12:58 psanjuan File Added: Screenshot from 2023-01-23 12-51-06.png
2023-01-23 12:58 psanjuan Assigned To Jorge Bravo => mgonzalezh
2023-01-23 12:59 psanjuan Proposed Solution updated
2023-01-23 15:49 hgbot Merge Request Status => open
2023-01-23 15:49 hgbot Note Added: 0145768
2023-01-23 16:09 hgbot Note Added: 0145769
2023-01-23 16:15 hgbot Note Added: 0145770
2023-01-23 17:58 mgonzalezh Relationship added blocks 0050834
2023-01-25 09:50 hgbot Merge Request Status open => approved
2023-01-25 09:51 hgbot Note Added: 0145819
2023-01-25 09:51 hgbot Note Added: 0145820
2023-01-25 09:51 vmromanos Status new => scheduled
2023-01-25 09:51 vmromanos Status scheduled => resolved
2023-01-25 09:51 vmromanos Resolution open => fixed
2023-01-25 09:51 vmromanos Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker