Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

BOMs and multiple warehouses

Posted on by 5

Hello All,

I'm a product design engineer responsible for managing all part data and BOMs in our Dynamics AX 2012 system. My employer recently consolidated manufacturing at a sister company within our corporate structure which is bringing on many changes and challenges. One of which is multiple warehouses and how to control which warehouse a BOM common between production and spare parts draws from.

Previous to the change everything was under warehouse 501 and all parts, BOMs, BOM lines etc. were set-up for this. We have added warehouse 502 for all spare part and accessory kit orders to draw from, maintaining 501 for production. We have many kit BOMs that are used in production that are also sold to dealers/customers for in-field install. Given this situation, when a kit is sold through parts, it relieves inventory from our production warehouse, 501 instead of 502. This brings forth the following question:

Is it possible to add warehouse 502 to these existing BOMs in a way that will relieve the inventory for a sales order from 502 and not production warehouse 501 while ensuring that production orders still relieve from 501 ?

Right now, the only solution our management has been to create new BOMs for each of the common BOMs for warehouse 502. This is a slippery slope as many BOMs are multilevel. I'm hoping for a better, if not simpler, solution to this problem.

Regards,

Robert Sherrod

Categories:
  • RTSherrod Profile Picture
    RTSherrod 5 on at
    RE: BOMs and multiple warehouses

    Hello Oleksiy,

    Seems we only use routing within Product Configuration Models, not at the BOM or item level. So using this method may create more work that I'm trying to save. I'm still looking into it, but I may have to cut my losses and just go with the original plan of creating separate BOMs for our parts sales.

    Also, I somehow accidentally clicked on the action to report your post as abusive. I could not figure out how to cancel that unintentional report. I apologize for any inconvenience.

    Regards,

    Robert Sherrod

  • Oleksiy  Khoroshylov Profile Picture
    Oleksiy Khoroshylov 1,740 User Group Leader on at
    RE: BOMs and multiple warehouses

    Hello Robert,

    I have not found a good blog on the subject. Try testing to see if you get the required results. I would start with a singe BOM that has "resource consumption" box checked for all lines and therefore warehouse. I would then create 2 routes, both for the same site as your BOM. One route will have operation with resource requirements for resource group A and another route for resource group B. Then make sure to specify different input warehouses for resource group A and B. Then create production order and select the first route. Generate picking list journal (for example, by starting production order) and check what warehouse is specified on picking list journal lines. Then do the same test but use the second route. You should see a different warehouse on picking list journal lines.

  • RTSherrod Profile Picture
    RTSherrod 5 on at
    RE: BOMs and multiple warehouses

    Hello Oleksiy,

    Thanks for the reply. Much of what you mentioned I'm mostly unfamiliar with. I will present your solution to our supply chain manager and our AX Administrator to see if this can be implemented. It may take some effort up front, but it will be better than managing two identical BOMs under different part numbers for each case.

    I will also look up resources for guidance on this. If you know of any, please advise. It will be greatly appreciated.

    Regards,

    Robert

  • Oleksiy  Khoroshylov Profile Picture
    Oleksiy Khoroshylov 1,740 User Group Leader on at
    RE: BOMs and multiple warehouses

    If the goal is to maintain the same number of BOMs but have a flexibility to consume items from different warehouses, then you may consider setting BOM lines with "Resource consumption" set to Yes. This action will disable warehouse selection on BOM line. You will then need to create 2 route versions (assuming you use these currently) and specify 2 different resource groups for the first operation. Finally, you can assign different input warehouse to each resource group.

    Once that is done, all you need is to do is to select correct route version when you create new production order. This will determine resource group that will be used and therefore input/consumption warehouse.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans