0039530: No stock error for Orphan lines in Return to Vendor Shipment if it includes instance attributes - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

ID

Project

Category

View Status

Date Submitted

Last Update

0039530

Openbravo ERP

04. Warehouse management

public

2018-10-24 13:09

2018-12-11 20:22

Reporter

ngarcia

Assigned To

markmm82

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS

5

OS Version

Product Version

Target Version

Fixed in Version

3.0PR19Q1

Merge Request Status

Review Assigned To

Sandrahuguet

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0039530: No stock error for Orphan lines in Return to Vendor Shipment if it includes instance attributes

Description

No stock error for Orphan lines in Return to Vendor Shipment if it includes instance attributes

Steps To Reproduce

As group admin role:
   Set RM Allow Orphan Line preference to Y
   Log out and log in

   Configure the Inventory Status of storage bins to allow negative stock (select a status with Overissue = 'Y')

   Create a new product
   Set Lot Attribute set to it
   Add a purchase price list it

   Create a Goods Receipt
   Add previously created product
   Set 1 in Attribute Set Value field
   Add a movement quantity and complete

   Create a Return to Vendor header
   Insert Orphan Line
   Select previously create product
   Add 1 in Attribute Set Value field (as the product with attribute set value cannot be selected in Product selector, it will be a new attribute set instance and there will not be stock of it)
   Book it

   Create a Return To Vendor Shipment header and select Pick/Edit Lines
   Select previously created line and you will get the following error:

      "There isn't enough available stock for RM order No: 1000002"

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to

design defect

0039469

new

Triage Omni WMS

Orphan lines do not currently support instance attributes

Attached Files

Issue History

Date Modified

Username

Field

Change

2018-10-24 13:09

New Issue

2018-10-24 13:09

Assigned To

=> Triage Finance

2018-10-24 13:09

Modules

=> Core

2018-10-24 13:09

Resolution time

=> 1542150000

2018-10-24 13:09

Triggers an Emergency Pack

=> No

2018-10-24 13:09

Issue generated from

0039469

2018-10-24 13:09

Relationship added

related to 0039469

2018-10-24 13:10

Issue Monitored: networkb

2018-10-24 16:27

Issue Monitored: martinsdan

2018-10-25 12:12

Assigned To

Triage Finance => markmm82

2018-10-25 20:42

Status

new => scheduled

2018-10-30 18:32

Note Added: 0107678

2018-11-02 15:43

Note Edited: 0107678

bug_revision_view_page.php?bugnote_id=0107678#r17896

2018-11-02 16:07

Note Edited: 0107678

bug_revision_view_page.php?bugnote_id=0107678#r17897

2018-11-02 16:14

Note Added: 0107726

2018-11-07 17:39

Checkin

2018-11-07 17:39

Note Added: 0107783

2018-11-07 17:39

Status

scheduled => resolved

2018-11-07 17:39

Resolution

open => fixed

2018-11-07 17:39

Fixed in SCM revision

=> http://code.openbravo.com/erp/devel/pi/rev/0b6bb996e29dc13fb00d884912faa1499b427cab [^]

2018-11-07 17:40

Review Assigned To

=> Sandrahuguet

2018-11-07 17:40

Note Added: 0107784

2018-11-07 17:40

Status

resolved => closed

2018-11-07 17:40

Fixed in Version

=> 3.0PR19Q1

2018-12-11 20:22

Checkin

2018-12-11 20:22

Note Added: 0108454

Notes

Test Plan 1:
As group admin role:
   Set RM Allow Orphan Line preference to Y
   Log out and log in

   Configure the Inventory Status of some storage bins to allow negative stock (select a status with Overissue = 'Y').
     For instance select España Región Norte warehouse.
     Go to Storage Bin tab and select Rn-1-0-0 storage bin.
     Change the Inventory status by pressing the Change Status button.
       Select Undefined-Overissue Inventory Status. Done.

   Create a new product
   Set Lot Attribute set to it
   Add a purchase price list to it, for instance Tarifa Bebidas Alegres.

   Create a Goods Receipt for Bebidas Alegres bp.
   Add a new line with previously created product
   Set 1 in Attribute Set Value field
   Add a movement quantity and complete

   Create a Return to Vendor header for Bebidas Alegres bp.
   Insert Orphan Line
     Select previously create product
     Add 1 in Attribute Set Value field (as the product with attribute set value cannot be selected in Product selector, it will be a new attribute set instance and there will not be stock of it)
   Book it

   Create a Return To Vendor Shipment header for Bebidas Alegres bp and select Pick/Edit Lines
   Select previously created line and set as Ship Qty the movement quatity.
   Press Done and notice the process ends successfully and a new line is created.
   Complete the document and notice the process ends successfully.
   Go to the overissue bin and you will find in the Bin Contents tab a new entry with negative stock.

Test Plan 2:
As group admin role:

Go to Preference Window and create a new record with:
- Organization: *
- Property: RM Allow Orphan Line
- Value: Y
All fields from Visibility section empty

Log out and Log in again

Go to Product Window and create a new record with:
- Organization: F&B US
- Search Key: Test
- Name: Test
Move to Price Tab and create a new record with:
- Price List Version: Be Soft Drinker Price List
- Unit Price: 10
- List Price: 10

Go to Return to Vendor window and create a new record with:
- Organization: F&B US
- Business Partner: Be Soft Drinker
- Warehouse: US East Coast
Click on Insert Orphan Line Button and set:
- Product: Test
- Returned: 100
Click on Ok and Book the Document

Go to Warehouse And Storage Bins Window and select US East Coast Warehouse
Move to Storage Bin Tab and select EC-0-0-0 Bin
Click on Change Status button and select Undefined-OverIssue. Click ok
Now there is one Bin in the Warehouse that allows negative stock

Go to Return to Vendor Shipment Window and create a new record with:
- Organization: F&B US
- Business Partner: Be Soft Drinker
- Warehouse: US East Coast
Click on Pick/Edit Lines and select the line from the previous Return to Vendor Document.
Notice that the Storage Bin field has been filled with EC-0-0-0 Bin, since it is a Bin that allows to go to negative stock.

Enter any Ship Quantity, for instance 20. Press Done and Complete the RTVS.
Notice the process is completed successfully.

Go to the storage bin tab and notice that there is a new entry in the Bin Contents related to the RTVS. Select the line with the created product and notice it has a negative stock value.