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)
If I've understood correctly, you want BC to reflect the following...
You have 3 assembly steps (all variable).
Really, there are two approaches to this.
To fully reflect everything correctly in BC, you require 3 levels of Item codes for assembled items and 2 location codes.
You output part assembly 1 items at your own location.
You transfer these items to the sub-con location
You output part assembly 2 items at the sub-con location
You transfer the goods to your own location.
You output the finished item.
Whilst this sounds like a lot of work, with Stockkeeping Units setup properly and using the planning worksheet, the admin is actually pretty simple. However, the fact you are using bespoke BOMs and doing this all outside BC, you may have importing complexity to manage.
Alternatively, you just use one BOM and Routing with a subcon step. I suspect this is what you are currently doing. As you rightly identify, the detail of what stage things are at and where they are is not great.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156