Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040044Openbravo ERP03. Procurement managementpublic2019-01-28 12:122019-03-28 14:56
Reporterngarcia 
Assigned Tomarkmm82 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q2 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket7713
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040044: Negative quantity in Create lines from Receipt in Purchase Invoice window if the order was previously invoiced and received
DescriptionNegative quantity in Create lines from Receipt in Purchase Invoice window if the order was previously invoiced and received
Steps To ReproduceAs group admin role:
   Create a new product and set a purchase price to it
   Create a new purchase order
   Add 1000 units of the product and book it
   Create three purchase invoices of 300 units each and complete them
   Create a goods receipt, select previously created purchase order and add 950 units and complete it

   Create a new purchase invoice (in order to invoice the pending 50 units)
   Create Lines From Receipt and check -1900 units are pending to be invoiced
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-01-28 12:12ngarciaNew Issue
2019-01-28 12:12ngarciaAssigned To => Triage Finance
2019-01-28 12:12ngarciaOBNetwork customer => OBPS
2019-01-28 12:12ngarciaModules => Core
2019-01-28 12:12ngarciaSupport ticket => 7713
2019-01-28 12:12ngarciaResolution time => 1550444400
2019-01-28 12:12ngarciaTriggers an Emergency Pack => No
2019-01-28 12:16ngarciaIssue Monitored: networkb
2019-01-28 15:26SandrahuguetAssigned ToTriage Finance => markmm82
2019-01-28 17:16markmm82Statusnew => scheduled
2019-01-31 00:01markmm82Note Added: 0109341
2019-02-18 09:22hgbotCheckin
2019-02-18 09:22hgbotNote Added: 0109892
2019-02-18 09:22hgbotStatusscheduled => resolved
2019-02-18 09:22hgbotResolutionopen => fixed
2019-02-18 09:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/73454ec69b17adaacfd0a017205051a61bffd865 [^]
2019-02-18 09:23SandrahuguetReview Assigned To => Sandrahuguet
2019-02-18 09:23SandrahuguetNote Added: 0109893
2019-02-18 09:23SandrahuguetStatusresolved => closed
2019-02-18 09:23SandrahuguetFixed in Version => 3.0PR19Q2
2019-03-28 14:56hudsonbotCheckin
2019-03-28 14:56hudsonbotNote Added: 0110821

Notes
(0109341)
markmm82   
2019-01-31 00:01   
Test Plan:
As group admin role:
   Create a new product and set a purchase price to it
   Create a new purchase order
   Add 1000 units of the product and book it
   Create three purchase invoices of 300 units each and complete them
   Create a goods receipt, select previously created purchase order and add 950 units and complete it

   Create a new purchase invoice (in order to invoice the pending 50 units)
   Create Lines From Receipt and check 50 units are pending to be invoiced
(0109892)
hgbot   
2019-02-18 09:22   
Repository: erp/devel/pi
Changeset: 73454ec69b17adaacfd0a017205051a61bffd865
Author: Mark <markmm82 <at> gmail.com>
Date: Wed Jan 30 20:00:19 2019 -0300
URL: http://code.openbravo.com/erp/devel/pi/rev/73454ec69b17adaacfd0a017205051a61bffd865 [^]

Fixes issue 40044: Negative quantity in Create lines from Receipt in Purchase
Invoice window if the order was previously invoiced and received.

To calculate the pending to invoice movement quantity was needed to subtract the
sum of the already invoiced quantity instead of the matched quantity as it is the
total of the received quantity.

---
M src/org/openbravo/common/datasource/InOutLinePEHQLTransformer.java
---
(0109893)
Sandrahuguet   
2019-02-18 09:23   
Code review + testing OK
(0110821)
hudsonbot   
2019-03-28 14:56   
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/b2fbc1588df4 [^]
Maturity status: Test