We have a business that has been broken out into 17 different warehouse. This is done as the owners want to see a P&L for each. Things get further complicated because in order to fulfill a sales order, we may have to pull items from multiple warehouses. The problem lies in that Acumatica won't allow different warehouses on one sales order. Thus, if you must pick from multiple warehouses or have items from multiple warehouses on a single sales order it won’t work. And we do for practically every order, especially with the way that it is set up currently. For it to work you would have to invoice from the warehouse the item is picked from, which would cause multiple invoices for a single order (as well as multiple POs), which doesn’t work either.

Because this is an issue of trying to create P&Ls, does anyone have a suggestion in regards to the best way to tackle this within the capabilities of the system?

We are on Acumatica Cloud ERP 2022 R1
Build 22.113.0040 +