Skip to main content

Notifications

Small and medium business | Business Central, N...
Unanswered

Business Central Shipping To Subcon Then Subassembly Required

Posted on by 35

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)

  • Guy McKenzie Profile Picture
    Guy McKenzie 1,330 on at
    RE: Business Central Shipping To Subcon Then Subassembly Required

    If I've understood correctly, you want BC to reflect the following...

    You have 3 assembly steps (all variable).

    1. Internal part assembly
    2. Sub-contract part assembly
    3. Internal final assembly.

    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.

    1. Items
      1. Part assembly 1: BOM consumes raw materials
      2. Part assembly 2: BOM consumes part assemblies 1
      3. Finished Item: BOM consumes part assemblies 2
    2. Locations
      1. Own location
      2. Sub-con location.

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans