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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0026178
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Localization Pack: Spain] Invoice Register Bookmajoralways2014-04-04 11:522014-05-06 15:51
ReporterpsanjuanView Statuspublic 
Assigned ToSandrahuguet 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision86e182f4c684
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0026178: The register number of the Invoice Register Book is not working anymore as payments linked to CASH VAT invoices are also include

DescriptionThe register number of the Invoice Register Book is not working anymore as payments linked to CASH VAT invoices are also include in the book dated on the payment date.

In those cases the date to take into account should be the payment date instead of the invoice/accounting date which originated the payment.

Same applies to issued/received invoice register book for those organizations subject to CASH VAT or organizations do not working under this regimen but receiving purchases invoices including Cash VAT.
Steps To ReproduceN/A
Proposed SolutionLet's take below example:

January Book can include below invoice's dates with a given register number
01-01-2014 - register number 1
02-01-2014 - register number 2
03-01-2014 - register number 3
06-01-2014 - register number 4
15-01-2014 - register number 5
15-01-2014 - register number 6
15-01-2014 - register number 7
20-01-2014 - register number 8

February Book can include below invoices:
01-02-2014 - register number 9 (this date is the payment date of the invoice dated on 01-01-2014)
02-02-2014 - register number 10 (this date is the payment date of the invoice dated on 02-01-2014)
03-02-2014 - register number 11
05-02-2014 - register number 12
06-02-2014 - register number 13 (this date is the payment date of the invoice dated on 03-01-2014)

March Book can include below invoices:
05-03-2014 - register number 14
05-03-2014 - register number 15
06-03-2014 - register number 16 (this date is the payment date of the invoice dated on 06-01-2014)
etc...

We need to take into account that:
the purchase invoices are taken into the purchase invoice book by accounting date, therefore the dates to take into account are:
(1) the accounting date of the invoices
(2) the payment date

the sales invoice can be taken into the sales invoice book either by accounting date or by document date, therefore the dates to take into account are:
(1) the accounting date of the invoices
(2) the payment date
or
(1) the document date of the invoices
(2) the payment date
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0066504)
hgbot (developer)
2014-04-16 16:27

Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: bafd9886f9f72fa74a25b402b2ccebfc1ce6ad1a
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Apr 16 16:24:36 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/bafd9886f9f72fa74a25b402b2ccebfc1ce6ad1a [^]

Fixed bug 26178 Register no. is not working with CASH VAT invoices

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLinesDao.java
---
(0066647)
psanjuan (manager)
2014-04-28 14:23
edited on: 2014-04-28 14:33

This is not working, for instance:

(1) same register number is given to an invoice with does have two payments in two different payment dates. See SPLP machine enviroment. Purchase Invoice 71- NO IVA de Caja Org. January book (Recibidas).

(2) wrong register number is given to an invoice which does have a payment date within a period next to the document date period. See SPLP machine enviroment. May Book (Recibidas) of the NO IVA de Caja org starts by the number 43 (02-May) while it should be the number 46 (05-May - payment date)

(3) wrong register number is given. No reason why. See SPLP machine enviroment. October Book (Emitidas) of NO IVA de CAJA org. This books starts by 20 but it should start by the 15.

(4) wrong register number is given to an issued invoiced dated on 01-01-2014 (Invoice number 1000008) as the register number is 3 while it should be 1. This invoice is paid dated on 31-01

(0066674)
hgbot (developer)
2014-04-29 13:26

Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: 6dbb8c8d5229f280cf4a7377c9e5f5b9dbea32a0
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Apr 29 13:23:24 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/6dbb8c8d5229f280cf4a7377c9e5f5b9dbea32a0 [^]

Related to issue 26178

---
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLines.java
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLinesDao.java
---
(0066676)
hgbot (developer)
2014-04-29 13:39

Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: bc0ad5c1fbbbe99819989cc688cd7102431471c8
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Apr 29 13:39:00 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/bc0ad5c1fbbbe99819989cc688cd7102431471c8 [^]

Related to issue 26178

---
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLines.java
---
(0066683)
hgbot (developer)
2014-04-29 17:02

Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: 86e182f4c6840bdba0fdd10316f44a0d51010228
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Apr 29 17:02:16 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/86e182f4c6840bdba0fdd10316f44a0d51010228 [^]

Fixed issue 26178

---
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLines.java
---
(0066824)
hgbot (developer)
2014-05-05 17:59

Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: 4fd2c6b6e36143878fbe70fd5e842c65ebc6d9bf
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon May 05 17:59:24 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/4fd2c6b6e36143878fbe70fd5e842c65ebc6d9bf [^]

Related to issue 26178

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLines.java
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLinesDao.java
---
(0066843)
psanjuan (manager)
2014-05-06 14:47

fixed and working
(0066847)
hgbot (developer)
2014-05-06 15:51

Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: 9b7aee897301d9ca7291b706283d65ca63ecf3f7
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue May 06 15:51:06 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/9b7aee897301d9ca7291b706283d65ca63ecf3f7 [^]

Related to issue 26178

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLinesDao.java
---

- Issue History
Date Modified Username Field Change
2014-04-04 11:52 psanjuan New Issue
2014-04-04 11:52 psanjuan Assigned To => jonalegriaesarte
2014-04-04 12:07 psanjuan Description Updated View Revisions
2014-04-04 12:07 psanjuan Proposed Solution updated
2014-04-16 16:27 hgbot Checkin
2014-04-16 16:27 hgbot Note Added: 0066504
2014-04-16 16:27 hgbot Status new => resolved
2014-04-16 16:27 hgbot Resolution open => fixed
2014-04-16 16:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/bafd9886f9f72fa74a25b402b2ccebfc1ce6ad1a [^]
2014-04-28 14:23 psanjuan Note Added: 0066647
2014-04-28 14:23 psanjuan Status resolved => new
2014-04-28 14:30 psanjuan Note Edited: 0066647 View Revisions
2014-04-28 14:33 psanjuan Note Edited: 0066647 View Revisions
2014-04-28 18:31 Sandrahuguet Assigned To jonalegriaesarte => Sandrahuguet
2014-04-29 13:26 hgbot Checkin
2014-04-29 13:26 hgbot Note Added: 0066674
2014-04-29 13:39 hgbot Checkin
2014-04-29 13:39 hgbot Note Added: 0066676
2014-04-29 17:02 hgbot Checkin
2014-04-29 17:02 hgbot Note Added: 0066683
2014-04-29 17:02 hgbot Status new => resolved
2014-04-29 17:02 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/bafd9886f9f72fa74a25b402b2ccebfc1ce6ad1a [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/86e182f4c6840bdba0fdd10316f44a0d51010228 [^]
2014-05-05 17:59 hgbot Checkin
2014-05-05 17:59 hgbot Note Added: 0066824
2014-05-06 14:47 psanjuan Note Added: 0066843
2014-05-06 14:47 psanjuan Status resolved => closed
2014-05-06 15:51 hgbot Checkin
2014-05-06 15:51 hgbot Note Added: 0066847


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker