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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013959
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 06. Material requirement planning (MRP)majoralways2010-07-14 18:162010-07-27 15:41
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisiond24e1139ded8
ProjectionnoneETAnoneTarget Version2.50MP21
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP19SCM 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

0013959: Error "division by zero" when processing Purchasing Plan

DescriptionWhen trying to process a Purchasing Plan with a product with capacity=0 and not enough stock of this product, you get error "division by zero".
Treatment of this error should be done at least to indicate the product which is experiencing the problem and the reason.
Maybe could be something like:
"Product XXX has capacity 0. Please set a proper capacity and run the process again"
Steps To Reproduce1.Material Requirement (MRP) || Setup || Planning Method || Header: create record. Go lines and create record:
  transaction type=pending sales order
  Weighting=1
2. Material Requirement (MRP) || Setup || Planner: create record
3. Master Data Management || Product || Product >> Purchasing : search for "Beer" product and set capacity=0
4. Master Data Management || Product || Product >> Org Specific : create new record setting your planner and planning method and capacity=0
5. Sales Management || Transactions || Sales Order || Header:create SO for Mcgiver with Scheduled Delivery Date=14/08/2010
Go to Lines and set product=hat and qty=10000
Process SO.
6. Material Requirement (MRP) || Transactions || Purchasing Plan || Header:
  document date= 14-07-2010
  time horizon=60
  planner=your_planner
  bp=mcgiver
and run "Process Purchase Plan"
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0029482)
hgbot (developer)
2010-07-22 18:24

 Repository: erp/devel/pi
Changeset: d24e1139ded8929d1dd929d1d0963740d6c11382
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Jul 22 18:22:49 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d24e1139ded8929d1dd929d1d0963740d6c11382 [^]

Fixes issue 0013959: Error division by zero when processing Purchasing Plan
It has been added a check that verifies when the capacity is zero and raises an error message explaining it

---
M src-db/database/model/functions/MRP_PURCHASEPLAN.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0029483)
adrianromero (viewer)
2010-07-22 18:27

 * Testing the issue

Follow the steps to test and verify that the process is interrupted and the following error message is displayed:

The following product has capacity 0. Please set a proper capacity and run the process again: Hat

* Other areas affected

It only has been modified the procedure MRP_PURCHASEPLAN and only the behavior when the capacity is zero. no other areas affected.
(0029490)
sureshbabu (viewer)
2010-07-23 08:11

 verified, system throws following error message
Error:
The following product has capacity 0. Please set a proper capacity and run the process again: test2
(0029599)
hudsonbot (viewer)
2010-07-27 15:41

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/d24e1139ded8 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/634cc0909ed2 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17922.obx [^]

- Issue History
Date Modified Username Field Change
2010-07-14 18:16 networkb New Issue
2010-07-14 18:16 networkb Assigned To => adrianromero
2010-07-14 18:16 networkb OBNetwork customer => Yes
2010-07-20 11:50 adrianromero Status new => scheduled
2010-07-20 11:50 adrianromero fix_in_branch => pi
2010-07-22 18:24 hgbot Checkin
2010-07-22 18:24 hgbot Note Added: 0029482
2010-07-22 18:24 hgbot Status scheduled => resolved
2010-07-22 18:24 hgbot Resolution open => fixed
2010-07-22 18:24 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d24e1139ded8929d1dd929d1d0963740d6c11382 [^]
2010-07-22 18:27 adrianromero Note Added: 0029483
2010-07-23 08:11 sureshbabu Note Added: 0029490
2010-07-23 08:11 sureshbabu Status resolved => closed
2010-07-24 00:00 anonymous sf_bug_id 0 => 3033814
2010-07-27 15:41 hudsonbot Checkin
2010-07-27 15:41 hudsonbot Note Added: 0029599

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker