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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011706
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 03. Procurement managementmajoralways2009-12-02 17:092010-01-27 12:44
ReporternetworkbView Statuspublic 
Assigned Togorkaion 
PriorityhighResolutionfixedFixed in Version2.40MP12
StatusclosedFix in branch2.40Fixed in SCM revision188c8617c39f
ProjectionnoneETAnoneTarget Version2.40MP12
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP11SCM revision 
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
Summary

0011706: the price adjustment isn't correct if in the price adustment includes a Price List

DescriptionWhen create an order using 'Requisition to order' the price adjustment isn't correct if in the price adjustment includes a Price List
Steps To Reproduce-As Openbravo Admin go to Master Data Management || Pricing || Price Adjustments || Adjustments
-Create a new record:
    -Starting Date: 01-01-2009
    -Discount %: 10.
    -Include Price Lists: All selected
    -Included Business Partners: All selected
-Save and go to Adjustments >> Business Partner
    -BP: McGiver Supplies
-Save and go to Adjustments >> Price List
-Create a new record:
    -Price List: Purchase
-Save

-Go to Procurement Management || Transactions || Requisition
-Create a new record:
    -BP: McGiver Supplies
    -Price List: Purchase
-Save and go to Lines, create a new record
    -Product: Hammer
    -Need by date: 25-11-2009
    -Quantity: 20
-Save and go back to the Header, Complete

-Go to Procurement Management || Transactions || Requisition To Order
-Select the requisition created, and add
-Created

-Go to Procurement Management || Transactions || Purchase Order
-Select the ordered created.
-Go to Price Adjustement
Proposed SolutionReview both:
* 'Requisition to order' process
* 'Create Purchase Order' process inside Procurement Management || Transactions || Manage Requisitions || Header

They have to take into account Price Adjustments when creating purchase orders.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to backport 0011765 closedgorkaion Error when Create Purchase Order from a Requisition 
blocks defect 00116182.40MP12 closedgorkaion the price adjustment isn't correct if in the price adustment includes a Price List 

-  Notes
(0022758)
hgbot (developer)
2009-12-14 16:04

 Repository: erp/stable/2.40
Changeset: 188c8617c39ff8dba13cdc1d49e96b1c9fcbc6d5
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Mon Dec 14 14:49:51 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/188c8617c39ff8dba13cdc1d49e96b1c9fcbc6d5 [^]

Fixes issue 0011706 Fixes issue 0011765 Price adjustments fixed in requisitions to orders

---
M src-db/database/model/functions/M_REQUISITION_CREATEPO.xml
M src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder.java
M src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
---
(0022760)
rafaroda (viewer)
2009-12-14 16:06
edited on: 2010-01-08 17:39

 Steps to test this fix:
1) Create a Price Adjustment in Master Data Management || Pricing || Price Adjustments || Adjustments
* Name = Price Adjustment 40% off in all products for McGiver Supplies and Price List Purchase
* Starting Date = 01-01-2000
* Discount% = 40%
* Included Business Partners = All Selected
* Included Price Lists = All Selected
2) Navigate to Business Partner tab:
* Business Partner = McGiver Supplies
3) Navigate to Price List tab:
* Price List = Purchase
4) Create a new requisition in Procurement Management || Transactions || Requisition || Header
* Business Partner = McGiver Supplies
5) Navigate to Lines and create a new record:
* Product = Hammer
* Business Partner = Turtle Logistics
* Price List = Purchase
* Quantity = 65
* Unit Price = blank
* List Price = blank
* Discount = blank
6) Create a new record:
* Product = Hammer
* Price List = Purchase
* Quantity = 15
* Unit Price = 4.50
* List Price = 5.00
* Discount = 10%
7) Create a new record:
* Product = Hammer
* Price List = Purchase
* Quantity = 37
* Unit Price = blank
* List Price = blank
* Discount = blank
8) Navigate back to the requisition header and Complete it.
9) Navigate to Procurement Management || Transactions || Requisition To Order || Requisition To Order and Add the 3 former lines.
10) Set Price = 4.25 to line with Quantity = 65
11) Select all the lines, click on Create button, select McGiver Supplies as business partner (you have to select the business partner since the lines are for different vendors) and click on OK.
12) Navigate to the Purchase Order created.
13) Navigate to lines tab and check that:
* One line with Product = Hammer
** Quantity = 52 (37+15)
** Unit Price = 2.7 (Standard Price - Price Adjustment)
** Standard Price = 4.5
** Price Adjustment = 1.8 (Standard Price*40% = 4.5*40%)
** List Price = 5
** Discount = 10% ((List Price - Standard Price)*100/List Price)
* A second line with Product = Hammer
** Quantity = 65
** Unit Price = 2.55 (Standard Price - Price Adjustment)
** Standard Price = 4.25
** Price Adjustment = 1.7 (Standard Price*50% = 4.25*40%)
** List Price = 5
** Discount = 15% ((List Price - Standard Price)*100/List Price

See prices relations at https://issues.openbravo.com/view.php?id=8275 [^]
(0023043)
gorkaion (viewer)
2009-12-23 19:27

 fixed with changeset:
https://code.openbravo.com/erp/stable/2.40/rev/97563fbb3cff [^]
(0023823)
arunkumar (viewer)
2010-01-27 12:44

 Tested & Working fine

- Issue History
Date Modified Username Field Change
2009-12-09 13:04 rafaroda Type defect => backport
2009-12-09 13:04 rafaroda fix_in_branch => 2.40
2009-12-14 12:50 rafaroda Relationship added related to 0011765
2009-12-14 16:04 hgbot Checkin
2009-12-14 16:04 hgbot Note Added: 0022758
2009-12-14 16:04 hgbot Status scheduled => resolved
2009-12-14 16:04 hgbot Resolution open => fixed
2009-12-14 16:04 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/188c8617c39ff8dba13cdc1d49e96b1c9fcbc6d5 [^]
2009-12-14 16:06 rafaroda Note Added: 0022760
2009-12-14 16:21 rafaroda Note Edited: 0022760
2009-12-23 19:20 gorkaion Assigned To rafaroda => gorkaion
2009-12-23 19:20 gorkaion Status resolved => new
2009-12-23 19:20 gorkaion Resolution fixed => open
2009-12-23 19:20 gorkaion Status new => scheduled
2009-12-23 19:20 gorkaion fix_in_branch 2.40 => pi
2009-12-23 19:21 gorkaion fix_in_branch pi => 2.40
2009-12-23 19:25 gorkaion Status scheduled => resolved
2009-12-23 19:25 gorkaion Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/188c8617c39ff8dba13cdc1d49e96b1c9fcbc6d5 [^] => https://code.openbravo.com/erp/stable/2.40/rev/188c8617c39f [^]
2009-12-23 19:25 gorkaion Resolution open => fixed
2009-12-23 19:27 gorkaion Note Added: 0023043
2010-01-08 17:39 rafaroda Note Edited: 0022760
2010-01-27 12:44 arunkumar Note Added: 0023823
2010-01-27 12:44 arunkumar Status resolved => closed
2010-01-27 12:44 arunkumar Fixed in Version => 2.40MP12

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker