Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016029Localization Pack: SpainInvoice Register Bookpublic2011-02-23 13:112011-04-05 17:17
Reportermaite 
Assigned Todalsasua 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
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
Summary0016029: Voided invoices are not taken into account in Invoice Register Book
DescriptionActually Voided invoices are not taken into account in Invoice Register Book.

Both the original and the voided invoices must be shown in the Invoice Register Book.

The original invoice are now shown.
The voided invoice must be also shown.

Steps To Reproduce1. Configure Invoices Register Book following: http://forge.openbravo.com/plugins/mwiki/index.php/Invoicesregisterbook/UserDocumentation#Configuraci.C3.B3n_y_creaci.C3.B3n_de_los_libros [^]
2. Procurement Management || Transactions || Purchase Invoice || Header : create record for any BP and add any line with tax "IVA 16% Adquisiciones". Complete.
3. Go to Financial Management || Accounting || Analysis Tools || Invoice Register Book || Header and press "create" button for "Libro Facturas Recibidas". Realize that line for your tax has been included.
4. Come back to invoice and VOID it. Associated invoice has been created.
5. Go to Financial Management || Accounting || Analysis Tools || Invoice Register Book || Header and press "create" for "Libro Facturas Recibidas" again. Realize that no lines are in the book.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 00161752.50MP28 closed dalsasua Openbravo ERP According to law, Reversed Invoices should follow its own DocumentSequence 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-02-23 13:11maiteNew Issue
2011-02-23 13:11maiteAssigned To => vmromanos
2011-02-23 13:57vmromanosAssigned Tovmromanos => psanjuan
2011-03-02 09:20psanjuanAssigned Topsanjuan => dalsasua
2011-03-02 09:58psanjuanDescription Updatedbug_revision_view_page.php?rev_id=1544#r1544
2011-03-04 09:24psanjuanDescription Updatedbug_revision_view_page.php?rev_id=1560#r1560
2011-03-10 13:58psanjuanNote Added: 0034729
2011-03-10 13:58psanjuanAssigned Todalsasua => vmromanos
2011-03-10 13:58psanjuanRelationship addeddepends on 0016175
2011-03-10 15:08psanjuanDescription Updatedbug_revision_view_page.php?rev_id=1594#r1594
2011-03-10 15:19psanjuanNote Edited: 0034729bug_revision_view_page.php?bugnote_id=0034729#r1596
2011-03-10 15:19psanjuanNote Edited: 0034729bug_revision_view_page.php?bugnote_id=0034729#r1597
2011-03-10 16:06psanjuanNote Edited: 0034729bug_revision_view_page.php?bugnote_id=0034729#r1602
2011-03-11 11:50psanjuanAssigned Tovmromanos => adrianromero
2011-03-11 13:41psanjuanAssigned Toadrianromero => dalsasua
2011-03-22 11:22hgbotCheckin
2011-03-22 11:22hgbotNote Added: 0035137
2011-03-22 11:22hgbotStatusnew => resolved
2011-03-22 11:22hgbotResolutionopen => fixed
2011-03-22 11:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/4ffc5766311141ca01e159301f8512dde85998b7 [^]
2011-03-23 15:14psanjuanNote Added: 0035177
2011-03-23 15:15psanjuanNote Added: 0035178
2011-03-23 15:15psanjuanStatusresolved => closed
2011-03-23 15:16psanjuanNote Edited: 0035177bug_revision_view_page.php?bugnote_id=0035177#r1693
2011-04-05 17:17psanjuanSummaryActually Voided invoices are not taken into account in Invoice Register Book => Voided invoices are not taken into account in Invoice Register Book

Notes
(0034729)
psanjuan   
2011-03-10 13:58   
(edited on: 2011-03-10 16:06)
There is one important thing to take into account here.

Void invoices (corrective invoices) should have a specific document sequence number different from the document sequence number used by the Invoices.
See related issue: 16175
We should fix issue number 16175 (by creating a new doc type named "Factura Rectificativa") and then fix this one, but...
In the meantime:
We are going to implement 3 new flags named in the "Invoice Register Book" setup window:
"Include Void" - if the end-user selects this flag the corresponding Invoice Book will include void invoices.
"Include Credit Memo" - if the end-user selects this flag the corresponding Invoice Book will include credit memo (current behaviour)
"Use Order Reference Number" (which is going to be renamed to "Vendor/Customer Reference") - if the end-user selects this flag the corresponding Invoice Book will take the Order Reference number filled-in by the end-user manually instead of the Document Nº. If there is no Order Reference number, the Document Nº will be taken instead. The reason for this feature is to support somehow the fact that the Corrective Invoices must follow another Document Sequence Number which should be manually handled by the end-user.
(0035137)
hgbot   
2011-03-22 11:22   
Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: 4ffc5766311141ca01e159301f8512dde85998b7
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Mar 21 12:35:25 2011 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/4ffc5766311141ca01e159301f8512dde85998b7 [^]

Fixes issue 16029.
Voided invoices go to report

---
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLinesDao.java
---
(0035177)
psanjuan   
2011-03-23 15:14   
(edited on: 2011-03-23 15:16)
The way this feature has been finally implemented it is not the way described above. See note dated on 10 March 2011

Now the voided invoices are shown in the corresponding book (purchase or sales invoice book) marked as "D" and with negative amounts, which is ok

What it is not ok is the fact that voided sales invoice can not follow a different numbering, see issue 16175.

Numbering issue does not affect to purchase invoice as now those ones can follow Vendor Document Nº logic, see new parameter "Document Number" in the VAT Books setup window, in the case of Received Invoices.
(0035178)
psanjuan   
2011-03-23 15:15   
fixed and working but voided sales invoice numbering, see issue 16175