web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Demand forecast for Transfer Items

(0) ShareShare
ReportReport
Posted on by 496

Hi,

I have setup a demand forecast per Location (based on sales and Assembly component Usage). Stock keeping units for the client is set to Purchase into one location and then transfer to the other locations. I have setup each of these as Lot-for-Lot method. The issue I have is that it seems to ignore the demand forecast for the items where the stockkeeping unit is set to Transfer. Even though the item has a small safety stock qty, they want to be able to calculate a Trf qty based on the demand forecast. I can get it to work IF the stockkeeping unit is set to Purchase.

Here is an example. Item is stocked in Location A and B. Location A = Purchase and Location B is set to transfer from Location A

I have setup both as Lot-for-Lot

I created a demand forecast for each location as 100qty because I sell 100 out of each location.

When I run the Replenishment with demand, I would expect to see:

Qty to Purchase for Location A = 200 (sales demand of 100 + 100 needed for Location B)

Qty to Transfer of 100 for Location B

Instead it only returns 100qty for Location A.

Hopefully someone can advise. Perhaps I am missing a setting or have a setup issue.

Thanks for the help

Debbie

I have the same question (0)
  • Alfredo_Iorio Profile Picture
    1,264 on at

    Hi.

    The missing supply into location B might be due to the lot-for-lot parameters. What do you have in the lot accumulation period? Also, how far does your demand forecast go? If you can share the entire setup you have on SKU for location B I might be able to help.

    It looks like the setup is correct on SKU for location A. The gap is on location B.

  • Guy McKenzie Profile Picture
    1,340 on at

    Are you using the planning worksheet or the requisition worksheet?

    You need to use planning worksheet to plan transfer orders.

    Other things to check: your filters when running calculate plan. E.g. Dates, location filters.

    If you have already got actual demand in the forecast period that exceeds the forecast qty the forecast won’t create any further supply orders as the qty has already been fulfilled. 
    e.g. if your forecast frequency is monthly and you have already had sales of 100 in that month from location B, the forecast amount has already been fulfilled and nothing will be planned. If you have sold 10 that month, the remaining balance of the forecast (90) will be planned for.

    Do you have the transfer from code populated in sku for location B?

    What type of demand forecast have you entered? Sales forecast or component forecast at location B?

    Lastly, if you’ve been changing lots of parameters and running planning multiple times, refresh your browser to clear any cached data and try again. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,042 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,077 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,068 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans