Good Afternoon All,
We have a very specific issue with our solution and I'm wondering if anyone has any ideas.
Our sales team are currently using an excel sheet as a pricing tool which is then converted into BC using a bulk edit configurator so we can bulk update the data.
Once in BC, the sales order is created and in turn the released production order using a specific button and the subcontract orders using subcontracting worksheets.
The order then goes onto our shop floor and is always cut, sometimes is pressed then palletised and shipped to the subcon, sometimes its presses, then fabricated and shipped to the subcon via a pallet. It is then brought back to the plant for sub assembly so 2/3 items that have been shipped on different pallets and could be different colours are brought back and sub assembled into a single unit to be shipped to the client on pallet.
The problem is to put the original goods (the 2/3 items) onto a pallet, BC expects them to be stock so the item is completed in the routing operations, but we are then painting it, transporting it back and then sub assembling to be able to ship it to the client.
Does anyone have any ideas / solutions around this.
note: one of our sales orders could be for 300 one off parts (if these parts are each made up of 2 components) this would be 600 items, these can be processed at different times, leave our plant at different times and all be brought back for the sub assembly process to happen)