Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0014759
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Localization Pack: Spain] Invoice Register Bookmajoralways2010-10-04 17:002011-08-25 11:04
ReporterazabaletaView Statuspublic 
Assigned Tojecharri 
PriorityurgentResolutionfixedFixed in Version1.2.3
StatusclosedFix in branchFixed in SCM revision67b54cfcb98c
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM 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

DescriptionNow, 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 SolutionAllow 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)
TagsNo tags attached.
Attached Filespng file icon 14759-proposal.png [^] (42,309 bytes) 2011-06-30 18:57


png file icon 14759-0.png [^] (39,697 bytes) 2011-07-05 09:25


png file icon 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
Powered by Mantis Bugtracker