Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009951Openbravo ERP09. Financial managementpublic2009-07-14 19:412009-07-31 08:09
Reporternetworkb 
Assigned Tosathiyan 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.40MP6 
Target Version2.50MP4Fixed in Version2.40MP8 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009951: 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
blocks defect 00099002.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-19 16:30psarobeTypedefect => backport
2009-07-19 16:30psarobefix_in_branch => 2.40
2009-07-20 09:02rafarodaAssigned Torafaroda => sathiyan
2009-07-28 06:52pjuvaraTarget Version => 2.50MP4
2009-07-29 10:14hgbotCheckin
2009-07-29 10:14hgbotNote Added: 0018676
2009-07-29 10:14hgbotStatusscheduled => resolved
2009-07-29 10:14hgbotResolutionopen => fixed
2009-07-29 10:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/e1b8cac288dbbc4aed67e938bd9e6375b4468742 [^]
2009-07-31 08:09sureshbabuStatusresolved => closed
2009-07-31 08:09sureshbabuNote Added: 0018740
2009-07-31 08:09sureshbabuFixed in Version => 2.40MP8

Notes
(0018676)
hgbot   
2009-07-29 10:14   
Repository: erp/stable/2.40
Changeset: e1b8cac288dbbc4aed67e938bd9e6375b4468742
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Jul 29 13:19:22 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/e1b8cac288dbbc4aed67e938bd9e6375b4468742 [^]

Fixed issue 9951: 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
---
(0018740)
sureshbabu   
2009-07-31 08:09   
Tested working fine