Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032134Openbravo ERP06. Material requirement planning (MRP)public2016-02-04 18:002016-03-17 10:56
ReporterVictorVillar 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR16Q2Fixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032134: Price Including taxes is not supported by the Purchasing Plan (Create Purchase Orders process)
DescriptionPrice Including taxes is not supported by the Purchasing Plan (Create Purchase Orders process)
Steps To ReproduceAs group admin role,
   create a new product and follow the next wiki link [1: For the products that are planned in the Purchasing Plan
[1] http://wiki.openbravo.com/wiki/Material_Requirement_(MRP)#Configuration [^]
Add the Purchase Price list defined as Price Including taxes.
The planning method should add every possibility.

Create a new Sales Order for this product.
Go to Purchasing Plan: Time horizon:20
  launch it.
realise that you have lines in the Purchasing Plan. One of them is Suggested Purchase Order.
After that Create the Purchase Orders.

Go to the purchase order window and process it.and realise that the Total Gross Amount in the header is 0.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0032136 closed AtulOpenbravo Wrong warehouse combo validation in the 'Create Purchase Orders popup in the Purchasing Plan window 
related to defect 0035428 closed aferraz Do not calculate Net Price and Net Amount outside triggers when creating new Order/Invoice with Price Including Taxes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-02-04 18:00VictorVillarNew Issue
2016-02-04 18:00VictorVillarAssigned To => Triage Finance
2016-02-04 18:00VictorVillarModules => Core
2016-02-04 18:00VictorVillarResolution time => 1456786800
2016-02-04 18:00VictorVillarTriggers an Emergency Pack => No
2016-02-04 18:00VictorVillarIssue Monitored: networkb
2016-02-04 18:09VictorVillarRelationship addedrelated to 0032136
2016-02-08 15:55AtulOpenbravoAssigned ToTriage Finance => AtulOpenbravo
2016-02-09 06:39AtulOpenbravoStatusnew => scheduled
2016-02-09 06:41AtulOpenbravoNote Added: 0084022
2016-02-11 14:47psanjuanNote Added: 0084109
2016-02-11 14:50psanjuanNote Edited: 0084022bug_revision_view_page.php?bugnote_id=0084022#r11072
2016-02-11 14:51psanjuanNote Edited: 0084022bug_revision_view_page.php?bugnote_id=0084022#r11073
2016-02-11 14:55psanjuanNote Edited: 0084022bug_revision_view_page.php?bugnote_id=0084022#r11074
2016-02-11 15:01psanjuanNote Edited: 0084022bug_revision_view_page.php?bugnote_id=0084022#r11075
2016-02-11 15:02psanjuanNote Added: 0084110
2016-02-16 13:45psanjuanNote Edited: 0084022bug_revision_view_page.php?bugnote_id=0084022#r11141
2016-02-16 13:48psanjuanNote Edited: 0084022bug_revision_view_page.php?bugnote_id=0084022#r11142
2016-02-16 13:48psanjuanNote Edited: 0084022bug_revision_view_page.php?bugnote_id=0084022#r11143
2016-02-16 16:33hgbotCheckin
2016-02-16 16:33hgbotNote Added: 0084259
2016-02-16 16:33hgbotStatusscheduled => resolved
2016-02-16 16:33hgbotResolutionopen => fixed
2016-02-16 16:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c9d6308592b2edb79b8ce64aa6220d64bd2af3c5 [^]
2016-02-16 16:33dmiguelezReview Assigned To => dmiguelez
2016-02-16 16:33dmiguelezNote Added: 0084262
2016-02-16 16:33dmiguelezStatusresolved => closed
2016-03-17 10:56hudsonbotCheckin
2016-03-17 10:56hudsonbotNote Added: 0085144
2017-03-06 18:45aferrazRelationship addedrelated to 0035428

Notes
(0084022)
AtulOpenbravo   
2016-02-09 06:41   
(edited on: 2016-02-16 13:48)
Test Plan
- Login as F&B International Group Admin Role.
- Create a new product and follow the next wiki link [1: For the products that are planned in the Purchasing Plan
[1] http://wiki.openbravo.com/wiki/Material_Requirement_(MRP)#Configuration [^] [^]
- Add the Purchase Price list defined as Price Including taxes.
- Add a purchase price of 100.00.
- A 21% VAT will imply a unit price = 100.00/1.21 = 82.64
- The planning method should add every possibility, that means a record needs to be created for each transaction type.

- Create a new Sales Order for this product of 100 units.
- Go to Purchasing Plan and create a new one with a Time horizon:20
- Launch it.
- Check that you have lines in the Purchasing Plan. One of them is Suggested Purchase Order.
- After that Create the Purchase Orders.

- Go to the purchase order window and process it.
- Check that the Total Gross Amount in header is properly calculated because Net unit Price shown is 82.64 x 100 units = 8264.00 (total net amount) ; total Gross amount 100 units x 100.00 = 10.000

Repeat same test as above but creating a sales order for 150 units and setting Purchase Price List NOT as Price Including Taxes.

Once done, check that the Total Gross Amount in header is properly calculated:
Total Net Amount = 15.000 (150 units x 150.00)
Total Gross Amount = 18.150 (15.000 X 21% VAT)
(0084109)
psanjuan   
2016-02-11 14:47   
Issue Verified.
(0084110)
psanjuan   
2016-02-11 15:02   
Test plan above verified.

Issue can be code reviewed and closed.
(0084259)
hgbot   
2016-02-16 16:33   
Repository: erp/devel/pi
Changeset: c9d6308592b2edb79b8ce64aa6220d64bd2af3c5
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Feb 09 10:55:14 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/c9d6308592b2edb79b8ce64aa6220d64bd2af3c5 [^]

Fixes Issue 32134:Price Including taxes is not supported by the Purchasing
Plan (Create Purchase Orders process)

---
M src-db/database/model/functions/MRP_PURCHASEORDER.xml
---
(0084262)
dmiguelez   
2016-02-16 16:33   
Code Review + Testing Ok
(0085144)
hudsonbot   
2016-03-17 10:56   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b22fb0500156 [^]
Maturity status: Test