Skip to main content

Notifications

Announcements

No record found.

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

Create components forecast to when production plan of finished product and quantity of component consumed for each finished product is known.

(0) ShareShare
ReportReport
Posted on by 60

Hi All, 

How can I create components forecast on weekly basis and possibly receive automatic notifications for ordering the components when we have the following parameters known

- Quantity (Pieces) of finished products that we plan to produce every month is known. For example 4000 pieces per month from July to September and 6000 pieces per month from October to December.

- Our finished product is an assembly of 16 different components. So, BOM is defined.

- Delivery time from PO date for all components are known.

- Re-order principle that we are thinking now is to initiate the Purchase order to the supplier when the component level reaches 2 weeks of production inventory. Or we can also define the re-order level with a fixed quantity for each component.

I am trying now "demand forecast" and "requisition worksheet" pages to explore how this can be done but If I can get some ideas here it will help me in faster implementation. Thanks!

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