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

Can Demand forecast work for Assembly Item

(6) Share

Report

Posted on by PN-12040715-0

Hi Everyone,

I have 1 Assembly Item and one Child Item.

I go to Demand Forecast to set qty for Assembly Item.

When I run Requisition Worksheet for this Demand Forecast. There is no result.

Can Demand Forecast used for Assembly Item when running Requisition Worksheet?

Thank you.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Sumit Singh 6,528 on at

Like (3)

Report
Can Demand forecast work for Assembly Item

Hi,

Yes, forecast can drive Assembly Items. Use Planning Worksheet; Req. Worksheet works mainly for purchase/transfer.

Use Include Forecast on planning run; match Forecast Name, Location, dates/variants.

Parent must be Assemble-to-Stock with a Reordering Policy (e.g., Lot-for-Lot) and planning params set.

Component suggestions appear only if a parent assembly supply is planned.

Mark true, “Does this answer your question” if it helps.

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 4,331 on at

Like (6)

Report
Can Demand forecast work for Assembly Item

The Requisition Worksheet and Demand Forecast are designed for manufacturing planning (MPS/MRP), which works with production BOMs and routings. Assembly Items use a simpler process (Assembly Orders) that does not participate in full planning calculations.

If you want to plan for Assembly Items:

Use the Planning Worksheet instead, which can consider Assembly Items (when their replenishment system is set to Assembly).

Or manually create Assembly Orders based on the forecasted demand.

In short: Demand Forecast + Requisition Worksheet = No result for Assembly Items. You need either Planning Worksheet or manual assembly orders.

Thanks

Rishabh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,362 Super User 2025 Season 2 on at

Like (3)

Report

Can Demand forecast work for Assembly Item

How to resolve this issue:

1) Ensure Assembly Policy = Assemble-to-Stock

2) Ensure Reordering Policy = anything other than blank (Lot-for-Lot in this example)

3) If using Locations (which you should), ensure a Stockkeeping Unit exists for the Item/Location combination (with above Planning Parameters)

4) In Manufacturing Setup (regardless of Production), turn on "Use forecast on locations" and "Use forecast on variants"

5) Use the Planning Worksheet

6) Ensure your Forecast is in the Calc. Regen. Plan option

7) Ensure your Planning Horizon includes the dates set in your Demand Forecast (demo data dates in the past)

If you follow these steps, you will see a result in your Planning Worksheet. If you struggle with these settings or MRP in general, you should reach out to a partner who specializes in Manufacturing and Inventory Management.

P.S. If you selected "Fixed Reorder" or "Max Inventory" for the Reordering Policy, if your Demand Forecast doesn't drop you below your Reorder Point you will not get a suggestion (which would be the correct suggestion).

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 2,070 on at

Like (2)

Report

Can Demand forecast work for Assembly Item

Namaste ,

Demand Forecast is specially for Sales Orders and Production Orders planning where there is make-to-order strategy in item card . If assembled item is available in production order or Sales Order then you have to check for components -forecast

Demand forecast Screen do have Forecast type - Component which helps for planning components . You need to be careful about period in forecasts .

Important Note

Please refer the below link which is useful and in detial explained .

https://learn.microsoft.com/en-us/dynamics365/business-central/production-how-to-create-a-forecast

if you feel helpful , please verify the answer

Regards

Pallavi Phade

Was this reply helpful? Yes No
Suggested answer

Nimsara Jayathilaka. 4,568 on at

Like (3)

Report

Can Demand forecast work for Assembly Item

Assemble-to-Order does not operate with a Forecast. Assemble-to-Order generates the Assembly Order once an entered quantity is populated in the Sales Line. If you want the system to suggest Assembly Orders before the Sales exist, then change your Assembly Item to "Assemble-to-Stock". After that, you should receive a suggestion to create an assembly order in the Planning Worksheet.

1 people found this reply helpful.

Was this reply helpful? Yes No
Youssef Nasser 64 on at

Like (3)

Report

Can Demand forecast work for Assembly Item

Hello,

Did you manage to solve this issue, I am facing the same thing.

thank you

Was this reply helpful? Yes No
Suggested answer

Jinal P. 270 on at

Like (3)

Report

Can Demand forecast work for Assembly Item

Hi PN-12040715-0,

Please see the attached document, and try to check your settings in every card, Hope it will work.

Thank You

SS- Demand foreca...

Was this reply helpful? Yes No
PN-12040715-0 30 on at

Like (3)

Report

Can Demand forecast work for Assembly Item

Thank you Ben.

I changed KIT1 to Assembly-to-stock but system did not generate result for Demand forecast

Was this reply helpful? Yes No
Suggested answer

Jinal P. 270 on at

Like (3)

Report

Can Demand forecast work for Assembly Item

Hi, PN-12040715-0,

Please use Assembly Item to "Assembly-to-stock", and try again.

Let me know if it is still not working.

Thanks

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,362 Super User 2025 Season 2 on at

Like (3)

Report

Can Demand forecast work for Assembly Item

Assemble-to-Order will not work with a Forecast. Assemble-to-Order creates the Assembly Order when the Sales Line's Quantity is entered. If you want the system to suggest Assembly Orders prior to the Sales existing, set your Assembly Item to "Assemble-to-Stock". Then you should get a suggestion in the Planning Worksheet.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No