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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0032134
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 06. Material requirement planning (MRP)majoralways2016-02-04 18:002016-03-17 10:56
ReporterVictorVillarView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionc9d6308592b2
ProjectionnoneETAnoneTarget Version3.0PR16Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0032134: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0032136 closedAtulOpenbravo Wrong warehouse combo validation in the 'Create Purchase Orders popup in the Purchasing Plan window 
related to defect 0035428 closedaferraz Do not calculate Net Price and Net Amount outside triggers when creating new Order/Invoice with Price Including Taxes 

-  Notes
(0084022)
AtulOpenbravo (developer)
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 (manager)
2016-02-11 14:47

 Issue Verified.
(0084110)
psanjuan (manager)
2016-02-11 15:02

 Test plan above verified.

Issue can be code reviewed and closed.
(0084259)
hgbot (developer)
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 (developer)
2016-02-16 16:33

 Code Review + Testing Ok
(0085144)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2016-02-04 18:00 VictorVillar New Issue
2016-02-04 18:00 VictorVillar Assigned To => Triage Finance
2016-02-04 18:00 VictorVillar Modules => Core
2016-02-04 18:00 VictorVillar Resolution time => 1456786800
2016-02-04 18:00 VictorVillar Triggers an Emergency Pack => No
2016-02-04 18:00 VictorVillar Issue Monitored: networkb
2016-02-04 18:09 VictorVillar Relationship added related to 0032136
2016-02-08 15:55 AtulOpenbravo Assigned To Triage Finance => AtulOpenbravo
2016-02-09 06:39 AtulOpenbravo Status new => scheduled
2016-02-09 06:41 AtulOpenbravo Note Added: 0084022
2016-02-11 14:47 psanjuan Note Added: 0084109
2016-02-11 14:50 psanjuan Note Edited: 0084022 View Revisions
2016-02-11 14:51 psanjuan Note Edited: 0084022 View Revisions
2016-02-11 14:55 psanjuan Note Edited: 0084022 View Revisions
2016-02-11 15:01 psanjuan Note Edited: 0084022 View Revisions
2016-02-11 15:02 psanjuan Note Added: 0084110
2016-02-16 13:45 psanjuan Note Edited: 0084022 View Revisions
2016-02-16 13:48 psanjuan Note Edited: 0084022 View Revisions
2016-02-16 13:48 psanjuan Note Edited: 0084022 View Revisions
2016-02-16 16:33 hgbot Checkin
2016-02-16 16:33 hgbot Note Added: 0084259
2016-02-16 16:33 hgbot Status scheduled => resolved
2016-02-16 16:33 hgbot Resolution open => fixed
2016-02-16 16:33 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c9d6308592b2edb79b8ce64aa6220d64bd2af3c5 [^]
2016-02-16 16:33 dmiguelez Review Assigned To => dmiguelez
2016-02-16 16:33 dmiguelez Note Added: 0084262
2016-02-16 16:33 dmiguelez Status resolved => closed
2016-03-17 10:56 hudsonbot Checkin
2016-03-17 10:56 hudsonbot Note Added: 0085144
2017-03-06 18:45 aferraz Relationship added related to 0035428

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker