Passing an order to WMS?
We have software (in house developed using turbogears) that handles are picking and packing. Orders flow in and are batch/waved picked so that a picker pushes a cart around and is picking 1-8 orders at a time into containers on the cart. They are then given to the packer that scans them and puts them into boxes and then ups/fedex software pulls the shipment details from the system for things like box dimensions, ship method, address... you get the idea.
The system needs to be able to do routing and also support stock that can be in multiple locations. From my research(not a lot maybe a couple days worth) there doesn't seem to be a good way to do this with current app/modules.
Since this is sitting on postgres can a break be entered into the the work flow so that after the order is "processed" it goes into a delivery status where the order is locked from changes. Our wms then is watching for orders in the table that get marked with this status and then they can pull it can pull the order into its system to do its thing?
I would like to be able to just push locations info from openerp (if it supports stock in different locations warehouses) and then just handling the picking,routing, packing shipping in our wms. Once worldship is finished it would write back a record to a table that would signify to openerp or our wms doesn't matter that would then somehow update the order for shipped/backordered (assuming stock could be wrong) and then have it generate the invoice automatically so its just waiting to be posted in the daily sales journal?