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

Can Demand forecast work for Assembly Item

(6) Share

Report

Posted on by Peter Nguyen

125

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

Jinal P. 300 on at

Like (2)

Report
Copy link

Link copied!

Hello,

Please use planning worksheet instead of Requisition Worksheet, because the Requisition Worksheet does not consider demand forecast by default.

When you open planning worksheet >> Click on calculate regenerative plan.

You will see below option for select demand forecast.

After you will see the lines as you can see in the below screenshot.

Hit as a answered if you get your answer.

Thank You

Was this reply helpful? Yes No
Peter Nguyen 125 on at

Like (1)

Report
Copy link

Link copied!

Thank you Jinal

I tried to use Planning Worksheet but it did not generate the row.

Below is my set up for Item

KIT1:

CHILD1

The Demand forecast for KIT1

I run the Planning Worksheet

It showed no row.

But when I created new Sales Order, it generated the quantity for CHILD1 in Sales Order as normal. This result is OK. But I still also need the quantity from Demand Forecast

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,918 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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
Suggested answer

Jinal P. 300 on at

Like (3)

Report
Copy link

Link copied!

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
Peter Nguyen 125 on at

Like (3)

Report
Copy link

Link copied!

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. 300 on at

Like (3)

Report
Copy link

Link copied!

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
Youssef Nasser 68 on at

Like (3)

Report
Copy link

Link copied!

Hello,

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

thank you

Was this reply helpful? Yes No
Suggested answer

Nimsara Jayathilaka. 4,950 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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
Suggested answer

Pallavi Phade 5,420 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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

Ben Baxter 6,918 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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