Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009711Openbravo ERP09. Financial managementpublic2009-06-29 18:202009-07-10 11:31
Reporternetworkb 
Assigned Toharikrishnan 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP3 
Target VersionFixed in Version2.40MP7 
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
Summary0009711: Create VAT register process does not include the original invoice when this one is cancelled.
DescriptionAn sales invoices is completed and voided.

If Create VAT register process is executed, only will take into account the cancelled invoice, not the original one.

The reason is the original invoice has 'VO' status (docstatus) and, if you revise the select of the process:

and C_Invoice.DocStatus in ('CO','CL')
         and C_Invoice.Processed= 'Y'

it does not include 'VO' status. However, the cancelled (which as negative amount) is included because its status is 'CO'
Steps To ReproduceGenerate a sales invoice.
Complete it.
Void it.

Create a Tax register type (Financial Managemnt > Receivables and Payables > Setup). In lines, select the tax used in the invoice.

Create a new Tax Payment (Financial Managemnt > Receivables and Payables > Transactions). Select any GL item.

Press Create VAT register.
Proposed SolutionAppsOpenbravo/src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegister_data.xsql:

Delete:

and C_Invoice.DocStatus in ('CO','CL')
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0009710 closed harikrishnan Create VAT register process does not include the original invoice when this one is cancelled. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-29 19:29psarobeTypedefect => backport
2009-06-29 19:29psarobefix_in_branch => 2.40
2009-07-03 11:02rafarodaAssigned Torafaroda => harikrishnan
2009-07-06 14:27hgbotCheckin
2009-07-06 14:27hgbotNote Added: 0017942
2009-07-06 14:27hgbotStatusscheduled => resolved
2009-07-06 14:27hgbotResolutionopen => fixed
2009-07-06 14:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/5de1ecd7f61055e1888ea58a07d0892eeb616e48 [^]
2009-07-10 11:31arunkumarStatusresolved => closed
2009-07-10 11:31arunkumarNote Added: 0018089
2009-07-10 11:31arunkumarFixed in Version => 2.40MP7

Notes
(0017942)
hgbot   
2009-07-06 14:27   
Repository: erp/stable/2.40
Changeset: 5de1ecd7f61055e1888ea58a07d0892eeb616e48
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Mon Jul 06 17:50:07 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/5de1ecd7f61055e1888ea58a07d0892eeb616e48 [^]

Fixes Issue 9711: Create VAT register process does not include the original invoice when this one is cancelled.

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters_data.xsql
---
(0018089)
arunkumar   
2009-07-10 11:31   
I am able to see the TaxRegisterHeader in the Tax Payment.