Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0014759 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
feature request | [Localization Pack: Spain] Invoice Register Book | major | always | 2010-10-04 17:00 | 2011-08-25 11:04 | |||
Reporter | azabaleta | View Status | public | |||||
Assigned To | jecharri | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | 1.2.3 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 67b54cfcb98c | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Regression date | ||||||||
Regression introduced by commit | ||||||||
Regression level | ||||||||
Review Assigned To | ||||||||
Regression introduced in release | ||||||||
Summary | 0014759: Sales invoices should either been taken by invoice date or accounting date in the books | |||||||
Description | 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 | |||||||
Proposed Solution | 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) | |||||||
Tags | No tags attached. | |||||||
Attached Files | 14759-proposal.png [^] (42,309 bytes) 2011-06-30 18:57
14759-0.png [^] (39,697 bytes) 2011-07-05 09:25 14759-1.png [^] (54,818 bytes) 2011-07-05 09:26 | |||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0037367) psanjuan (manager) 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 (developer) 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 (developer) 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 (developer) 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 (manager) 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 (developer) 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 (manager) 2011-08-25 11:04 |
fixed and working |
Issue History | |||
Date Modified | Username | Field | Change |
2010-10-04 17:00 | azabaleta | New Issue | |
2010-10-04 17:00 | azabaleta | Assigned To | => vmromanos |
2011-05-24 11:47 | psanjuan | Summary | Sales 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:50 | psanjuan | Note Added: 0037367 | |
2011-05-24 11:50 | psanjuan | Priority | normal => urgent |
2011-06-03 11:03 | dalsasua | Assigned To | vmromanos => dalsasua |
2011-06-29 17:23 | hgbot | Checkin | |
2011-06-29 17:23 | hgbot | Note Added: 0038604 | |
2011-06-29 17:23 | hgbot | Status | new => resolved |
2011-06-29 17:23 | hgbot | Resolution | open => fixed |
2011-06-29 17:23 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/786b08e4059737779a19cffd250a15da58b336be [^] |
2011-06-29 17:23 | hgbot | Checkin | |
2011-06-29 17:23 | hgbot | Note Added: 0038606 | |
2011-06-29 17:23 | hgbot | Fixed in SCM revision | http://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:52 | psanjuan | Status | resolved => new |
2011-06-30 18:52 | psanjuan | Summary | Sales 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:52 | psanjuan | Proposed Solution updated | |
2011-06-30 18:54 | psanjuan | Proposed Solution updated | |
2011-06-30 18:57 | psanjuan | File Added: 14759-proposal.png | |
2011-06-30 18:59 | psanjuan | Description Updated | View Revisions |
2011-06-30 18:59 | psanjuan | Proposed Solution updated | |
2011-07-04 10:54 | hgbot | Checkin | |
2011-07-04 10:54 | hgbot | Note Added: 0038737 | |
2011-07-05 08:55 | jecharri | Status | new => scheduled |
2011-07-05 08:55 | jecharri | Assigned To | dalsasua => jecharri |
2011-07-05 08:55 | jecharri | fix_in_branch | => pi |
2011-07-05 08:56 | jecharri | Status | scheduled => resolved |
2011-07-05 08:56 | jecharri | Fixed in Version | => 1.2.3 |
2011-07-05 09:23 | psanjuan | Note Added: 0038758 | |
2011-07-05 09:23 | psanjuan | Status | resolved => new |
2011-07-05 09:23 | psanjuan | fix_in_branch | pi => |
2011-07-05 09:25 | psanjuan | File Added: 14759-0.png | |
2011-07-05 09:26 | psanjuan | File Added: 14759-1.png | |
2011-07-05 09:28 | psanjuan | Note Edited: 0038758 | View Revisions |
2011-07-05 18:18 | hgbot | Checkin | |
2011-07-05 18:18 | hgbot | Note Added: 0038794 | |
2011-08-25 11:03 | psanjuan | Status | new => scheduled |
2011-08-25 11:04 | psanjuan | Note Added: 0040495 | |
2011-08-25 11:04 | psanjuan | Status | scheduled => resolved |
2011-08-25 11:04 | psanjuan | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |