Skip to main content

Notifications

Announcements

No record found.

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

Setting up planning worksheet-for offsite subsidiary production

(0) ShareShare
ReportReport
Posted on by 5

Hey!

Here is the scenario. In any given batch, we have ~400 different items, split into ~5 sizes each(luxury clothing) at around 50k pieces produced in total. We would like tho have a full MRP-MPS setup for this.
We have sales orders uploaded to the system, all of them open from our main warehouse location.
We have our items set up correctly, with boms, routing codes, work centers.

In my mind, i think it should work something like this, when running the planning worksheet.
We should get offers for the following.

  1. New production orders for all the finished good items(location codes set to the given subsidiarys location)
  2. New purchase orders for the required raw materials (location codes set to our main rawmat location)
  3. Transfer orders, for all the rawmaterial between our rawmat location, and the subsidiary location.
  4. Transfer orders for all the finished goods between the subsidiary location and our finished goods location(where the sales orders are set)

With all of this, our rawmat consumption would arise in the correct location, and all the rawmat+finished good would be at the correct location.

The problem we are having currently, is that running the planning worksheet, the generated prod orders are set to the locations of the sales orders, and no transfer order offers are listed. (we can update these with a config package, but i believe it should run fully automatically)
What setup are we missing? What setup is supposed to drive the location codes and the generation of the transfer orders?

Thanks,

Mike

  • Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    RE: Setting up planning worksheet-for offsite subsidiary production

    if the sales orders are from the main location, the production orders will be created for the main location as well. if you want the production orders created for subsidiary location, sales order should be from those location as well.

    you could change the location for the production orders manually, so creating components demands for those locations.

    to create transfer orders from main raw material location to subsidiary location, you need to set up sku for raw material with replenish method as Transfer, from main raw material location to a subsidiary location. e.g. component ABC, SKU location Blue, Replenish: Transfer

    Transfer from: Main Raw location.

    the finished products will output to each subsidiary location. If you want them transferred to the main location, you need to do that manually I believe, cause the transfer from and transfer To is one on one relation.

    This means if the SKU replenishment is set to transfer for the main location, user could only pick one subsidiary location as the transfer from location.

    I know this might not meet all your requirements, which seem to be difficult for out of box planning functionality to handle.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans