Skip to Content
author's profile photo Former Member
0
Former Member

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

Posted on Aug 05, 2017 at 02:19 AM 1.2k Views Last edit Aug 05, 2017 at 02:20 AM 2 rev.

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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Nagarajan K
    Nagarajan K
    Posted on Aug 05, 2017 at 05:53 AM
    0

    Hi,

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

    Select * from owhs

    Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Balaji Selvaraj
    Balaji Selvaraj
    Posted on Aug 07, 2017 at 04:12 AM
    0

    Hi Socrates,

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

    Regards:

    Balaji.S

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Johan Hakkesteegt
    Johan Hakkesteegt
    Posted on Aug 07, 2017 at 10:03 AM
    0

    Hi,

    Please leave the LineNum column empty, and try again.

    Regards,

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Mike Davis
    Mike Davis
    Posted on Jan 29, 2019 at 07:56 AM
    0

    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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.