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

Description

invoice 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 Reproduce

in 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 Solution

file .../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>

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0009900

2.50MP4

closed

sathiyan

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

Notes
(0018676) hgbot (developer) 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 (reporter) 2009-07-31 08:09	Tested working fine

Issue History
Date Modified	Username	Field	Change
2009-07-19 16:30	psarobe	Type	defect => backport
2009-07-19 16:30	psarobe	fix_in_branch	=> 2.40
2009-07-20 09:02	rafaroda	Assigned To	rafaroda => sathiyan
2009-07-28 06:52	pjuvara	Target Version	=> 2.50MP4
2009-07-29 10:14	hgbot	Checkin
2009-07-29 10:14	hgbot	Note Added: 0018676
2009-07-29 10:14	hgbot	Status	scheduled => resolved
2009-07-29 10:14	hgbot	Resolution	open => fixed
2009-07-29 10:14	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.40/rev/e1b8cac288dbbc4aed67e938bd9e6375b4468742 [^]
2009-07-31 08:09	sureshbabu	Status	resolved => closed
2009-07-31 08:09	sureshbabu	Note Added: 0018740
2009-07-31 08:09	sureshbabu	Fixed in Version	=> 2.40MP8