0025406: Warehouse can't be selected in sales orders

(0063119)
extra (reporter)
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 (reporter)
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 (developer)
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 (reporter)
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 (developer)
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.

Issue History
Date Modified	Username	Field	Change
2013-12-30 12:48	extra	New Issue
2013-12-30 12:48	extra	Assigned To	=> dmiguelez
2013-12-30 12:48	extra	Web browser	=> Mozilla Firefox
2013-12-30 12:48	extra	Modules	=> Core
2013-12-30 12:48	extra	Triggers an Emergency Pack	=> No
2013-12-30 12:48	extra	Issue Monitored: extra
2013-12-30 12:50	extra	Note Added: 0063119
2013-12-30 16:54	extra	Note Added: 0063129
2014-01-03 07:34	AtulOpenbravo	Assigned To	dmiguelez => AtulOpenbravo
2014-01-03 07:34	AtulOpenbravo	Status	new => scheduled
2014-01-03 07:34	AtulOpenbravo	fix_in_branch	=> pi
2014-01-09 11:14	AtulOpenbravo	Note Added: 0063331
2014-01-09 11:42	AtulOpenbravo	Relationship added	related to 0025453
2014-01-09 12:00	extra	Note Added: 0063338
2014-01-12 12:57	AtulOpenbravo	Note Added: 0063364
2014-01-12 12:58	AtulOpenbravo	Review Assigned To	=> pramakrishnan
2014-01-12 12:58	AtulOpenbravo	Status	scheduled => closed
2014-01-12 12:58	AtulOpenbravo	Resolution	open => no change required

Notes
(0063119) extra (reporter) 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 (reporter) 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 (developer) 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 (reporter) 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 (developer) 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.