Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009952Openbravo ERP09. Financial managementpublic2009-07-14 18:402009-08-10 08:21
Reporternetworkb 
Assigned Toharikrishnan 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP6 
Target Version2.40MP8Fixed in Version2.40MP8 
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
Summary0009952: 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
blocks defect 00098992.50MP4 closed harikrishnan Create VAT Register process does not filter by organization 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-19 16:33psarobeTypedefect => backport
2009-07-19 16:33psarobefix_in_branch => 2.40
2009-07-20 09:03rafarodaAssigned Torafaroda => sathiyan
2009-07-22 06:48sathiyanAssigned Tosathiyan => networkb
2009-07-22 06:49sathiyanAssigned Tonetworkb => harikrishnan
2009-07-28 06:52pjuvaraTarget Version => 2.50MP4
2009-07-31 09:05harikrishnanNote Added: 0018745
2009-07-31 09:14hgbotCheckin
2009-07-31 09:14hgbotNote Added: 0018746
2009-07-31 09:14hgbotStatusscheduled => resolved
2009-07-31 09:14hgbotResolutionopen => fixed
2009-07-31 09:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/c13b25beeccc26ffdc324caee57ceabf2f8302de [^]
2009-08-07 11:49sureshbabuStatusresolved => new
2009-08-07 11:49sureshbabuResolutionfixed => open
2009-08-07 11:49sureshbabuNote Added: 0018875
2009-08-07 11:50sureshbabuETAnone => < 1 day
2009-08-07 11:50sureshbabuTarget Version2.50MP4 => 2.40MP8
2009-08-07 13:32hgbotCheckin
2009-08-07 13:32hgbotNote Added: 0018877
2009-08-07 13:32hgbotStatusnew => resolved
2009-08-07 13:32hgbotResolutionopen => fixed
2009-08-07 13:32hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/c13b25beeccc26ffdc324caee57ceabf2f8302de [^] => http://code.openbravo.com/erp/stable/2.40/rev/fb24afb7ecc13866d4ab7613987ea57cf024099f [^]
2009-08-10 08:21sureshbabuStatusresolved => closed
2009-08-10 08:21sureshbabuNote Added: 0018885
2009-08-10 08:21sureshbabuFixed in Version => 2.40MP8

Notes
(0018745)
harikrishnan   
2009-07-31 09:05   
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.
(0018746)
hgbot   
2009-07-31 09:14   
Repository: erp/stable/2.40
Changeset: c13b25beeccc26ffdc324caee57ceabf2f8302de
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Fri Jul 31 12:36:28 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/c13b25beeccc26ffdc324caee57ceabf2f8302de [^]

Issue Fixed 9952: 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
---
(0018875)
sureshbabu   
2009-08-07 11:49   
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.
(0018877)
hgbot   
2009-08-07 13:32   
Repository: erp/stable/2.40
Changeset: fb24afb7ecc13866d4ab7613987ea57cf024099f
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Fri Aug 07 17:00:56 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/fb24afb7ecc13866d4ab7613987ea57cf024099f [^]

Fixes Issue 9952: 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
---
(0018885)
sureshbabu   
2009-08-10 08:21   
Tested working fine