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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009711
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2009-06-29 18:202009-07-10 11:31
ReporternetworkbView Statuspublic 
Assigned Toharikrishnan 
PriorityimmediateResolutionfixedFixed in Version2.40MP7
StatusclosedFix in branch2.40Fixed in SCM revision5de1ecd7f610
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

0009711: 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 ]
blocks defect 0009710 closedharikrishnan Create VAT register process does not include the original invoice when this one is cancelled. 

-  Notes
(0017942)
hgbot (developer)
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 (reporter)
2009-07-10 11:31

I am able to see the TaxRegisterHeader in the Tax Payment.

- Issue History
Date Modified Username Field Change
2009-06-29 19:29 psarobe Type defect => backport
2009-06-29 19:29 psarobe fix_in_branch => 2.40
2009-07-03 11:02 rafaroda Assigned To rafaroda => harikrishnan
2009-07-06 14:27 hgbot Checkin
2009-07-06 14:27 hgbot Note Added: 0017942
2009-07-06 14:27 hgbot Status scheduled => resolved
2009-07-06 14:27 hgbot Resolution open => fixed
2009-07-06 14:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/5de1ecd7f61055e1888ea58a07d0892eeb616e48 [^]
2009-07-10 11:31 arunkumar Status resolved => closed
2009-07-10 11:31 arunkumar Note Added: 0018089
2009-07-10 11:31 arunkumar Fixed in Version => 2.40MP7


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker