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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023113
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Gift cards and gift vouchersmajoralways2013-02-19 12:062013-03-04 10:55
ReporterjonalegriaesarteView Statuspublic 
Assigned Toguilleaer 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision0dc9623b7cff
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionRMP19.1SCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023113: PL OBDISC_XY_GIFT is referencing a column that does not exist

DescriptionPL OBDISC_XY_GIFT is referencing a column that does not exist. Purchase and sales invoices can not be booked under some conditions
Steps To Reproduce- il.qtyordered column does not exist

select floor(il.qtyordered / coalesce(op.em_obdisc_qty + op.em_obdisc_gifqty, 1))
into v_gift_chunks
from c_invoiceline il, m_offer_product op
where il.c_invoice_id = v_docId
and op.m_product_id = il.m_product_id
and op.m_offer_id = p_rule_id
and op.em_obdisc_is_gift = 'Y';
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0023145 closedmigueldejuana Function OBDISC_XY_GIFT Does not compile in Oracle 

-  Notes
(0056553)
hgbot (developer)
2013-02-19 21:49

Repository: erp/pmods/org.openbravo.retail.discounts
Changeset: 0dc9623b7cff8cc65841c9cb70aad73a45f11973
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Tue Feb 19 21:48:37 2013 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts/rev/0dc9623b7cff8cc65841c9cb70aad73a45f11973 [^]

fixed issue 23113: qtyinvoiced column is used instead of qtyordered wich not exists

---
M src-db/database/model/functions/OBDISC_XY_GIFT.xml
---

- Issue History
Date Modified Username Field Change
2013-02-19 12:06 jonalegriaesarte New Issue
2013-02-19 12:06 jonalegriaesarte Assigned To => guilleaer
2013-02-19 21:49 hgbot Checkin
2013-02-19 21:49 hgbot Note Added: 0056553
2013-02-19 21:49 hgbot Status new => resolved
2013-02-19 21:49 hgbot Resolution open => fixed
2013-02-19 21:49 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts/rev/0dc9623b7cff8cc65841c9cb70aad73a45f11973 [^]
2013-03-04 10:55 marvintm Review Assigned To => marvintm
2013-03-04 10:55 marvintm Status resolved => closed
2013-03-13 17:16 migueldejuana Relationship added related to 0023145


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker