Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034784
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2016-12-20 12:132017-06-09 02:49
ReporterpsanjuanView Statuspublic 
Assigned Tocollazoandy4 
PriorityurgentResolutionfixedFixed in Version3.0PR17Q3
StatusclosedFix in branchFixed in SCM revision6a7d52c75508
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034784: Return Material Receipt is not properly managing Pending and Receiving quanitties if Alternative UOM is used

DescriptionReturn Material Receipt is not properly managing Pending and Receiving quanitties if Alternative UOM is used
Steps To Reproduce1. Log in as Openbravo,Sytem Admin role
2. Go to Unit of Measure window
3. Create a new record with below setup:
Orbanization = *
EDI Code = PC
Name = Pack
Standard Precision = 2
Costing Precision = 2
Symbol = PC
4. Save it
5. Create another record with below setup:
Orbanization = *
EDI Code = PA
Name = Pallet
Standard Precision = 2
Costing Precision = 2
Symbol = PA
7. Go to ""Unit"" Unit of Measure and verify its standdar precision = 0. Change it to 2
8. Save it.
9. Log out and Log in"

1. Log in as Openbravo, F&B International Group Admint role
2. Go to Product window and create a new record with below setup:
Organization = F&B España
Name = Search Key = Purchase PA11 & Sales PK12
Product Type = Item
UOM = Unit
3. Go to Price tab and select
Tarifa Bebidas Alegres. Enter 100.00 as Unit/List Price
Tarfa de ventas. Enter 150.00 as Unit/List Price
4. Go to Alternate UOM tab and enter below setup:
UOM = Pack, with a conversion rate = 12, set as Primary for Sales and Secondary for Purchase
UOM = Pallet, with a converion rate = 11, set as Primary for Purchase and secondary for Sales.
In both cases set Logistics as "Not Applicable.

1. Go to Purchase Order window and create a new one for F&B España, Bebidas Alegres business Partner.
2. Go to lines and create a new one for the just created product.
3. Enter an Operative Quanity = 10, Alternative UOM = Pallet, Ordered Quantity = 110 Units.
4. Book the order.

1. Go to Goods Receipt window and receipt the order. 110 units are received.

1. Go to Sales Order window and create a new order for F&B España, Alimentos y Supermercados business partner.
2. Enter an Operative Quantity of 4, Alternative UOM = Pack, Ordered Quantity = 48 unit.
3. Book the order.

1. Go to Goods Shipment and ship the order created. 48 units are shipped.

1. Go to Return from Customer window and create a new one for F&B España, Alimentos y Supermercados business partner
2. Click on Pick/Edit Lines
3. Select shipment just created, ie.1000223
4. Select the line.
5. Enter a returned qty = 0.5 pack for product "Purchase PA11 & Sales PK12""
7. Press Done"

1. Go to Return Material Receipt window and create a new one for F&B España, Alimentos y Supermercados business partner.
2. Click on Pick/Edit Lines
3. Select RM order just created.

Verify that below data is shown:
Returned = 6
UOM = Unit
Operative Quantity = 0.5
Altenative UOM = 0.5
Pending 6
Receiving 6
Returned UOM = Pack

Above is not correct because only 0.5 packs or 6 units can be received, or are pending to be received.

TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0034805 closedcollazoandy4 Operative Quantity needs to be updated to 0 same as Ordered/Return quanity if the corresponding order is closed (not delivered) 

-  Notes
(0093030)
collazoandy4 (reporter)
2016-12-27 18:25
edited on: 2017-01-03 11:19

 Test Case 1 - Return from Customer 100% delivered.

  As System Admin Role
    Go to Unit of Measure window
    Create a new record with below setup:
      Organization = *
      EDI Code = PC
      Name = Pack
      Standard Precision = 2
      Costing Precision = 2
      Symbol = PC
      Save it
    Create another record with below setup:
       Orbanization = *
       EDI Code = PA
       Name = Pallet
       Standard Precision = 2
       Costing Precision = 2
       Symbol = PA
       Save it.
    Go to Preference
    Create a new record with below setup:
       Property = Enable UOM Management
       Value = Y
    Log out and Log in as F&B International Group
    Go to Product window and create a new record with below setup:
       Organization = F&B España
       Name = Search Key = Purchase PA11 & Sales PK12
       Product Type = Item
        UOM = Unit
    Go to Price tab and select
    Tarifa Bebidas Alegres. Enter 100.00 as Unit/List Price
    Tarifa de ventas. Enter 150.00 as Unit/List Price
    Go to Alternate UOM tab and enter below setup:
       UOM = Pack, with a conversion rate = 12, set as Primary for Sales and Secondary for Purchase and Logistics as "Not Applicable"
       UOM = Pallet, with a converion rate = 11, set as Primary for Purchase and secondary for Sales and Logistics as "Not Applicable".

Go to Purchase Order window and create a new one for F&B España, Bebidas Alegres business Partner.
    Create a new line for the just created product.
    Enter an Operative Quantity = 10, Alternative UOM = Pallet, Ordered Quantity = 110 Units.
    Book the order.
    Go to Goods Receipt window and and create a new one for F&B España, Bebidas Alegres business Partner.
    Clic on Create Lines From button
    Select the order created. Clic on OK button
    Complete de document.

Go to Sales Order window and create a new order for F&B España, Alimentos y Supermercados business partner.
    Enter an Operative Quantity of 4, Alternative UOM = Pack, Ordered Quantity = 48 unit. Book the order.
    Go to Goods Shipment window and and create a new one for F&B España, Bebidas Alegres business Partner.
    Clic on Create Lines From button
    Select the order created. Clic on OK button
    Complete de document.

Go to Return from Customer window and create a new one for F&B España, Alimentos y Supermercados business partner
    Click on Pick/Edit Lines
    Select shipment just created
    Select the line.
    Enter a returned qty = 0.5 pack for product "Purchase PA11 & Sales PK12""
    Press Done and book the document.

Go to Return Material Receipt window and create a new one for F&B España, Alimentos y Supermercados business partner. Click on Pick/Edit Lines.
Select RM order just created.

Verify that Pending = 0.5 = Receiving 0.5. Returned UOM = Pack.

Press Done. Complete Return Material Receipt with an operative quantity = 0.5 (pack ) and movement quantity = 6 (units).
(0093121)
psanjuan (manager)
2017-01-03 12:10
edited on: 2017-01-27 12:47

 Test Case 3 - Return from Customer (partially delivered) - Change to 0.5 units.

Create a Goods Shipment for F&B España, Alimentos y Supermercados business partner, for the product. Enter 50 Pallets (500 Units). Complete the shipment.

Go to Return from Customer window and create a new one for F&B España, Alimentos y Supermercados business partner. Click on Pick/Edit Lines and select the shipment. Enter 5 Pallets to be returned. Press OK and Book the order.

(Having 34872 fix applied) go to Return Material Receipt window and create a new one for F&B España, Alimentos y Supermercados business partner.
Click on Pick/Edit lines and select the just created RFC Order. Change Qty to 0.5 and to Units. Press OK.

Check that Return Material Receipt line is NOT properly created as Operative Quantity = 0.5 (pallet) same as Movement Quantity = 0.5 (units.)

Operative Quantity should have been = 0.05 (pallets).
(0097207)
hgbot (developer)
2017-06-08 11:40

 Repository: erp/devel/pi
Changeset: 6a7d52c75508509ed83486c21aa05c84c866c110
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Tue May 30 11:54:19 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/6a7d52c75508509ed83486c21aa05c84c866c110 [^]

Fixes issue 34784: Pending and Receiving quantities doesn't match returned AUOM

If a product have an Alternative Unit Of Measure, pending, receiving and operative
quantities doesn't match the return UOM. A check was add to the
m_rm_receipt_pick_edit and m_rm_shipment_pick_edit views checking the AUOM
preference value and if the line have an Alternative UOM, also the operativeqty
of the inout line is recalculated if the alternativeUOM is different from the
returnedUOM

---
M src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml
M src-db/database/model/views/M_RM_SHIPMENT_PICK_EDIT.xml
M src/org/openbravo/common/actionhandler/RMInOutPickEditLines.java
---
(0097208)
hgbot (developer)
2017-06-08 11:40

 Repository: erp/devel/pi
Changeset: 54c06cacc8d9ffe7236e87df8ca58f0883304d19
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Jun 08 11:29:15 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/54c06cacc8d9ffe7236e87df8ca58f0883304d19 [^]

Related to Issue 34784. Code Review. Extracted code to private functions
to improve redability

---
M src/org/openbravo/common/actionhandler/RMInOutPickEditLines.java
---
(0097211)
dmiguelez (developer)
2017-06-08 11:48

 Code Review + Testing Ok
(0097258)
hudsonbot (developer)
2017-06-09 02:49

 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/682983c2eead [^]
Maturity status: Test
(0097259)
hudsonbot (developer)
2017-06-09 02:49

 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/682983c2eead [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2016-12-20 12:13 psanjuan New Issue
2016-12-20 12:13 psanjuan Assigned To => Triage Finance
2016-12-20 12:13 psanjuan Modules => Core
2016-12-20 12:13 psanjuan Triggers an Emergency Pack => No
2016-12-20 12:18 psanjuan Steps to Reproduce Updated View Revisions
2016-12-20 12:25 psanjuan Steps to Reproduce Updated View Revisions
2016-12-20 12:28 psanjuan Steps to Reproduce Updated View Revisions
2016-12-23 16:22 markmm82 Assigned To Triage Finance => collazoandy4
2016-12-23 16:31 collazoandy4 Status new => scheduled
2016-12-27 18:25 collazoandy4 Note Added: 0093030
2017-01-03 11:17 psanjuan Note Edited: 0093030 View Revisions
2017-01-03 11:19 psanjuan Note Edited: 0093030 View Revisions
2017-01-03 11:19 psanjuan Note Edited: 0093030 View Revisions
2017-01-03 12:10 psanjuan Note Added: 0093121
2017-01-04 11:50 psanjuan Note Added: 0093167
2017-01-27 12:32 psanjuan Relationship added related to 0034805
2017-01-27 12:47 psanjuan Note Edited: 0093121 View Revisions
2017-03-30 18:04 aferraz Relationship deleted related to 0034805
2017-03-30 18:04 aferraz Relationship added blocks 0034805
2017-04-06 19:57 aferraz Relationship deleted blocks 0034805
2017-04-06 19:57 aferraz Relationship added related to 0034805
2017-04-06 19:58 aferraz Status scheduled => feedback
2017-04-06 19:58 aferraz Status feedback => scheduled
2017-06-08 11:40 hgbot Checkin
2017-06-08 11:40 hgbot Note Added: 0097207
2017-06-08 11:40 hgbot Status scheduled => resolved
2017-06-08 11:40 hgbot Resolution open => fixed
2017-06-08 11:40 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6a7d52c75508509ed83486c21aa05c84c866c110 [^]
2017-06-08 11:40 hgbot Checkin
2017-06-08 11:40 hgbot Note Added: 0097208
2017-06-08 11:48 dmiguelez Review Assigned To => dmiguelez
2017-06-08 11:48 dmiguelez Note Added: 0097211
2017-06-08 11:48 dmiguelez Status resolved => closed
2017-06-08 11:57 aferraz Note Deleted: 0093167
2017-06-08 11:58 aferraz Fixed in Version => 3.0PR17Q3
2017-06-09 02:49 hudsonbot Checkin
2017-06-09 02:49 hudsonbot Note Added: 0097258
2017-06-09 02:49 hudsonbot Checkin
2017-06-09 02:49 hudsonbot Note Added: 0097259

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker