Skip to Content
avatar image
Former Member

DTW ENTER VALID CODE [OITW.WhsCode] (UPDATING Min and Max Stock)

Hi Experts,

I'm Trying to update my Minimum Stock and Maximum Stock via DTW

But I have and Error It Say Enter Valid Code OITW.WhsCode. I don't what really is wrong.I think I Inputted the Right Code for my WhsCode. Can You help me with this Guys? This is my template.

Thanks In Advance.

screenshot-1.png (18.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Aug 05, 2017 at 05:53 AM

    Hi,

    Run below query and make sure warehouse code is correct in DTW template,

    Select * from owhs

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 07, 2017 at 04:12 AM

    Hi Socrates,

    Does the warehouse code PWH8 is assigned to all the item masters.

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 07, 2017 at 10:03 AM

    Hi,

    Please leave the LineNum column empty, and try again.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 29 at 07:56 AM

    If you want to update (not create) records in OITW you will need to have one template for OITM with just the primary key (ItemCode).

    Then for OITW you need the ItemCode again and the LineNum. Leave WhsCode empty or it will error out, even if you enter the corresponding code properly. Other fields can be updated, except ones like OnHand, which need to be updated via inventory transactions.

    LineNum is the sort order (starting with 0) of the warehouses in OWHS.WhsCode. You can use this query to identify the LineNum for each warehouse in OITW (written for HANA but it shouldn't be hard to modify it to run in SQL Server).

    SELECT OITW."WhsCode", T0."LineNum", OITW."ItemCode" FROM OITW INNER JOIN (SELECT OWHS."WhsCode", ROW_NUMBER() OVER (ORDER BY OWHS."WhsCode") - 1 AS "LineNum" FROM OWHS) T0 ON OITW."WhsCode" = T0."WhsCode"


    oitm.png (5.8 kB)
    oitw.png (17.9 kB)
    Add comment
    10|10000 characters needed characters exceeded