DTW Min & Max Stock levels not updating

[Former Member]

Good Day,

Please assist, I need to update min and max stock levels for the same items in three different items.

I am using DTW OITW as Inventory is managed by w/h.

I keep getting the error message item already exists. I started the Linenum with 0.

I used item code, minstock and maxstock.

Please assist.

Regards,

Izak

[Connor_L]

Hi All,

Old question, but I have been having this problem recently and figured out something that works.

You need the following columns:

ParentKey	LineNum	MinimalStock	MaximalStock	WarehouseCode
ItemCode	LineNum	MinStock	MaxStock	WhsCode

All of them should be what you expect, but line num is the funny one.

Turns out that the line num column needs to be the line number the wharehouse would be on when ordered alphabetically counting from 0 instead of 1. So:
SELECT T0."WhsCode",
ROW_NUMBER() OVER (ORDER BY T0."WhsCode") -1 AS "RowNumber"
FROM OWHS T0
ORDER BY T0."WhsCode"

Gives me a table of the corresponding line num to each warehouse. I can the VLOOKUP this in excel while creating the file to populate the linenum column. 

Hope this helps 🙂

Connor

[Former Member]

Good Day, All,

Ok so i tried your suggestions, still getting the error.

My scenario is as follow.

Items are managed by Warehouse.

I need to update the min & max stock levels as well as the min order.

On OITW template I have all the fields that I need.

Most of the items are in all three warehouses.

Items     WH

101         CAP

101          JHB

101          NAT

I still get the error message although a specify the warehouses.

Regards,

Izak

[Former Member]

Hi Experts,

So I tried all the suggested solutions mentioned above.

I still get the error message.

I'm using the OITW Template and update the data seeing that the items already exist and I only need to update it.

All the items are available in three warehouses, same item number but in three different warehouses.

Please assist, I need to get this sorted.

Kind Regards,

Izak Potgieter

[former_member205766]

Hi Izak

You want to update by warehouse wise or on Item Level?

For Item Level you may use OITM template for DTW

and for Warehouse you may use OITW and OITM DTW template...

Also check the below link it may helps you

With Regards

Balaji Sampath

[Former Member]

Good Day,

I need to update by warehouse because the items is managed by Warehouse.

I tested it but still get the same error message.

Remember most items are available in all three Warehouses.

Regards,

Izak