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

DTW Warehouse Code Error

Posted on Feb 14, 2017 at 02:48 PM 623 Views

Hi,

Please find attached the issues I am seeming to have with DTW. I am trying to update the Min Stock Levels for a Part No. for a Warehouse. This is only a trial with one part number and one warehouse.

The steps i am chosing for DTW are as followed; Data Type - Master Data, Operation Type - Update Exisiting Data, Business Object - Inventory/Item Master Data, Data Source - ItemWarehouseInfo in *.txt file (of which i have attached the excel spreadsheet), Map Objects Fields - Source Fields (ParentKey, LineNum, MinimalStock, WarehouseCode) Target Fields (ItemCode, LineNum, MinimalStock, WarehouseCode), Eroor Hnadling 'Ignore up to 2 Erros and Process Valid Records'. Then i run simulation and the error message i have is attached.

Any suggestions please?

Regards

Tom

oitw-warehouse-template-dtw.jpg rror-message-dtw.jpg

warehouse-code-dtw.jpg (85.5 kB)
error-message-dtw.jpg (55.4 kB)
oitw-warehouse-template-dtw.jpg (390.9 kB)
SAP Business One
Add comment
10|10000 characters needed characters exceeded

5 Answers

  • Best Answer
    author's profile photo Johan Hakkesteegt
    Johan Hakkesteegt
    Posted on Feb 15, 2017 at 07:14 AM

    Hi Tom,

    Could you please test once more, but this time make sure that the warehouse code in the text file is CowRic instead of cowric.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Feb 15, 2017 at 08:36 AM

      Hi Johan,

      I have not deleted any fields within the template and i have changed the warehouse to CowRic, still no avail. I have seemingly tried every possible scenario.. Very frustrating.

      Regards

      Tom

  • author's profile photo Nagarajan K
    Nagarajan K
    Posted on Feb 14, 2017 at 03:11 PM

    Hi,

    1. Where is remaining fields in OITW template?

    2. How did you get line number?

    Do not delete any fields in the template.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Nagarajan K
    Nagarajan K
    Posted on Feb 14, 2017 at 03:27 PM

    Just checked in my database using OITW template provided with correct line number.

    To find correct line run below query, please refer SAP note 1328706 - DI API/DTW_How to add/update WarehouseInfo to Items

    Add comment
    10|10000 characters needed characters exceeded

    • Johan Hakkesteegt Former Member
      Feb 15, 2017 at 07:13 AM

      Hi Tom,

      In pre-9 versions of B1, it was recommended to remove unused columns, because there was a risk that the DTW would update such fields to null or an empty string. Apparently this has been fixed since, and now SAP's official advice is to not remove columns. Personally I would use the old method, and always test on a test database first, but you should make and own that decision yourself.

      Regards,

      Johan

  • author's profile photo Nagarajan K
    Nagarajan K
    Posted on Feb 14, 2017 at 10:25 PM

    Follow query stated in SAP note to find line number. Your query is not correct. Deletion of field in template is not allowed. This is DTW standard requirement.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Johan Hakkesteegt
    Johan Hakkesteegt
    Posted on Feb 15, 2017 at 09:03 AM

    Hi Tom,

    One more. In the B1 client, please look at the item master data for the item in the text file. Has the warehouse CowRic been assigned to this item?

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded