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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023427
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminorhave not tried2013-03-27 23:052013-04-04 13:03
ReporterjonalegriaesarteView Statuspublic 
Assigned Tojonalegriaesarte 
PrioritynormalResolutionfixedFixed in Version3.0MP22
StatusclosedFix in branchFixed in SCM revision5c1ad90975cf
ProjectionnoneETAnoneTarget Version3.0MP22
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toegoitz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023427: Error when deactivating a locator

DescriptionError when deactivating a locator. The trigger is not properly set.
Steps To Reproduce- Deactivate a locator
Proposed SolutionChange the trigger M_LOCATOR_TRG:

select count(*)
into v_count
from m_storage_detail
where m_locator_id = old.m_locator_id
and COALESCE(qtyonhand,0) <> '0'
or COALESCE(qtyorderonhand, 0) <> '0'
or COALESCE(preqtyonhand, 0) <> '0'
or COALESCE(preqtyorderonhand, 0) <> '0';

select count(*)
into v_count
from m_storage_detail
where m_locator_id = old.m_locator_id
and COALESCE(qtyonhand,0) <> 0
or COALESCE(qtyorderonhand, 0) <> 0
or COALESCE(preqtyonhand, 0) <> 0
or COALESCE(preqtyorderonhand, 0) <> 0;
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0057516)
hgbot (developer)
2013-03-27 23:11

Repository: erp/devel/pi
Changeset: 5c1ad90975cfc21ec2418ed1682e492ef118cff7
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Wed Mar 27 23:41:36 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/5c1ad90975cfc21ec2418ed1682e492ef118cff7 [^]

Fixes issue 0023427: Error when deactivating a locator

---
M src-db/database/model/triggers/M_LOCATOR_TRG.xml
---
(0057552)
hudsonbot (developer)
2013-04-01 18:58

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/80299f4b6436 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2013-03-27 23:05 jonalegriaesarte New Issue
2013-03-27 23:05 jonalegriaesarte Assigned To => jonalegriaesarte
2013-03-27 23:05 jonalegriaesarte Modules => Core
2013-03-27 23:05 jonalegriaesarte Triggers an Emergency Pack => No
2013-03-27 23:11 hgbot Checkin
2013-03-27 23:11 hgbot Note Added: 0057516
2013-03-27 23:11 hgbot Status new => resolved
2013-03-27 23:11 hgbot Resolution open => fixed
2013-03-27 23:11 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5c1ad90975cfc21ec2418ed1682e492ef118cff7 [^]
2013-04-01 18:58 hudsonbot Checkin
2013-04-01 18:58 hudsonbot Note Added: 0057552
2013-04-04 13:03 egoitz Review Assigned To => egoitz
2013-04-04 13:03 egoitz Status resolved => closed
2013-04-04 13:03 egoitz Fixed in Version => 3.0MP22


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker