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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009900

Openbravo ERP

09. Financial management

public

2009-07-14 19:41

2009-08-18 00:00

Reporter

networkb

Assigned To

sathiyan

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

rPath Linux

Product Version

2.40MP6

Target Version

2.50MP4

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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>

Additional Information