Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037996Openbravo ERP07. Sales managementpublic2018-02-23 09:172018-03-02 21:18
ReporterAtulOpenbravo 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q2 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelQA functional test
Regression date2018-02-20
Regression introduced in releasepi
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/04e13cbe6990 [^]
Triggers an Emergency PackNo
Summary0037996: Sales Order with Immediate Invoice terms does not appear in Create Invoices From Order and Create Lines From process
DescriptionStandard Sales Order with immediate invoice term does not appear in the Order list in Create Line From process in Sales Invoice Header. Alternately the such orders does not appear in the Create Invoice from Order process.
Steps To Reproduce- Login as F&B International Group Admin.
- Create a Standard Sales Order for any business partner.
- Set Invoice terms as Immediate.
- Add any product to it and book it.
- Create a Sales Invoice header for same business partner as above.
- Using Create Lines From Popup, check the order drop down list.
- Order created above does not appear in the list.

- Alternatively Navigate to Create Invoices From Order process.
- Realize that Order created above does not appear in the list.
Proposed SolutionIn C_Invoice_Candidate_V view,

obequals(l.qtyordered, l.qtyinvoiced) <> 'N'

should be

obequals(l.qtyordered, l.qtyinvoiced) = 'N'
Additional Information
TagsNo tags attached.
Relationships
caused by design defect 0037357 closed AtulOpenbravo Create Lines From popup on Invoice windows slow with high number of shipments 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-02-23 09:17AtulOpenbravoNew Issue
2018-02-23 09:17AtulOpenbravoAssigned To => AtulOpenbravo
2018-02-23 09:17AtulOpenbravoModules => Core
2018-02-23 09:17AtulOpenbravoRegression level => QA functional test
2018-02-23 09:17AtulOpenbravoRegression date => 2018-02-20
2018-02-23 09:17AtulOpenbravoRegression introduced in release => pi
2018-02-23 09:17AtulOpenbravoRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/04e13cbe6990 [^]
2018-02-23 09:17AtulOpenbravoTriggers an Emergency Pack => No
2018-02-23 09:17AtulOpenbravoStatusnew => scheduled
2018-02-23 09:18AtulOpenbravoRelationship addedcaused by 0037357
2018-02-26 10:09AtulOpenbravoNote Added: 0102834
2018-02-26 10:09AtulOpenbravoNote Edited: 0102834bug_revision_view_page.php?bugnote_id=0102834#r16764
2018-02-26 10:10AtulOpenbravoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=16766#r16766
2018-02-27 12:30hgbotCheckin
2018-02-27 12:30hgbotNote Added: 0102849
2018-02-27 12:30hgbotStatusscheduled => resolved
2018-02-27 12:30hgbotResolutionopen => fixed
2018-02-27 12:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/43e5679d96fd6d8213b93322f79a364ffe7c79e5 [^]
2018-02-27 12:32dmiguelezReview Assigned To => dmiguelez
2018-02-27 12:32dmiguelezNote Added: 0102850
2018-02-27 12:32dmiguelezStatusresolved => closed
2018-02-27 12:32dmiguelezFixed in Version => 3.0PR18Q2
2018-03-02 21:18hudsonbotCheckin
2018-03-02 21:18hudsonbotNote Added: 0102956

Notes
(0102834)
AtulOpenbravo   
2018-02-26 10:09   
Test Plan

- Login as F&B International Group Admin.
- Create a Standard Sales Order for any business partner.
- Set Invoice terms as Immediate.
- Add a product to it and book it.
- Create a Sales Invoice header for same business partner as above.
- Using Create Lines From Popup, check the order drop down list.
- Order created in the above step appears in the list.

- Alternatively Navigate to Create Invoices From Order process.
- Realize that Order created in the above step appears in the list.
(0102849)
hgbot   
2018-02-27 12:30   
Repository: erp/devel/pi
Changeset: 43e5679d96fd6d8213b93322f79a364ffe7c79e5
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Feb 23 14:26:31 2018 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/43e5679d96fd6d8213b93322f79a364ffe7c79e5 [^]

Fixes Issue 37996: Sales Order with Immediate Invoice terms
does not appear in Create Invoices From Order and Create
Lines From process

In C_Invoice_Candidate_V view, OBEQUALS condition for
qtyordered and qtyinvoiced is set as = 'N' which was
wrongly set as <> 'N'

---
M src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
---
(0102850)
dmiguelez   
2018-02-27 12:32   
Code Review + Testing Ok
(0102956)
hudsonbot   
2018-03-02 21:18   
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/05dece3dc80b [^]
Maturity status: Test