Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
0014022Localization Pack: SpainInvoice Register Bookpublic2010-07-21 13:402010-08-20 09:39
networkb 
vmromanos 
immediatemajoralways
closedfixed 
20
 
1.2.2 
0014022: There is no order when printing Invoice Register Book
There is no order when printing Invoice Register Book. The report doesn't order by date neither document number.

It seems the order is stablished by seqno, but this number is not filled when runing the create process.

The order is very important specially on Sales invoice register book since it is a spanish legal requirement.
Go to Financial Management || Accounting || Setup || Invoice Register Book Setup || Invoice Register Book
-Create an IRB for issued invoices
-Add the tax rate entregas 16%
- Create 4 Sales invoice with one line linked to entregas 16% VAT
- Go to Financial Management || Accounting || Analysis Tools || Invoice Register Book || Header
- Run process Create
- Notice that 4 lines are created without Register number
- Go to the header and print
No tags attached.
pdf IssuedInvoicesRegisterBook.jrxml-1.pdf (2,311) 2010-07-21 13:40
https://issues.openbravo.com/file_download.php?file_id=2789&type=bug
Issue History
2010-07-21 13:40networkbNew Issue
2010-07-21 13:40networkbAssigned To => vmromanos
2010-07-21 13:40networkbFile Added: IssuedInvoicesRegisterBook.jrxml-1.pdf
2010-08-17 15:19networkbPriorityhigh => immediate
2010-08-17 17:10vmromanosStatusnew => scheduled
2010-08-17 17:10vmromanosNote Added: 0030079
2010-08-17 17:10vmromanosfix_in_branch => pi
2010-08-17 17:46hgbotCheckin
2010-08-17 17:46hgbotNote Added: 0030080
2010-08-17 17:46hgbotStatusscheduled => resolved
2010-08-17 17:46hgbotResolutionopen => fixed
2010-08-17 17:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/db0be7d3fd604350c1a2ba6b04542d931b54eb14 [^]
2010-08-20 09:39psanjuanNote Added: 0030172
2010-08-20 09:39psanjuanStatusresolved => closed
2010-08-20 09:39psanjuanfix_in_branchpi =>

Notes
(0030079)
vmromanos   
2010-08-17 17:10   
The Register Number is created when the book is processed (marked as final). As you said, the report is ordered by this sequence number.

A book can be in draft mode, so no Register Number is available, and in final mode (with a register number). The law forces the companies to keep a register/issue book in which all received/issued invoices or equivalent documents have to be **correlatively** numbered. So, the company should mark the book as final for properly fulfilling the law. Once the book is in final mode, it will be printed following the proper order (Register no.).


The fix of this bug will just consists on printing the books ordered by document date when no Register Number is available (i.e. in draft mode)
(0030080)
hgbot   
2010-08-17 17:46   
Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: db0be7d3fd604350c1a2ba6b04542d931b54eb14
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Aug 17 17:47:41 2010 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/db0be7d3fd604350c1a2ba6b04542d931b54eb14 [^]

Fixed bug 14022: draft books are ordered by document date

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/module/invoicesregisterbook/obirb_reports/IssuedInvoicesRegisterBook.jrxml
M src/org/openbravo/module/invoicesregisterbook/obirb_reports/ReceivedInvoicesRegisterBook.jrxml
---
(0030172)
psanjuan   
2010-08-20 09:39   
BUG FIXED.
PLEASE PUBLISH A NEW VERSION OF THE MODULE.