Hi Jiwan,
It seems to be a problem when you have stocking limits for the same location and multiple items, right ?
I found something similar reported here :
https://fix.lcs.dynamics.com/Issue/Details?bugId=282355&dbType=3&qc=49f39407081b9f455ce89efc3bc1e4d4dbb6ecbf79bcf532a26728a4f96d3212
Issue 282355 - By design
Item specific location stocking limits does not work to split put at multiple locations
Product and version: Finance and Operations
Release: 10.0.7
PROBLEM
When running with multiple items within the same location and wanting the system to split the stock by using Location stocking limits, per location and item combination, the system does not automatically split the put work lines according to the defined quantities.
Example:
Given:
Two empty locations without any incoming work and both allowing mix of item numbers.
Location stocking limits defined as:
Location#1 - Item#1 - Qty30
Location#1 - Item#2 - Qty30
Location#1 - Item#3 - Qty30
License plate packing structure (ASN) for:
LP#1
- Item#1 – Qty60
- Item#2 – Qty60
- Item#3 – Qty60
When:
Processing License plate receiving for LP#1
Then:
Put-away work does not get split according to:
Location#1 - Item#1 - Qty30
Location#1 - Item#2 - Qty30
Location#1 - Item#3 - Qty30
Location#2 - Item#1 - Qty30
Location#2 - Item#2 - Qty30
Location#2 - Item#3 - Qty30
REMARKS
Microsoft has evaluated the reported issue and concluded this is by design.
Based on current design when using the Location stocking limits with item number level selection criteria’s, the application will select a valid Location stocking limit record and use the defined quantity as part of the limit for the Location quantity.
Thereby the result for the above scenario will be that the put-away work does get split like:
Location#1 - Item#1 - Qty30 (Total limit for Location#1 - even though the quantity is assigned as part of a line including the item number)
Location#2 - Item#1 - Qty30 (No limit for Location#2)
Location#2 - Item#2 - Qty60 (No limit for Location#2)
Location#2 - Item#3 - Qty60 (No limit for Location#2)
Regarding the last point:
One more observation, if the stocking limit is set for Item A as 100 in location A and 150 in location B. The expectation is 100 can be stocked in location A and 150 can be stocked in location B. Altogether it is 100+150 = 250 ea, however is it considering 100 in location A and 50 in location B. Max is 150. If the overall quantity goes beyond 150 we get item allocation error. Is this expected ?
This looks like an issue, and I suggest you to open a ticket with Microsoft support to investigate further.
Thank you,
Alina
