Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036325Openbravo ERP04. Warehouse managementpublic2017-06-23 12:512017-07-26 09:47
Reporterngarcia 
Assigned Tocollazoandy4 
PriorityhighSeverityminorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0036325: Cannot generate a shipment from an order if M_INOUT_CREATE is called without p_instance_id and document status <> 'IP'
DescriptionCannot generate a shipment from an order if M_INOUT_CREATE is called without p_instance_id and document status <> 'IP'

The problem is in the following condition of Cur_Order query:

(o.DocStatus='IP' OR(o.DocStatus='CO'
                                  AND o.IsDelivered='N'
                                  AND v_Record_ID='0'))

In standard code the function is used in the following flows and it works:

- Create Shipment From Orders. It is called with p_instance_id and v_record_id has 0 value
- Sales Order, complete a Warehouse Order or POS Order. It is called without p_instance_id, v_record_id has the c_order_id and the docstatus is 'IP'
Steps To ReproduceAs group admin role:

   Create a Sales Order
   Add a product with stock
   Complete it

Launch the following query through database and check the goods shipment is not created:

   select m_inout_create(null,<orderID>)
from dual
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-06-23 12:51ngarciaNew Issue
2017-06-23 12:51ngarciaAssigned To => Triage Finance
2017-06-23 12:51ngarciaModules => Core
2017-06-23 12:51ngarciaTriggers an Emergency Pack => No
2017-06-23 12:54ngarciaIssue Monitored: networkb
2017-07-21 22:27collazoandy4Assigned ToTriage Finance => collazoandy4
2017-07-24 16:10collazoandy4Note Added: 0098202
2017-07-24 16:10collazoandy4Statusnew => feedback
2017-07-24 16:11collazoandy4Assigned Tocollazoandy4 => ngarcia
2017-07-24 16:31ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15545#r15545
2017-07-24 16:31ngarciaStatusfeedback => new
2017-07-25 16:29collazoandy4Note Added: 0098208
2017-07-25 16:34collazoandy4Statusnew => scheduled
2017-07-26 09:47ngarciaAssigned Tongarcia => collazoandy4

Notes
(0098202)
collazoandy4   
2017-07-24 16:10   
More details is needed in order to reproduce this issue
(0098208)
collazoandy4   
2017-07-25 16:29   
Test Plan I
  As F&B International Group Admin Role
    Go to Sales Order window and create a new record
      Create a new record in Lines tab for Product Zumo de Piña 0,5L
      Book it
    Go to Create Shipment From Orders window and select the previous order created and clic on Process button
      Check a new Shipment for the order is created

Test Plan II
  As F&B International Group Admin Role
    Go to Sales Order window and create a new record with Transaction Document: POS Order
      Create a new record in Lines tab for Product Cerveza Ale 0,5L
      Book it and check a new invoice and shipment is created in the book process

Test Plan III
  As F&B International Group Admin Role
    Go to Sales Order window and create a new record with Transaction Document: Warehouse Order
      Create a new record in Lines tab for Product Zumo de Pera 0,5L
      Book it and check a new shipment is created in the book process

Test Plan IV
  As F&B International Group Admin Role
    Go to Sales Order window and create a new record
      Create a new record in Lines tab for Product Cerveza Lager 0,5L
      Book it
    Launch the following query through database and check the goods shipment is created:
      select m_inout_create(null,<orderID>) from dual;