Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
0014759Localization Pack: SpainInvoice Register Bookpublic2010-10-04 17:002011-08-25 11:04
azabaleta 
jecharri 
urgentmajoralways
closedfixed 
5
 
1.2.3 
0014759: Sales invoices should either been taken by invoice date or accounting date in the books
Now, the invoice register book uses accounting date for taking purchase invoices, and invoice date for taking sales invoice to the register book.

As in some industries (renewable energies) sales invoices are not issued by the company, some times the register of the sales invoice in the ERP needs to be done more than one month later from whem the invoice was really issued. In that cases there is a need for the accounting date to be taken into account for sales invoices register book.

So, it would be a great advantage, if the user could decide which date take into account. Either the accounting date or the invoice date.

Thanks
Allow the end-user to either setup the sales invoice book, to take either the accounting date or the invoice date.

Please see image attached.

End user must be able to setup the Issued Invoice Book to take either the:
Sales Invoice Date (Document Date) or
Sales Accounting Date (Accounting Date)
No tags attached.
png 14759-proposal.png (42,309) 2011-06-30 18:57
https://issues.openbravo.com/file_download.php?file_id=4269&type=bug
png

png 14759-0.png (39,697) 2011-07-05 09:25
https://issues.openbravo.com/file_download.php?file_id=4282&type=bug
png

png 14759-1.png (54,818) 2011-07-05 09:26
https://issues.openbravo.com/file_download.php?file_id=4283&type=bug
png
Issue History
2010-10-04 17:00azabaletaNew Issue
2010-10-04 17:00azabaletaAssigned To => vmromanos
2011-05-24 11:47psanjuanSummarySales invoices in sales invoice register book been taken by invoice date => Sales invoices and Purchase invoices should either been taken by invoice date or accounting date in the books
2011-05-24 11:50psanjuanNote Added: 0037367
2011-05-24 11:50psanjuanPrioritynormal => urgent
2011-06-03 11:03dalsasuaAssigned Tovmromanos => dalsasua
2011-06-29 17:23hgbotCheckin
2011-06-29 17:23hgbotNote Added: 0038604
2011-06-29 17:23hgbotStatusnew => resolved
2011-06-29 17:23hgbotResolutionopen => fixed
2011-06-29 17:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/786b08e4059737779a19cffd250a15da58b336be [^]
2011-06-29 17:23hgbotCheckin
2011-06-29 17:23hgbotNote Added: 0038606
2011-06-29 17:23hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/786b08e4059737779a19cffd250a15da58b336be [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/67b54cfcb98c0db616b0a619f021aad27cff6c4a [^]
2011-06-30 18:52psanjuanStatusresolved => new
2011-06-30 18:52psanjuanSummarySales invoices and Purchase invoices should either been taken by invoice date or accounting date in the books => Sales invoices should either been taken by invoice date or accounting date in the books
2011-06-30 18:52psanjuanProposed Solution updated
2011-06-30 18:54psanjuanProposed Solution updated
2011-06-30 18:57psanjuanFile Added: 14759-proposal.png
2011-06-30 18:59psanjuanDescription Updatedbug_revision_view_page.php?rev_id=2337#r2337
2011-06-30 18:59psanjuanProposed Solution updated
2011-07-04 10:54hgbotCheckin
2011-07-04 10:54hgbotNote Added: 0038737
2011-07-05 08:55jecharriStatusnew => scheduled
2011-07-05 08:55jecharriAssigned Todalsasua => jecharri
2011-07-05 08:55jecharrifix_in_branch => pi
2011-07-05 08:56jecharriStatusscheduled => resolved
2011-07-05 08:56jecharriFixed in Version => 1.2.3
2011-07-05 09:23psanjuanNote Added: 0038758
2011-07-05 09:23psanjuanStatusresolved => new
2011-07-05 09:23psanjuanfix_in_branchpi =>
2011-07-05 09:25psanjuanFile Added: 14759-0.png
2011-07-05 09:26psanjuanFile Added: 14759-1.png
2011-07-05 09:28psanjuanNote Edited: 0038758bug_revision_view_page.php?bugnote_id=0038758#r2351
2011-07-05 18:18hgbotCheckin
2011-07-05 18:18hgbotNote Added: 0038794
2011-08-25 11:03psanjuanStatusnew => scheduled
2011-08-25 11:04psanjuanNote Added: 0040495
2011-08-25 11:04psanjuanStatusscheduled => resolved
2011-08-25 11:04psanjuanStatusresolved => closed

Notes
(0037367)
psanjuan   
2011-05-24 11:50   
What the law says is that both the purchase invoices and the sales invoices must be taken in the VAT books by the Invoice Date. Anyway, we will adjust the books by adding two parameters in each book:
- use invoice date
- use accounting date

The VAT can be allocated to the period in which those are posted (rather than by the time of devengo, which is what the law says, because there is a period of 4 years for VAT settlement). That is the reason why invoices are taken in the VAT reports by accounting date, which means that the invoices have been either issued or received.
(0038604)
hgbot   
2011-06-29 17:23   
Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: 786b08e4059737779a19cffd250a15da58b336be
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Jun 23 16:41:21 2011 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/786b08e4059737779a19cffd250a15da58b336be [^]

fixes issue 14759: Sales invoices and Purchase invoices should either been taken by invoice date or accounting date in the books

---
M src-db/database/model/tables/OBIRB_INVBOOK.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLines.java
---
(0038606)
hgbot   
2011-06-29 17:23   
Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: 67b54cfcb98c0db616b0a619f021aad27cff6c4a
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Jun 23 18:11:34 2011 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/67b54cfcb98c0db616b0a619f021aad27cff6c4a [^]

Fixes issue fixes issue 14759: Sales invoices and Purchase invoices date

---
M src-db/database/sourcedata/AD_FIELD.xml
---
(0038737)
hgbot   
2011-07-04 10:54   
Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: 1d9252adc9bb7d97978baba01bfc4fd920d62dfa
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Fri Jul 01 14:49:05 2011 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/1d9252adc9bb7d97978baba01bfc4fd920d62dfa [^]

issue 13313,issue 16097,issue 16450,issue 14759,issue 17583

---
M src-db/database/model/functions/OBIRB_GETOPERATIONDATE.xml
M src-db/database/model/tables/OBIRB_INVBOOK.xml
M src-db/database/model/tables/OBIRB_INVBOOK_SETUP.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLines.java
---
(0038758)
psanjuan   
2011-07-05 09:23   
(edited on: 2011-07-05 09:28)
Invoice Register Book is not working properly as described in the scenario below, in the case of Sales (same applies to Purchase):
Create a Good Shipment (1) dated on:
Movement date = 10-08-2011
Accounting date = 11-08-2011
Create another Good Shipment (2) dated on:
Movement date =05-07-2011
Accounting date = 25-07-2011

Create a new sales invoice by taking into account above good shipments.
Invoice date = 20-08-2011
Accounting date = 10-09-2008

Setup de Sales Invoice book to take the sales invoices by accounting date.
Launch the Sales invoice book for August 2011.
Above sales invoice must not be shown but it is shown, which is not right.

Right behaviour:

(1) In the case of selecting "Accouning date", the invoice above should be shown in the sales book of September.

(2)In the case of selecting "invoice date", the invoice above should be shown in the sales book of August.

It is not just a matter of selecting which type of date (Invoice date or Accounting date) must be shown but also which date must be used to generate the sales book based on the dates entered in the fields "From Period" "To Period" while launching the books.

(0038794)
hgbot   
2011-07-05 18:18   
Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: 61b90d5642bc96bd5580e4541074666e0e979aae
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Jul 05 16:52:16 2011 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/61b90d5642bc96bd5580e4541074666e0e979aae [^]

issue 14759

---
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLines.java
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLinesDao.java
---
(0040495)
psanjuan   
2011-08-25 11:04   
fixed and working