Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025406Openbravo ERP04. Warehouse managementpublic2013-12-30 12:482014-01-12 12:58
Reporterextra 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilityN/A
StatusclosedResolutionno change required 
PlatformOS20OS VersionProfessional Appliance
Product Version3.0MP30 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Topramakrishnan
OBNetwork customerNo
Web browserMozilla Firefox
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025406: Warehouse can't be selected in sales orders
DescriptionThe warehouse selector field does not list any warehouse in sales documents although warehouses have been correctly created in the application. Being a mandatory field, basically it's not possible to enter any new sales order.
Steps To ReproduceI have created a new client with a new organization.
Then I created a warehouse in this organization with two storage bins.
If I try to create a sales order (but also a goods shipment document) the warehouse selector does not list any warehouse. Being a mandatory field, basically I cannot enter any new sales order.
I have noticed that the warehouse selector works from a purchase order.
Then I have created a purchase order and after I turned it into a sales order by manually updating the warehouse. The sales order is then correctly displayed in the sales order window and I am able to enter lines.
However when I try to book the order I get the error message "The Warehouse of the document does not belong to the selected Organization". This prevents to book the order.
I have noticed that in the F&B client this problem is not reproducible.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0025453 closed AtulOpenbravo Business Partner callout in Sales Order sets wrong warehouse 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-12-30 12:48extraNew Issue
2013-12-30 12:48extraAssigned To => dmiguelez
2013-12-30 12:48extraWeb browser => Mozilla Firefox
2013-12-30 12:48extraModules => Core
2013-12-30 12:48extraTriggers an Emergency Pack => No
2013-12-30 12:48extraIssue Monitored: extra
2013-12-30 12:50extraNote Added: 0063119
2013-12-30 16:54extraNote Added: 0063129
2014-01-03 07:34AtulOpenbravoAssigned Todmiguelez => AtulOpenbravo
2014-01-03 07:34AtulOpenbravoStatusnew => scheduled
2014-01-03 07:34AtulOpenbravofix_in_branch => pi
2014-01-09 11:14AtulOpenbravoNote Added: 0063331
2014-01-09 11:42AtulOpenbravoRelationship addedrelated to 0025453
2014-01-09 12:00extraNote Added: 0063338
2014-01-12 12:57AtulOpenbravoNote Added: 0063364
2014-01-12 12:58AtulOpenbravoReview Assigned To => pramakrishnan
2014-01-12 12:58AtulOpenbravoStatusscheduled => closed
2014-01-12 12:58AtulOpenbravoResolutionopen => no change required

Notes
(0063119)
extra   
2013-12-30 12:50   
This issue has been experienced in a fresh new MP30 Openbravo appliance running on VirtualBox on a physical Ubuntu desktop 13.10 machine.
The appliance has been activated with a Golden Key for evaluation purposes.
(0063129)
extra   
2013-12-30 16:54   
I realized that the problem was originated by a missing insert of a record in the ad_org_warehouse table.
I inserted manually the new record directly on the database, and it seems that everything works fine.
So the question is why the record has not been inserted in the ad_org_warehouse table?
(0063331)
AtulOpenbravo   
2014-01-09 11:14   
Please refer following documentation link to setup On hand warehouses for sales transaction.
http://wiki.openbravo.com/wiki/Organization#Warehouse [^]
(0063338)
extra   
2014-01-09 12:00   
So I understand that each time a new warehouse is created in Openbravo, before using this warehouse in any sales transaction we have to insert a record in the Warehouse tab of the Organization window. Is it correct?
(0063364)
AtulOpenbravo   
2014-01-12 12:57   
Yes. For sales transactions we need to define priority in the organization window warehouse tab so that for SO with document type Warehouse Order, POS Order or Create shipment from orders process, system sets proper storage locators of warehouses in the shipments as per user defined priorities.

There is different issue with callout, for more info check related issue.