Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009900Openbravo ERP09. Financial managementpublic2009-07-14 19:412009-08-18 00:00
Reporternetworkb 
Assigned Tosathiyan 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.40MP6 
Target Version2.50MP4Fixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009900: 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>
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00099512.50MP4 closed sathiyan create vat register process does not include invoices with tax date equals to "Ending Date" in tab "Tax payment-> header" 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-14 19:41networkbNew Issue
2009-07-14 19:41networkbAssigned To => rafaroda
2009-07-14 20:02networkbSteps to Reproduce Updated
2009-07-19 16:30psarobeStatusnew => scheduled
2009-07-19 16:30psarobefix_in_branch => pi
2009-07-20 09:02rafarodaAssigned Torafaroda => sathiyan
2009-07-28 06:52pjuvaraTarget Version => 2.50MP4
2009-07-29 11:19hgbotCheckin
2009-07-29 11:19hgbotNote Added: 0018678
2009-07-29 11:19hgbotStatusscheduled => resolved
2009-07-29 11:19hgbotResolutionopen => fixed
2009-07-29 11:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/64032f98cb7d296fc7aef5b52f31c77a7c6db615 [^]
2009-08-17 12:17sureshbabuStatusresolved => closed
2009-08-17 12:17sureshbabuNote Added: 0018966
2009-08-17 12:17sureshbabuFixed in Version => pi
2009-08-18 00:00anonymoussf_bug_id0 => 2839264

Notes
(0018678)
hgbot   
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   
2009-08-17 12:17   
Tested, invoice which is created on the same day also includes in Tax payment process.