Announcements
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
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.
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.
André Arnaud de Cal...
294,095
Super User 2025 Season 1
Martin Dráb
232,866
Most Valuable Professional
nmaenpaa
101,158
Moderator