Skip to Content
avatar image
Former Member

DTW WarehouseCode Error

Hi,

I want to do a DTW to set the Minimum Stock Levels for a number of parts to multiple warehouses. Even doing a test on one ItemCode including the LineNum, MinStock & WhsCode the erro message once running the DTW is 'Enter Valid Code [OITW.WhsCode], 'P1377700000'65171'. P1377700000 is our part number. I have tried numerous WhsCodes and the same result is occuring.

Any ideas people?

Regards

Tom

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Feb 15, 2017 at 11:30 AM

    Hi tom

    Can you attach sample template you are using for Upload

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15, 2017 at 07:42 AM

    Hi

    which format are you using for the warehouse codes? If you have '01', '02',..., please check the Excel file and change these cells to Text before importing in SBO.

    Or if you are using a text file to import, modify this data in the same way.

    Kind regards

    Agustín

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Agustin,

      The format I am using is CowRic for one of our engineers out in the field. I have changed the cells to text, still same error message.

      Regards

      Tom

  • avatar image
    Former Member
    Feb 15, 2017 at 10:11 AM

    Hello Tom,

    I believe you will require whsecode of the item, like shown below for item 777 if you want to use 05 warehouse then use code = 2

    Hope this helps

    Thanks

    DM

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15, 2017 at 12:06 PM

    Hi

    run this query:

    select * from owhs

    And compare the field whscode with the value you are using in the template.

    If they are different change for the obtained value in the query.

    Kind regards

    Agustín

    Add comment
    10|10000 characters needed characters exceeded