0009900: 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 ]

depends on

backport

0009951

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
(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 (viewer) 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 19:41	networkb	OBNetwork customer	=> Yes
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