Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010225Openbravo ERP09. Financial managementpublic2009-08-10 13:302009-10-08 00:00
sureshbabu 
harikrishnan 
highmajoralways
closedfixed 
5
pi 
2.50MP7 
Core
No
0010225: In active tax registers are considered while processing Tax Payment
In active tax registers are considered while processing Tax Payment

Steps to reproduce this issue.

1)Create Tax Register Type with following values.
(Financial Management || Receivables & Payables || Setup || Tax Register Type)
    Header:

    1. Uncheck the Active check Box and select Organization as A
    2.Sales Transaction='Yes'.


    Lines:
    1.Tax ='VAT 16%-VAT 16%'
    2.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="A"
    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.

Move to Tax Register Header, you will find the above created inactive Tax Register is wrongly added in the list.




No tags attached.
Issue History
2009-08-10 13:30sureshbabuNew Issue
2009-08-10 13:30sureshbabuAssigned To => rafaroda
2009-08-19 07:27rafarodaAssigned Torafaroda => harikrishnan
2009-08-19 07:27rafarodaStatusnew => scheduled
2009-09-29 07:21harikrishnanNote Added: 0020422
2009-09-29 09:12sureshbabuNote Added: 0020425
2009-09-29 09:52hgbotCheckin
2009-09-29 09:52hgbotNote Added: 0020426
2009-09-29 09:52hgbotStatusscheduled => resolved
2009-09-29 09:52hgbotResolutionopen => fixed
2009-09-29 09:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/983823e1add148b8774cc1065fe3b099af5548e6 [^]
2009-09-29 14:19hgbotCheckin
2009-09-29 14:19hgbotNote Added: 0020524
2009-09-29 14:19hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/983823e1add148b8774cc1065fe3b099af5548e6 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/983823e1add148b8774cc1065fe3b099af5548e6 [^]
2009-10-07 08:12sureshbabuStatusresolved => closed
2009-10-07 08:12sureshbabuNote Added: 0020807
2009-10-07 08:12sureshbabuFixed in Version => 2.50MP7
2009-10-08 00:00anonymoussf_bug_id0 => 2874363

Notes
(0020422)
harikrishnan   
2009-09-29 07:21   
If we follow the above steps to reproduce, the things are doing correctly.If we make Tax Register Type as "Inactive" ,its not selected in the Tax Payment.The bug arises in the Lines of the Tax Register Type.I have given steps to reproduce the issue below.

1)Create Tax Register Type with following values.
(Financial Management || Receivables & Payables || Setup || Tax Register Type)
    Header:

    
    1.Sales Transaction='Yes'.


    Create two Lines:
        Line 1:
            1.Tax ='VAT 16%-VAT 16%'
            2.Document Type ='AR Invoice'
            3.Active='Y'
        Line 2:
            1.Tax ='VAT 16%-VAT 16%'
            2.Document Type ='AR Invoice Indirect'
            3.Active='N'

    Save the record.



2)Create two Sales Invoice With following values.
(Sales Management || Transactions || Sales Invoice ||)
  SalesInvoice 1:

          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.

 Salesinvoice 2:
        Header:
            1.Organization ='A'
            2.Transaction Document ='AR Invoice Indirect'
            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="A"
    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.

If you look into line generated inside the "Tax Register Header",both the sales invoice are pulled.Since the invoice with "Transaction Document = AR Invoice Indirect" should not be present,because we created a Tax Register Type line (Tax Register Type : Line 2:) with inactive status.

Suresh can you add comment to this note.
(0020425)
sureshbabu   
2009-09-29 09:12   
Hari, while creating tax register inactivate the line items instead of the header.(yes you are right)

please follow the steps to create a register type to reproduce the issue.


Create Tax Register Type with following values.
(Financial Management || Receivables & Payables || Setup || Tax Register Type)
    Header:

    1. select Organization as A
    2.Sales Transaction='Yes'.


    Lines:
    1.Tax ='VAT 16%-VAT 16%'
    2.Document Type ='AR Invoice' and Uncheck the Active check Box
    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="A"
    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.

Move to Tax Register Header, you will find the above created inactive Tax Register is wrongly added in the list.
(0020426)
hgbot   
2009-09-29 09:52   
Repository: erp/devel/pi
Changeset: 983823e1add148b8774cc1065fe3b099af5548e6
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Tue Sep 29 13:22:00 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/983823e1add148b8774cc1065fe3b099af5548e6 [^]

Fixes Issue 10225: In active tax registers are considered while processing Tax Payment

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters_data.xsql
---
(0020524)
hgbot   
2009-09-29 14:19   
Repository: erp/devel/pi-pageddatagrid
Changeset: 983823e1add148b8774cc1065fe3b099af5548e6
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Tue Sep 29 13:22:00 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/983823e1add148b8774cc1065fe3b099af5548e6 [^]

Fixes Issue 10225: In active tax registers are considered while processing Tax Payment

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateVatRegisters_data.xsql
---
(0020807)
sureshbabu   
2009-10-07 08:12   
Tested working fine