Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009899Openbravo ERP09. Financial managementpublic2009-07-14 18:402009-08-11 00:00
Reporternetworkb 
Assigned Toharikrishnan 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP6 
Target Version2.50MP4Fixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009899: Create VAT Register process does not filter by organization
DescriptionThis process (located in Financial management > Receivables & Payables > Tax Payment) does not filter by organization.

I mean, if a new record is created in this window with X organization, this process does not filter by this organization, and calculates VAT for all invoices that are included in the dates and Tax Register.

The process must filter by X organization, and in case of parent organization, its childs.
Steps To ReproduceGo to Financial management > Receivables and Payables > Tax payment.
Launch "Create VAT register".
Generated lines belong to the same entity but not to the same organization.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00099522.40MP8 closed harikrishnan Create VAT Register process does not filter by organization 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-14 18:40networkbNew Issue
2009-07-14 18:40networkbAssigned To => rafaroda
2009-07-19 16:33psarobeStatusnew => scheduled
2009-07-19 16:33psarobefix_in_branch => pi
2009-07-20 09:03rafarodaAssigned Torafaroda => sathiyan
2009-07-22 06:49sathiyanAssigned Tosathiyan => harikrishnan
2009-07-28 06:52pjuvaraTarget Version => 2.50MP4
2009-07-31 07:15harikrishnanNote Added: 0018739
2009-07-31 09:23hgbotCheckin
2009-07-31 09:23hgbotNote Added: 0018748
2009-07-31 09:23hgbotStatusscheduled => resolved
2009-07-31 09:23hgbotResolutionopen => fixed
2009-07-31 09:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9069826ec104b858afc5242a43fc17c20dbd588e [^]
2009-08-07 11:55sureshbabuStatusresolved => new
2009-08-07 11:55sureshbabuResolutionfixed => open
2009-08-07 11:55sureshbabuNote Added: 0018876
2009-08-07 13:39hgbotCheckin
2009-08-07 13:39hgbotNote Added: 0018878
2009-08-07 13:39hgbotStatusnew => resolved
2009-08-07 13:39hgbotResolutionopen => fixed
2009-08-07 13:39hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/9069826ec104b858afc5242a43fc17c20dbd588e [^] => http://code.openbravo.com/erp/devel/pi/rev/dbf5d9493bc4586a0a366bd3f28937b435612e7f [^]
2009-08-10 13:24sureshbabuStatusresolved => closed
2009-08-10 13:24sureshbabuNote Added: 0018896
2009-08-10 13:24sureshbabuFixed in Version => pi
2009-08-11 00:00anonymoussf_bug_id0 => 2835191

Notes
(0018739)
harikrishnan   
2009-07-31 07:15   
Steps to reproduce this issue.

1)Create Tax Register Type with following values.
(Financial Management || Receivables & Payables || Setup || Tax Register Type)
    Header:
    1.Sales Transaction='Yes'.
    Lines:
    2.Tax ='VAT 16%-VAT 16%'
    3.Document Type ='AR Invoice'

    Save the record.

2)Create Sales Invoice With following values.
(Sales Management || Transactions || Sales Invoice ||)
    Header:
    1.Organization ='A'
    2.Transaction Document ='AR Invoice'
    3.Business Partner ='Example :Bellen Ent.'
    4.Tax Date ='Any date eg.('31-07-2009')'
    Lines:
    1.Product='Eg :Hammer'
    2.Tax ='VAT 16%'
    Complete the transaction.

3)Create Tax Payment with the following values.
(Financial Management || Receivables & Payables || Transactions || Tax Payment)
    Header:
    1.Organization="B"
    2.Business Partner="the name selected in the sale invoice eg:'Bellen Ent.'"
    3.Starting Date="date before the Tax date given in the sale invoice created.Eg '30-07-2009'"
    4.Ending Date ="date after the Tax date given in the sale invoice created.Eg '01-08-2009'"
    Click the Create Vat Register Button.

Since the above created sales invoice shouldn't come under this Tax payment,because the tax payment is created for organization 'B' ,but it pulling the records from the organization 'A'.This is the reason ticket is raised.
(0018748)
hgbot   
2009-07-31 09:23   
Repository: erp/devel/pi
Changeset: 9069826ec104b858afc5242a43fc17c20dbd588e
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Fri Jul 31 12:45:28 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/9069826ec104b858afc5242a43fc17c20dbd588e [^]

Fixed Issue 9899: Create VAT Register process does not filter by organization

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters.java
M src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters_data.xsql
---
(0018876)
sureshbabu   
2009-08-07 11:55   
Hi Hari,

In Tax Payment in the header after we enter all the required details, when we click the button Create VAT Register the system should select the Tax registers registered only for the current organization and its child organization selected in the Header

Let me know if you need more details.

Thanks
suresh.
(0018878)
hgbot   
2009-08-07 13:39   
Repository: erp/devel/pi
Changeset: dbf5d9493bc4586a0a366bd3f28937b435612e7f
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Fri Aug 07 17:08:08 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/dbf5d9493bc4586a0a366bd3f28937b435612e7f [^]

Fixes Issue 9899: Create VAT Register process does not filter by organization

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters.java
M src/org/openbravo/erpCommon/ad_actionButton/TaxRegisterType.xsql
---
(0018896)
sureshbabu   
2009-08-10 13:24   
Tested working fine