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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0026492
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Localization Pack: Spain] Invoice Register Bookmajoralways2014-05-08 13:042014-08-21 11:35
ReporterpsanjuanView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisiona0610abd918e
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

0026492: Payment information should be shown only in one line in the Invoice Register Books.

DescriptionPayment information should be shown only in one line in the Invoice Register Books.
Steps To ReproduceCreate a sales/purchase invoice by including product/services with different tax rates, for instance: Entregas Exentas, Servicios Prestados nacional 10% IVA de Caja, Transmisión B. Inmuebles 21% IVA de Caja.

Complete and post the invoice dated in November 2014 for instance.

Pay the invoice partially dated on November 2014.

Create the Issued invoice register book. Make it final.

Realize that in relation to that invoice (in our example invoice 68) there are 6 lines. 3 lines refers to the invoice lines, rest of 3 lines refers to the payment information related to each of those invoice lines.

Proposed SolutionThere should be only one line referred to the payment of the invoice 68 in our example with below information:

Invoice = 10000068-28-11-2014-28250.00 (that is the invoice information)
Register number = 61 (this line should also get a register number depending on the payment date)
Document Nº= 1000068 (that is the invoice number)
Document date = 28-11-2014 (that is the invoice date)
Payment/Collection date = 30-11-2014 (that is the payment date)
Tax Book Key = Z
Business Partner Name = Cliente en Efectivo (that is the BP of the invoice)
Tax ID key= 1 (that is the Tax ID key of the invoice)
Tax ID value =NIF (that is the Tax ID value of the invoice)
Country = ES (that is the country of the BP)
Taxable Amount = empty
VAT rate = empty
VAT Amount = empty
EC Tax Rate = empty
EC Tax Rate amount = empty
Deductible Tax amount = empty
Total Gross Amount = 28.250.00 (that is the total gross amount of the invoice)
VAT Tax = empty
Amount/Paid Collected = 7.620 (that is the payment amount)
Payment Method = Cash
Bank = Caja (IVA de Caja)

TagsNo tags attached.
Attached Filespng file icon 26492_1.png [^] (77,156 bytes) 2014-05-08 13:20


png file icon 26492_2.png [^] (83,510 bytes) 2014-05-08 13:20

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0026082 closedSandrahuguet Openbravo ERP A very ugly error is shown after reactivating a payment in/out of a sales/purchase invoice including CASH VAT 

-  Notes
(0067023)
psanjuan (manager)
2014-05-08 13:17

 In general there should not be as many payment referred lines as invoice lines but only one, and this line should include generic information such as invoice number, invoice date, BP, total gross amount of the invoice, payment date, payment amount; and remove line related information such as VAT Tax rate, taxable amount, tax amount, EC tax rate, EC Tax Amount.
(0067025)
psanjuan (manager)
2014-05-08 13:46
edited on: 2014-05-08 13:46

 once fixed, verify issue 26082 as the warning message will need to be adjusted.
(0068658)
hgbot (developer)
2014-07-15 19:33

 Repository: erp/pmods/org.openbravo.module.invoicesregisterbook
Changeset: a0610abd918e0fd26485043913193ddcfd43b9d5
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Jul 15 17:01:07 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/a0610abd918e0fd26485043913193ddcfd43b9d5 [^]

Fixed Issue 26492: Payment information should be shown only in one line in the Invoice Register Books

---
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_TAB.xml
M src/org/openbravo/module/invoicesregisterbook/cashvat/CreateBookLinesCashVATDao.java
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLines.java
M src/org/openbravo/module/invoicesregisterbook/obirb_actionButton/CreateBookLinesDao.java
---
(0069546)
psanjuan (manager)
2014-08-20 13:48

 Testing on hold due to Cost Adjusting project.
(0069564)
psanjuan (manager)
2014-08-21 11:35

 fixed and working.

- Issue History
Date Modified Username Field Change
2014-05-08 13:04 psanjuan New Issue
2014-05-08 13:04 psanjuan Assigned To => jonalegriaesarte
2014-05-08 13:17 psanjuan Note Added: 0067023
2014-05-08 13:17 psanjuan Proposed Solution updated
2014-05-08 13:20 psanjuan File Added: 26492_1.png
2014-05-08 13:20 psanjuan File Added: 26492_2.png
2014-05-08 13:46 psanjuan Note Added: 0067025
2014-05-08 13:46 psanjuan Relationship added related to 0026082
2014-05-08 13:46 psanjuan Note Edited: 0067025 View Revisions
2014-05-09 14:46 psanjuan Summary Payment information should be shown only in one line => Payment information should be shown only in one line in the Invoice Register Books.
2014-05-09 14:46 psanjuan Description Updated View Revisions
2014-07-15 16:37 vmromanos Status new => scheduled
2014-07-15 16:37 vmromanos Assigned To jonalegriaesarte => vmromanos
2014-07-15 16:37 vmromanos fix_in_branch => pi
2014-07-15 19:33 hgbot Checkin
2014-07-15 19:33 hgbot Note Added: 0068658
2014-07-15 19:33 hgbot Status scheduled => resolved
2014-07-15 19:33 hgbot Resolution open => fixed
2014-07-15 19:33 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicesregisterbook/rev/a0610abd918e0fd26485043913193ddcfd43b9d5 [^]
2014-08-20 13:48 psanjuan Note Added: 0069546
2014-08-21 11:35 psanjuan Note Added: 0069564
2014-08-21 11:35 psanjuan Status resolved => closed
2014-08-21 11:35 psanjuan fix_in_branch pi =>

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker