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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0036325
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2017-06-23 12:512017-07-26 09:47
ReporterngarciaView Statuspublic 
Assigned Tocollazoandy4 
PriorityhighResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0036325: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0098202)
collazoandy4 (reporter)
2017-07-24 16:10

More details is needed in order to reproduce this issue
(0098208)
collazoandy4 (reporter)
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;

- Issue History
Date Modified Username Field Change
2017-06-23 12:51 ngarcia New Issue
2017-06-23 12:51 ngarcia Assigned To => Triage Finance
2017-06-23 12:51 ngarcia Modules => Core
2017-06-23 12:51 ngarcia Triggers an Emergency Pack => No
2017-06-23 12:54 ngarcia Issue Monitored: networkb
2017-07-21 22:27 collazoandy4 Assigned To Triage Finance => collazoandy4
2017-07-24 16:10 collazoandy4 Note Added: 0098202
2017-07-24 16:10 collazoandy4 Status new => feedback
2017-07-24 16:11 collazoandy4 Assigned To collazoandy4 => ngarcia
2017-07-24 16:31 ngarcia Steps to Reproduce Updated View Revisions
2017-07-24 16:31 ngarcia Status feedback => new
2017-07-25 16:29 collazoandy4 Note Added: 0098208
2017-07-25 16:34 collazoandy4 Status new => scheduled
2017-07-26 09:47 ngarcia Assigned To ngarcia => collazoandy4


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker