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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009900
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-07-14 19:412009-08-18 00:00
ReporternetworkbView Statuspublic 
Assigned Tosathiyan 
PriorityimmediateResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revision64032f98cb7d
ProjectionnoneETAnoneTarget Version2.50MP4
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.40MP6SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009900: create vat register process does not include invoices with tax date equals to "Ending Date" in tab "Tax payment-> header"

Descriptioninvoice with tax date is the same day that "Ending Date" in tab "Tax payment-> header", but time is distinct of 00:00:00, then invoice is not included in process "create vat register"
Steps To Reproducein Sales Management || Transactions || Sales Invoice || Header
. create invoice:
    date tax = to_date ('30/06/2009 01:00:00', 'DD-MM-YYYY HH24:MI:SS')
. create invoice lines
. run process invoice
    
in Financial Management || Receivables & Payables || Transactions || Tax Payment || Header :
 . create new:
    . Ending Date = 30/06/2009
    . run "create vat registers"

Proposed Solutionfile .../ad_actionbutton/CreateVarRegister.java:
 line 167:
  taxRegister.cTaxregisterTypeId, strDatefrom, strDateto);
 --replace by--
  taxRegister.cTaxregisterTypeId, strDatefrom, DateTimeData.nDaysAfter(this, strDateTo,"1"));

file .../ad_actionbutton/CreateVarRegister_data.xsql
 line 68: ...
   <Parameter name="parDateTo" optional="true" after="and 1=1"><![CDATA[ and C_Invoice.TaxDate <= to_date(?)]]></Parameter>
  --replace by--
    <Parameter name="parDateTo" optional="true" after="and 1=1"><![CDATA[ and C_Invoice.TaxDate < to_date(?)]]></Parameter>
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00099512.50MP4 closedsathiyan create vat register process does not include invoices with tax date equals to "Ending Date" in tab "Tax payment-> header" 

-  Notes
(0018678)
hgbot (developer)
2009-07-29 11:19

Repository: erp/devel/pi
Changeset: 64032f98cb7d296fc7aef5b52f31c77a7c6db615
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Jul 29 14:41:20 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/64032f98cb7d296fc7aef5b52f31c77a7c6db615 [^]

Fixed Issue 9900: create vat register process does not include invoices with tax date equals to \"Ending Date\" in tab \"Tax payment-> header\"

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters.java
M src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters_data.xsql
---
(0018966)
sureshbabu (reporter)
2009-08-17 12:17

Tested, invoice which is created on the same day also includes in Tax payment process.

- Issue History
Date Modified Username Field Change
2009-07-14 19:41 networkb New Issue
2009-07-14 19:41 networkb Assigned To => rafaroda
2009-07-14 20:02 networkb Steps to Reproduce Updated
2009-07-19 16:30 psarobe Status new => scheduled
2009-07-19 16:30 psarobe fix_in_branch => pi
2009-07-20 09:02 rafaroda Assigned To rafaroda => sathiyan
2009-07-28 06:52 pjuvara Target Version => 2.50MP4
2009-07-29 11:19 hgbot Checkin
2009-07-29 11:19 hgbot Note Added: 0018678
2009-07-29 11:19 hgbot Status scheduled => resolved
2009-07-29 11:19 hgbot Resolution open => fixed
2009-07-29 11:19 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/64032f98cb7d296fc7aef5b52f31c77a7c6db615 [^]
2009-08-17 12:17 sureshbabu Status resolved => closed
2009-08-17 12:17 sureshbabu Note Added: 0018966
2009-08-17 12:17 sureshbabu Fixed in Version => pi
2009-08-18 00:00 anonymous sf_bug_id 0 => 2839264


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker