Delivery Warehouse in Sales Order for Multi-Company Setup

dedma · February 27, 2017, 7:49am

I’m in a multi-company setup and when I am currently logged in as a user of one of the sub companies, I get an error when creating a sales order.

This user has a Sales User role and when trying to submit the SO, I get the error “Delivery Warehouse required for stock item”. Made sure the item in the SO has the Delivery Warehouse set correctly too.

Am I missing some permission/role?

dedma · February 27, 2017, 8:20am

Anyone got an idea?

JayRam · February 27, 2017, 9:40am

Warehouses are aligned with each company. So if you have BR1 as company and you are trying to make a transaction, you can only pick warehouse aligned to BR1.

So chances are, your company in the transaction and the warehouse are aligned to the same company.

Thanks

Jay

dedma · February 28, 2017, 2:41am

I have noticed what I think is an error in the behavior.

The item properties i have in the SO is set to have the default warehouse from another company, BR2.

I am now making an SO for BR1 to sell the item and it does have stock in BR1’s warehouse when I select BR1 as the delivery warehouse. However I get that error.

But if I change the “default warehouse” attribute of the item to BR1, BR1 can add it in the SO but now BR2 gets the error.

dedma · February 28, 2017, 2:43am

What I am seeing here is the “Delivery Warehouse” in the SO seems to get ignored and persists to use the “Default Warehouse” set in the item master.

dedma · February 28, 2017, 3:00am

If I do not assign a “Default Warehouse” for the item, both companies cannot add the item in the SO and both get the same error saying “Delivery Warehouse required for stock item” even if I select their respective warehouses with stock.

dedma · February 28, 2017, 6:37am

I’m really inclined to think this behavior is a bug. Unless I am missing a process/configuration.

dedma · February 28, 2017, 7:05am

filed an issue in github

github.com/frappe/erpnext

Delivery Warehouse in Multi-Company is ignored in Sales Order

opened 07:04AM - 28 Feb 17 UTC

closed 08:40AM - 29 Aug 17 UTC

dedma

stock

I seem to have encountered a bug when trying to create a Sales Order in a multi-…company setup. Here's a background: I have a running ERPNext installation that is set to handle multiple companies. The main company acts as a distributor and sells it's times at wholesale to the other companies. The other companies then sell those purchased items to retail customers. So the item masters were set to have the default warehouse with the main distribution company (AR1). So we go through the purchasing cycle of the distributor purchasing its stock from suppliers and getting them in the warehouse. We then proceed to the sales cycle where the distributor sells it's stock to the first reseller subcompany (BR1) and the items are moved out from AR1's warehouse for delivery. From BR1's side, their purchase cycle is completed and the items are now stocked in BR1's warehouse. Now on to the issue: Now BR1 initiates a sales cycle to sell the goods to retail customers. BR1 creates a Sales Order, adds the items in the sales order, indicates the "Delivery Warehouse" as Stores - BR1 which is where the items are stocked. But when saving the SO, an error is displayed: "Delivery Warehouse required for stock item". Double checked the Stores - BR1 warehouse is indicated in "Delivery Warehouse" and items are indeed in stock in that warehouse. Tried again, same error: "Delivery Warehouse required for stock item". Couldn't save the SO with this persistent error. Went to item master. Changed the "Default Warehouse" of the item from Stores - AR1 to Stores - BR1. Saved item changes. Proceeded to create an SO again as BR1, added the same items to the SO, double checked and made sure Delivery Warehouse was set to Stores - BR1. This time it saved. And got submitted successfully. Now tried to create a new SO as AR1 to sell the same item again to BR1, this time AR1 is getting the error of "Delivery Warehouse required for stock item". Went back to item master, removed the Default Warehouse item property and left it blank. Saved item settings. Tried to create SO's for both AR1 and BR1, now both companies get the error "Delivery Warehouse required for stock item" when trying to save the newly created SO's. In summary, it seems like the "Delivery Warehouse" field in the SO is being ignored and wants to persistently use the "Default Warehouse" that is indicated in the Item properties. Any feedback or workaround?

dedma · March 3, 2017, 4:06am

Anyone with some feedback on this issue? Filed an issue on erpnext github but still no feedback.

dedma · March 7, 2017, 10:09am

Does anyone have a workaround for this issue?

dedma · March 9, 2017, 1:37am

Anybody encountered this issue or has a workaround?

dedma · March 11, 2017, 11:40am

The issue has been tagged for the version 8 milestone.