Skip to main content

Notifications

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 157

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

  • Guy McKenzie Profile Picture
    1,330 on at
    RE: Demand forecast for Transfer Items

    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. 

  • Alfredo_Iorio Profile Picture
    1,260 on at
    RE: Demand forecast for Transfer Items

    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.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans