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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0007245
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 08. Project and service managementminorhave not tried2009-01-29 19:202009-04-22 16:30
ReporterplujanView Statuspublic 
Assigned ToAinhoaPagola 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchpiFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision12283 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007245: If I do not choose a tax in Project Line, when generating purchase order a wrong tax is inserted

DescriptionI create a Service Project with a line for a product. On the line, I do not choose a tax. Then, I create a Supplier and I generate a Purchase Order. The order line has **VAT 3% as tax, but this is wrong. See attach
Steps To Reproduce# Go to Project & Service Management->Transactions->Service Project
# Click New and fill:
    * Search Key: sca
    * Name: Service Project for Customer A
    * Create Temporary Price List: N (un-checked)
# Move to Project Line tab.
# Click New and fill:
    * Product: A Final goods
    * Planned Quantity: 10
    * Tax: Do not select a tab (is not a mandatory field)
    * Planned Price: 1.75 and verify Planned Amount is 17.5
    * Planned Purchase Price: 1.2
# Go back to Service Project tab.
# Select Service Project for Customer A and edit:
    * Business Partner: CUSTOMER A
    * Sales Representative: Eduard
# Save and click on Change Project Status button and select Order.
# Verify that:
    * Project Status is Order.
    * Price List is CUSTOMER A.
# Move to Supplier tab.
# Click New and fill:
    * Business partner: Vendor A
# Verify that Price List is PURCHASE.
# Save and click on Create Purchase Order from Project.
# Move back to Service Project tab and navigate through Linked Items to the Purchase Order created.
# Move to Lines tab.
# Select A Final goods line and check that Tax is "**VAT 3%"

TagsQA_review_pre_beta
Attached Filespng file icon BUG_250_trunk_WrongTaxes.PNG [^] (68,098 bytes) 2009-01-29 19:20

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0007332 closedAinhoaPagola If I do not choose a tax in Project Line, when generating purchase order a wrong tax is inserted 

-  Notes
(0014627)
Olya (reporter)
2009-03-13 10:15

 OB chooses tax based on the tax category of the product used, if user didn’t choose the tax in the Service Project. Tax category can contain one or more taxes. OB makes decision using the following sequence:
1. Get Tax from project.
2. Get ANY Tax from Tax category of the product in the project including local taxes and product destination location taxes excluding taxes with parents.
3. Get ANY Tax from Tax category of the product in the project including local taxes excluding taxes with parents.
4. Get ANY tax of the tax category.
ANY – means the first in the record set.
Two stars in tax dropdown are concatenated to the name of the category if the following query doesn’t contain the tax
SELECT td0.c_tax_id AS id,
         (Coalesce(To_char((CASE
                              WHEN td_trl1.name IS NULL THEN To_char(td0.name)
                              ELSE To_char(td_trl1.name)
                            END)),'')) AS name,
         '' AS DESCRIPTION
FROM c_tax td0
         LEFT JOIN c_tax_trl td_trl1
           ON td0.c_tax_id = td_trl1.c_tax_id
              AND td_trl1.ad_language = 'en_US'
WHERE td0.ad_client_id IN ('0','1000000')
         AND td0.ad_org_id IN ('1000000','1000002','1000003','1000004', '1000005','1000006','1000008','1000009', '1000007','0')
         AND td0.parent_tax_id IS NULL
         AND (td0.isactive = 'Y' OR td0.c_tax_id = ('1000000'))
ORDER BY 2

Usage of p_product_id as the function c_gettax parameter eliminates the taxes of the wrong client and organization.
It's obvious that if tax has parent tax it will not be selected. Parent tax can be denoted by user in any time.
Two stars are displayed when all taxes in the tax category have a parent.

Please see if all taxes in categories tested have a parent.
If so we believe this bug should be closed.
(0014658)
rafaroda (developer)
2009-03-16 11:08

 Reminder sent to: plujan

Pablo,

Could you please have a look on this issue to see whether it was a data problem?

Thanks.

- Issue History
Date Modified Username Field Change
2009-01-29 19:20 plujan New Issue
2009-01-29 19:20 plujan Assigned To => rafaroda
2009-01-29 19:20 plujan sf_bug_id 0 => 2546203
2009-01-29 19:20 plujan File Added: BUG_250_trunk_WrongTaxes.PNG
2009-01-29 19:20 plujan Regression testing => No
2009-02-03 10:21 psarobe Tag Attached: QA_review_pre_beta
2009-02-03 10:26 psarobe Status new => scheduled
2009-02-03 10:26 psarobe Assigned To rafaroda => AinhoaPagola
2009-02-03 10:26 psarobe fix_in_branch => trunk
2009-03-04 10:26 AinhoaPagola Assigned To AinhoaPagola => Olya
2009-03-13 10:15 Olya Note Added: 0014627
2009-03-13 10:15 Olya Status scheduled => feedback
2009-03-16 11:08 rafaroda Note Added: 0014658
2009-03-24 11:09 AinhoaPagola Assigned To Olya => AinhoaPagola
2009-04-22 16:30 psarobe Status feedback => closed
2009-04-22 16:30 psarobe Resolution open => no change required

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker