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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0026091
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Localization Pack: Spain] Invoice Register Bookmajoralways2014-03-26 13:552014-08-28 18:15
ReporterpsanjuanView Statuspublic 
Assigned ToSandrahuguet 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisione6ba70714848
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0026091: The invoice register book must set the key "Z" for every single line of a purchase/sales invoice under CASH VAT regime.

DescriptionThe invoice register book must set the key "Z" for every single line of a purchase/sales invoice under CASH VAT regime, regardless if that invoice includes a line with an exempt tax rate or a line of an "Arrendamientos" tax rate which normally are set with the key "R".

Otherwise payment information will not be taken after launching the 340 tax form.
Steps To ReproduceCreate a sales invoice with below listed tax rates:
Servicios prestados nacional 21% IVA de Caja
Arrendamientos 21% -21%R (cobros) IVA de Caja
Servicios prestados exentos

Complete and Post the invoice.

Launch the book for the period when the invoice is posted, let's say February. See image attached.

Realize that the key R is shown linked to the invoice line related to the tax Arrendamientos 21% -21%R (cobros) IVA de Caja, and that should not be the case.
The correct key to show is "Z".

Same applies to purchase invoice and therefore the Received Invoice Book.

Create a purchase invoice with below listed tax rates:
Arrendamientos 21%-21%R (pagos) IVA de Caja
Prestación servicios nacional 21% IVA de Caja
Producto Exento
Servicio Exento


Complete and Post the invoice.

Launch the book for the period when the invoice is posted, let's say March. See image attached.

Realize that the key R is shown linked to the invoice line related to the tax Arrendamientos 21% -21%R (pagos) IVA de Caja, and that should not be the case.
The correct key to show is "Z".



Proposed SolutionThe invoice register book must set the key "Z" for every single line of a purchase/sales invoice under CASH VAT regime.
TagsNo tags attached.
Attached Filespng file icon 26091_sales.png [^] (121,719 bytes) 2014-03-26 14:46


png file icon 26091_purchase.png [^] (142,408 bytes) 2014-03-26 14:46

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0027500 newjonalegriaesarte Modules Error on Oracle installation ORA-00911: invalid character 

-  Notes
(0066479)
hgbot (developer)
2014-04-16 09:40

 Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: e6ba707148483759ff41ad2be11ac9289c7c784a
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Apr 16 09:18:41 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/e6ba707148483759ff41ad2be11ac9289c7c784a [^]

Fixed bug 26091 Invoice register book must set "Z" for every invoice line under CASH VAT

---
M src-db/database/model/functions/OBIRB_GENERATE_CODE.xml
A build/classes/org/openbravo/module/invoicesregisterbook/modulescript/Issue26091UpdateOperationCode.class
A build/classes/org/openbravo/module/invoicesregisterbook/modulescript/Issue26091UpdateOperationCodeData.class
A src-util/modulescript/src/org/openbravo/module/invoicesregisterbook/modulescript/Issue26091UpdateOperationCode.java
A src-util/modulescript/src/org/openbravo/module/invoicesregisterbook/modulescript/Issue26091UpdateOperationCode_data.xsql
---
(0066499)
psanjuan (manager)
2014-04-16 15:03

 fixed and working
(0069810)
rafaroda (developer)
2014-08-27 16:51

 I had the following error when this modulescript was executed in Oracle 10: [java] 173967 ERROR - SQL error in query: UPDATE C_Invoice SET PROCESSED='N' WHERE C_Invoice_ID in (select ci.c_invoice_id from c_invoice ci left join C_InvoiceTax ct on ci.c_invoice_id=ct.c_invoice_id where ci.iscashvat='Y'); UPDATE C_InvoiceTax SET EM_OBIRB_OperationCode='Z' WHERE C_INVOICE_ID in (select ci.c_invoice_id from c_invoice ci left join C_InvoiceTax ct on ci.c_invoice_id=ct.c_invoice_id where ci.iscashvat='Y'); UPDATE C_Invoice SET PROCESSED='Y' WHERE C_Invoice_ID in (select ci.c_invoice_id from c_invoice ci left join C_InvoiceTax ct on ci.c_invoice_id=ct.c_invoice_id where ci.iscashvat='Y');Exception:java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
(0069840)
rafaroda (developer)
2014-08-28 18:15

 Reported the error of the previous comment in a new related issue 0027500 Error on Oracle installation ORA-00911: invalid character https://issues.openbravo.com/view.php?id=27500 [^]

- Issue History
Date Modified Username Field Change
2014-03-26 13:55 psanjuan New Issue
2014-03-26 13:55 psanjuan Assigned To => jonalegriaesarte
2014-03-26 14:35 psanjuan Steps to Reproduce Updated View Revisions
2014-03-26 14:36 psanjuan Steps to Reproduce Updated View Revisions
2014-03-26 14:46 psanjuan File Added: 26091_sales.png
2014-03-26 14:46 psanjuan File Added: 26091_purchase.png
2014-04-04 13:47 psanjuan Description Updated View Revisions
2014-04-14 17:40 Sandrahuguet Status new => scheduled
2014-04-14 17:40 Sandrahuguet Assigned To jonalegriaesarte => Sandrahuguet
2014-04-14 17:40 Sandrahuguet fix_in_branch => pi
2014-04-16 09:40 hgbot Checkin
2014-04-16 09:40 hgbot Note Added: 0066479
2014-04-16 09:40 hgbot Status scheduled => resolved
2014-04-16 09:40 hgbot Resolution open => fixed
2014-04-16 09:40 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/e6ba707148483759ff41ad2be11ac9289c7c784a [^]
2014-04-16 15:03 psanjuan Note Added: 0066499
2014-04-16 15:03 psanjuan Status resolved => closed
2014-04-16 15:03 psanjuan fix_in_branch pi =>
2014-08-27 16:51 rafaroda Note Added: 0069810
2014-08-28 18:12 rafaroda Relationship added related to 0027500
2014-08-28 18:15 rafaroda Note Added: 0069840
2014-08-28 18:19 rafaroda Relationship added depends on 0027502
2014-08-28 18:19 rafaroda Relationship deleted depends on 0027502

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker