Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035697Openbravo ERP03. Procurement managementpublic2017-04-04 21:002017-05-29 17:43
Reportercollazoandy4 
Assigned Tocollazoandy4 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q3 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035697: Return qty not properly updated in a return to vendor partially delivered
DescriptionWhen closing a return to vendor partially delivery the returnqty it's no updated with the delivered quantity
Steps To ReproduceGo to Product window and create a new record:
  Product: Product
  Create a new record in Price Tab:
    Price List Version: Tarifa Bebidas Alegres
    Unit Price/List Price: 7
  Create a new record in Price Tab:
    Price List Version: Tarifa de ventas
    Unit Price/List Price: 9
Go to Goods Receipt window and create a new record:
  Business Partner: Bebidas Alegres, S.L.
  Create a new record in Lines tab:
   Product: Product
   Movement Quantity: 50
  Complete de document
Go to Return to Vendor window and create a new record:
  Business Partner: Bebidas Alegres, S.L.
  Click on Pick/Edit Lines.
  Select the receipt just created showing 50 units. Enter a Returned quantity = 10. Press Done.
Book the document. RTV Order 9
Go to Return to Vendor Shipment window and create a new record:
  Business Partner: Bebidas Alegres, S.L.
  Click on Pick/Edit Lines. Select the RM order just created, enter a ship Qty = 4. Press Done.
  Verify that Movement Qty = 4
  Complete return to vendor shipment.
Go to back to Return to Vendor and close it.
Verify that Return = 0 but that is not correct. Correct is Return = 4
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0034805 closed collazoandy4 Operative Quantity needs to be updated to 0 same as Ordered/Return quanity if the corresponding order is closed (not delivered) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-04-04 21:00collazoandy4New Issue
2017-04-04 21:00collazoandy4Assigned To => Triage Finance
2017-04-04 21:00collazoandy4OBNetwork customer => No
2017-04-04 21:00collazoandy4Modules => Core
2017-04-04 21:00collazoandy4Triggers an Emergency Pack => No
2017-04-04 21:01collazoandy4Relationship addedrelated to 0034805
2017-04-06 11:53aferrazAssigned ToTriage Finance => collazoandy4
2017-04-21 15:11collazoandy4Statusnew => scheduled
2017-04-25 15:49collazoandy4Note Added: 0096158
2017-05-19 15:17hgbotCheckin
2017-05-19 15:17hgbotNote Added: 0096684
2017-05-19 15:17hgbotStatusscheduled => resolved
2017-05-19 15:17hgbotResolutionopen => fixed
2017-05-19 15:17hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cdb4ed6b52d2b94225f82148155ffe183ada2518 [^]
2017-05-19 15:30aferrazReview Assigned To => aferraz
2017-05-19 15:30aferrazNote Added: 0096685
2017-05-19 15:30aferrazStatusresolved => closed
2017-05-19 15:30aferrazFixed in Version => 3.0PR17Q3
2017-05-29 17:43hudsonbotCheckin
2017-05-29 17:43hudsonbotNote Added: 0096976

Notes
(0096158)
collazoandy4   
2017-04-25 15:49   
Test Plan I
As F&B International Group Admin Role:
  Create a new Purchase Order:
    Business Partner: Bebidas Alegres, S.L.
    Create a new Line:
      Product: Cerveza Ale 0,5L
      Ordered Quantity: 10
    Complete the order
  Create a new Goods Receipt:
    Business Partner: Bebidas Alegres, S.L.
    Select the option Create lines from and select the previous order line created
    Edit the line qty to 5
    Complete the Receipt
  Go to the previous order created and close it
  Check Ordered Quantity: 5

Test Plan II
  Create a new Purchase Order:
    Business Partner: Bebidas Alegres, S.L.
    Create a new Line:
      Product: Cerveza Ale 0,5L
      Ordered Quantity: -20
    Complete the order
  Create a new Goods Receipt:
    Business Partner: Bebidas Alegres, S.L.
    Select the option Create lines from and select the previous order line created
    Edit the line qty to -10
    Complete the Receipt
  Go to the previous order created and close it
  Check Ordered Quantity: -10

Test Plan III
  Create a new Return from Customer:
    Business Partner: Alimentos y Supermercados, S.A
    Select the option Pick/Edit Lines and select any shipment line and set returnqty = 20
    Complete it
  Create a new Return Material Receipt:
    Business Partner: Alimentos y Supermercados, S.A
    Select the option Pick/Edit Lines and select previous line and set receivingqty = 10
    Complete it
  Go to the previous Return from Customer created and check receivingqty = 10
    Close it and check returnedqty: 10

Test Plan IV
  Create a new Return to vendor:
    Business Partner: Bebidas Alegres, S.L.
    Select the option Pick/Edit Lines and select any shipment line and set returnqty = 20
    Complete it
  Create a new Return to vendor shipment:
    Business Partner: Bebidas Alegres, S.L.
    Select the option Pick/Edit Lines and select previous line and set shipqty = 10
    Complete it
  Go to the previous Return to vendor created close it and check returnedqty: 10
(0096684)
hgbot   
2017-05-19 15:17   
Repository: erp/devel/pi
Changeset: cdb4ed6b52d2b94225f82148155ffe183ada2518
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Tue Apr 25 09:39:15 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/cdb4ed6b52d2b94225f82148155ffe183ada2518 [^]

Fixes issue 35697: Return qty not properly updated with RTV partially delivered

Return qty was not properly updated when closing a return to vendor partially
delivered because when qtydelivered it's equal to 0 and the qtyinvoiced is less
than 0 the qtyOrdered is 0

Now a new validation was added to get the correct value of qtyOrdered when qtydelivered
it's equal to 0

---
M src-db/database/model/functions/C_ORDER_POST1.xml
---
(0096685)
aferraz   
2017-05-19 15:30   
Code review + Testing OK
(0096976)
hudsonbot   
2017-05-29 17:43   
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/1ee70113bdc4 [^]
Maturity status: Test