DTW Maximum stock level must be greater than required stock level

[Former Member]

I am getting the  error: Maximum stock level must be greater than required stock level on certain items that I am attempting  to update via DTW. I am having trouble seeing what I have done incorrectly. I have attached a spreadsheet of the items that I am trying to update. I have tried imprting this as a CSV and also a Tab delimited with the same errors.

Edit: When looking into it a little more it looks like the Purchasing UOM could be the issue here. The Purchasing UOM is by Case, and  items per purchase unit are 12. Is SAP calculating the min order by 12. For the instance of the order that failed.  12 * 144 = 1728 which would be over the max stock of 864.

Am I right in thinking this?

Baby0229 Went in correctly.

Baking 002 Had the error.

Please look it over and let me know if you can see where the error is coming from.

AOA-WH.txt.zip

[former_member230931 · Accepted solution]

I think all units must be in stock keeping UOM

100 200 300 (min , req, max) should work

[former_member833706]

Dear Team,

I think all units must be in stock keeping UOM

Option 1. stock keeping UOM = (Purchase UOM & Inventory UOM) Must Be similar

Example - Purchase UOM = Roll & Sales UOM = Roll & Inventory UOM = UOM

Standard Packing = 100

For Update : Inventory Level as follows

Minimum = 1000

Maximum = 5000

Required = 3000

In this case we needs to update firstly Purchase UOM As Inventory UOM Quantity (Related updates to like Weight, No of items per purchase uom , etc)

Then You can update the Inventory Level quantities

IF you don't want to Update Purchase UOM then

Option 2 You Can update Required Inventory Level Must be in Sales UOM

You needs to update only Required Inventory Level Must Be in Purchase UOM Base

Example = Standard Packing = 100

Minimum = 1000 (in Mtr)

Maximum = 5000 (In Mtr)

Required = 30 (In Roll = 100*30 = 3000)

Suresh Kakee