Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026492Localization Pack: SpainInvoice Register Bookpublic2014-05-08 13:042014-08-21 11:35
Reporterpsanjuan 
Assigned Tovmromanos 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04.1
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
Summary0026492: Payment information should be shown only in one line in the Invoice Register Books.
DescriptionPayment information should be shown only in one line in the Invoice Register Books.
Steps To ReproduceCreate a sales/purchase invoice by including product/services with different tax rates, for instance: Entregas Exentas, Servicios Prestados nacional 10% IVA de Caja, Transmisión B. Inmuebles 21% IVA de Caja.

Complete and post the invoice dated in November 2014 for instance.

Pay the invoice partially dated on November 2014.

Create the Issued invoice register book. Make it final.

Realize that in relation to that invoice (in our example invoice 68) there are 6 lines. 3 lines refers to the invoice lines, rest of 3 lines refers to the payment information related to each of those invoice lines.

Proposed SolutionThere should be only one line referred to the payment of the invoice 68 in our example with below information:

Invoice = 10000068-28-11-2014-28250.00 (that is the invoice information)
Register number = 61 (this line should also get a register number depending on the payment date)
Document Nº= 1000068 (that is the invoice number)
Document date = 28-11-2014 (that is the invoice date)
Payment/Collection date = 30-11-2014 (that is the payment date)
Tax Book Key = Z
Business Partner Name = Cliente en Efectivo (that is the BP of the invoice)
Tax ID key= 1 (that is the Tax ID key of the invoice)
Tax ID value =NIF (that is the Tax ID value of the invoice)
Country = ES (that is the country of the BP)
Taxable Amount = empty
VAT rate = empty
VAT Amount = empty
EC Tax Rate = empty
EC Tax Rate amount = empty
Deductible Tax amount = empty
Total Gross Amount = 28.250.00 (that is the total gross amount of the invoice)
VAT Tax = empty
Amount/Paid Collected = 7.620 (that is the payment amount)
Payment Method = Cash
Bank = Caja (IVA de Caja)

Additional Information
TagsNo tags attached.
Relationships
related to defect 0026082 closed Sandrahuguet Openbravo ERP A very ugly error is shown after reactivating a payment in/out of a sales/purchase invoice including CASH VAT 
Attached Filespng 26492_1.png (77,156) 2014-05-08 13:20
https://issues.openbravo.com/file_download.php?file_id=6909&type=bug
png

png 26492_2.png (83,510) 2014-05-08 13:20
https://issues.openbravo.com/file_download.php?file_id=6910&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2014-05-08 13:04psanjuanNew Issue
2014-05-08 13:04psanjuanAssigned To => jonalegriaesarte
2014-05-08 13:17psanjuanNote Added: 0067023
2014-05-08 13:17psanjuanProposed Solution updated
2014-05-08 13:20psanjuanFile Added: 26492_1.png
2014-05-08 13:20psanjuanFile Added: 26492_2.png
2014-05-08 13:46psanjuanNote Added: 0067025
2014-05-08 13:46psanjuanRelationship addedrelated to 0026082
2014-05-08 13:46psanjuanNote Edited: 0067025bug_revision_view_page.php?bugnote_id=0067025#r5791
2014-05-09 14:46psanjuanSummaryPayment information should be shown only in one line => Payment information should be shown only in one line in the Invoice Register Books.
2014-05-09 14:46psanjuanDescription Updatedbug_revision_view_page.php?rev_id=5805#r5805
2014-07-15 16:37vmromanosStatusnew => scheduled
2014-07-15 16:37vmromanosAssigned Tojonalegriaesarte => vmromanos
2014-07-15 16:37vmromanosfix_in_branch => pi
2014-07-15 19:33hgbotCheckin
2014-07-15 19:33hgbotNote Added: 0068658
2014-07-15 19:33hgbotStatusscheduled => resolved
2014-07-15 19:33hgbotResolutionopen => fixed
2014-07-15 19:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/a0610abd918e0fd26485043913193ddcfd43b9d5 [^]
2014-08-20 13:48psanjuanNote Added: 0069546
2014-08-21 11:35psanjuanNote Added: 0069564
2014-08-21 11:35psanjuanStatusresolved => closed
2014-08-21 11:35psanjuanfix_in_branchpi =>

Notes
(0067023)
psanjuan   
2014-05-08 13:17   
In general there should not be as many payment referred lines as invoice lines but only one, and this line should include generic information such as invoice number, invoice date, BP, total gross amount of the invoice, payment date, payment amount; and remove line related information such as VAT Tax rate, taxable amount, tax amount, EC tax rate, EC Tax Amount.
(0067025)
psanjuan   
2014-05-08 13:46   
once fixed, verify issue 26082 as the warning message will need to be adjusted.
(0068658)
hgbot   
2014-07-15 19:33   
Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: a0610abd918e0fd26485043913193ddcfd43b9d5
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Jul 15 17:01:07 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/a0610abd918e0fd26485043913193ddcfd43b9d5 [^]

Fixed Issue 26492: Payment information should be shown only in one line in the Invoice Register Books

---
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_TAB.xml
M src/org/openbravo/module/invoicesregisterbook/cashvat/CreateBookLinesCashVATDao.java
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLines.java
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLinesDao.java
---
(0069546)
psanjuan   
2014-08-20 13:48   
Testing on hold due to Cost Adjusting project.
(0069564)
psanjuan   
2014-08-21 11:35   
fixed and working.