Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009710
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-06-29 18:202009-07-18 00:00
ReporternetworkbView Statuspublic 
Assigned Toharikrishnan 
PriorityimmediateResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revision2f7de92f832e
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP3SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009710: 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')
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0009711 closedharikrishnan Create VAT register process does not include the original invoice when this one is cancelled. 

-  Notes
(0017943)
hgbot (developer)
2009-07-06 14:29

Repository: erp/devel/pi
Changeset: 2f7de92f832eda29ca6d250b6c95ed0733485ba6
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Mon Jul 06 17:52:43 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/2f7de92f832eda29ca6d250b6c95ed0733485ba6 [^]

Fixes Issue 9710: 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
---
(0018367)
sureshbabu (reporter)
2009-07-17 14:22

Tested working fine

- Issue History
Date Modified Username Field Change
2009-06-29 18:20 networkb New Issue
2009-06-29 18:20 networkb Assigned To => rafaroda
2009-06-29 19:29 psarobe Status new => scheduled
2009-06-29 19:29 psarobe Assigned To rafaroda => sathiyan
2009-06-29 19:29 psarobe fix_in_branch => pi
2009-07-01 12:28 sathiyan Assigned To sathiyan => harikrishnan
2009-07-06 14:29 hgbot Checkin
2009-07-06 14:29 hgbot Note Added: 0017943
2009-07-06 14:29 hgbot Status scheduled => resolved
2009-07-06 14:29 hgbot Resolution open => fixed
2009-07-06 14:29 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2f7de92f832eda29ca6d250b6c95ed0733485ba6 [^]
2009-07-17 14:22 sureshbabu Status resolved => closed
2009-07-17 14:22 sureshbabu Note Added: 0018367
2009-07-17 14:22 sureshbabu Fixed in Version => pi
2009-07-18 00:00 anonymous sf_bug_id 0 => 2823350


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker