Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029071Retail ModulesReturn Receiptpublic2015-02-26 10:172015-03-16 12:39
Reportermalsasua 
Assigned Tomigueldejuana 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029071: Error in receipt synchronization with verified returns and one line with two shipments lines
DescriptionError in the sync process with a receipt that it was created with verified return process, and the original order line is related to two shipment lines and the preference "Split Lines in Shipments when Returning" is N
Steps To ReproduceBackoffice:
 . preference "Split Lines in Shipments when Returning" set to N
 . warehouse: Vall Blanca Store Warehouse
   . new locator (see attach 1.newStorageBin.png)
 . physical inventory: vall blanca store
      line1:
        product Baby carrier
        count: 62
        locator: 0-0-0
      line2:
        product Baby carrier
        count: 8
        locator: 0-0-1
  (see attach: 2.physicalInventory.png)
    process physical inventory

. go to Web POS: VBS-1
  . create new receipt:
   . line1:
       product: Baby Carrier
       qty: 70
   . complete receipt
   (see attach: 3.receipt.png)

  . create new receipt:
   . line1:
      verified return:
       select previous receipt
   . complete it

. go to backoffice:
  . the return receipt has not been sync, it is in Errors while importing data window:
org.hibernate.NonUniqueResultException: query did not return a unique result: 2
    at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:899)
    at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
    at org.openbravo.dal.service.OBCriteria.uniqueResult(OBCriteria.java:129)
    at org.openbravo.retail.returns.ReturnsShipmentOrderLoaderHook.exec(ReturnsShipmentOrderLoaderHook.java:43)
    at
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on feature request 0025623 closed migueldejuana It is possible to return more quantity than sold quantity 
Attached Filespng 1.newStorageBin.png (131,429) 2015-02-26 10:18
https://issues.openbravo.com/file_download.php?file_id=7833&type=bug
png

png 2.physicalInventory.png (129,690) 2015-02-26 10:18
https://issues.openbravo.com/file_download.php?file_id=7834&type=bug
png

png 3.receipt.png (263,796) 2015-02-26 10:18
https://issues.openbravo.com/file_download.php?file_id=7835&type=bug
Issue History
Date ModifiedUsernameFieldChange
2015-02-26 10:17malsasuaNew Issue
2015-02-26 10:17malsasuaAssigned To => migueldejuana
2015-02-26 10:17malsasuaTriggers an Emergency Pack => No
2015-02-26 10:18malsasuaFile Added: 1.newStorageBin.png
2015-02-26 10:18malsasuaFile Added: 2.physicalInventory.png
2015-02-26 10:18malsasuaFile Added: 3.receipt.png
2015-03-06 12:53migueldejuanaRelationship addeddepends on 0025623
2015-03-10 13:14hgbotCheckin
2015-03-10 13:14hgbotNote Added: 0075377
2015-03-10 13:14hgbotStatusnew => resolved
2015-03-10 13:14hgbotResolutionopen => fixed
2015-03-10 13:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.returns/rev/0f302be41cf383ab131f1c457f6e844dd9139fa7 [^]
2015-03-10 13:15hgbotCheckin
2015-03-10 13:15hgbotNote Added: 0075378
2015-03-10 13:15hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.returns/rev/0f302be41cf383ab131f1c457f6e844dd9139fa7 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/8d2dcb79054fc6a72e8d2bdfd2894ab784e60837 [^]
2015-03-16 12:39adrianromeroReview Assigned To => adrianromero
2015-03-16 12:39adrianromeroNote Added: 0075618
2015-03-16 12:39adrianromeroStatusresolved => closed

Notes
(0075377)
hgbot   
2015-03-10 13:14   
Repository: erp/pmods/org.openbravo.retail.returns
Changeset: 0f302be41cf383ab131f1c457f6e844dd9139fa7
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Tue Mar 10 13:14:27 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.returns/rev/0f302be41cf383ab131f1c457f6e844dd9139fa7 [^]

Fixed issue 0029071: Error in receipt synchronization with verified returns and one line with two shipments lines

If preference "split in shipment lines" is false, we need to show n lines depending on the shipment lines of the order, but we do not force the user to decide which shipment line choose to return, Web POS will do it automatically.

---
M web/org.openbravo.retail.returns/js/modalReturnLines.js
---
(0075378)
hgbot   
2015-03-10 13:15   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 8d2dcb79054fc6a72e8d2bdfd2894ab784e60837
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Tue Mar 10 13:04:14 2015 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/8d2dcb79054fc6a72e8d2bdfd2894ab784e60837 [^]

Fixed issue 0029071: Error in receipt synchronization with verified returns and one line with two shipments lines

We set shipment lines to all orderlines

---
M src/org/openbravo/retail/posterminal/PaidReceipts.java
---
(0075618)
adrianromero   
2015-03-16 12:39   
Verified