Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023113Retail ModulesGift cards and gift voucherspublic2013-02-19 12:062013-03-04 10:55
Reporterjonalegriaesarte 
Assigned Toguilleaer 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product VersionRMP19.1 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023113: 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';
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0023145 closed migueldejuana Function OBDISC_XY_GIFT Does not compile in Oracle 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-19 12:06jonalegriaesarteNew Issue
2013-02-19 12:06jonalegriaesarteAssigned To => guilleaer
2013-02-19 21:49hgbotCheckin
2013-02-19 21:49hgbotNote Added: 0056553
2013-02-19 21:49hgbotStatusnew => resolved
2013-02-19 21:49hgbotResolutionopen => fixed
2013-02-19 21:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts/rev/0dc9623b7cff8cc65841c9cb70aad73a45f11973 [^]
2013-03-04 10:55marvintmReview Assigned To => marvintm
2013-03-04 10:55marvintmStatusresolved => closed
2013-03-13 17:16migueldejuanaRelationship addedrelated to 0023145

Notes
(0056553)
hgbot   
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
---