Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020151Openbravo ERP03. Procurement managementpublic2012-03-29 13:592012-04-26 19:32
Reporterdalsasua 
Assigned ToSandrahuguet 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 10.10
Product Version3.0MP8.1 
Target VersionFixed in Version3.0MP11 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020151: Generate invoice from orders process do not working for F&B
DescriptionGenerate invoice from orders process do not working for F&B
Steps To ReproduceRun the process for F&B and process for all the found elements.
Proposed Solutiondiff --git a/src-db/database/model/functions/C_INVOICE_CREATE.xml b/src-db/database/model/functions/C_INVOICE_CREATE.xml
--- a/src-db/database/model/functions/C_INVOICE_CREATE.xml
+++ b/src-db/database/model/functions/C_INVOICE_CREATE.xml
@@ -655,13 +655,13 @@
                   ELSE sh.DocumentNo
                 END
                 ) AS DocumentNo,
- sh.Description,
- sh.C_BPartner_ID,
+ coalesce(sh.Description, o.Description) as description,
+ coalesce(sh.C_BPartner_ID,o.c_bpartner_id) as c_bpartner_id,
                 o.BillTo_ID,
                 o.C_BPartner_Location_ID,
                 sh.AD_User_ID,
                 sh.DateOrdered,
- sh.C_Order_ID,
+ coalesce(sh.C_Order_ID,o.C_Order_ID) as C_Order_ID,
                 o.SalesRep_ID,
                 COALESCE(o.C_PaymentTerm_ID, bp.C_PaymentTerm_ID) AS C_PaymentTerm_ID,
                 COALESCE(o.IsDiscountPrinted, bp.IsDiscountPrinted) AS IsDiscountPrinted,
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-03-29 13:59dalsasuaNew Issue
2012-03-29 13:59dalsasuaAssigned To => vmromanos
2012-03-29 13:59dalsasuaModules => Core
2012-04-10 16:11SandrahuguetAssigned Tovmromanos => Sandrahuguet
2012-04-10 16:11SandrahuguetStatusnew => scheduled
2012-04-10 16:11Sandrahuguetfix_in_branch => pi
2012-04-10 17:01SandrahuguetNote Added: 0047432
2012-04-10 17:01SandrahuguetStatusscheduled => feedback
2012-04-24 13:26SandrahuguetStatusfeedback => scheduled
2012-04-25 17:51hgbotCheckin
2012-04-25 17:51hgbotNote Added: 0047968
2012-04-25 17:51hgbotStatusscheduled => resolved
2012-04-25 17:51hgbotResolutionopen => fixed
2012-04-25 17:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/985cbe917a34fd5a20db7616779ddb2fb4cbc946 [^]
2012-04-25 17:53vmromanosNote Added: 0047969
2012-04-25 17:53vmromanosStatusresolved => closed
2012-04-25 17:53vmromanosFixed in Version => 3.0MP11
2012-04-26 19:32hudsonbotCheckin
2012-04-26 19:32hudsonbotNote Added: 0048099

Notes
(0047432)
Sandrahuguet   
2012-04-10 17:01   
Hi,

I am not able to reproduce neither understand the problem behind this bug.
Could you please detail a bit the steps to reproduce for this issue?

Thanks in advance
(0047968)
hgbot   
2012-04-25 17:51   
Repository: erp/devel/pi
Changeset: 985cbe917a34fd5a20db7616779ddb2fb4cbc946
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Apr 24 17:56:40 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/985cbe917a34fd5a20db7616779ddb2fb4cbc946 [^]

Fixed issue 20151 Applied patch provided by DAL

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
---
(0047969)
vmromanos   
2012-04-25 17:53   
Code review OK.
Provided patch takes some values from the order header in case this info is not found in the shipment
(0048099)
hudsonbot   
2012-04-26 19:32   
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/70a717a9ffa1 [^]

Maturity status: Test