Price list update by DTW

[Former Member]

Hello

i checked 903392 - DTW_How to set PriceList field for the Items_Price object

1. I created template file

2. I want update this price list (1st result select * from OPLN)

3.  Master Data > Update> Inventory >Item Master Data >Item prices (attached  1 template here). Mapping rules (pricelist should be blank but i tried also when value was in)

4. Import 0 errors but price is still OLD. Data import from excel work corectly but here i cant control erros , i have over 1k indexes to import. Any advices?

Best Regards

[Former Member · Accepted solution]

Hi Krystian,

Have you checked the setup of Currencies:

If OK... and DTW doesn't work,

you can try using Excel-Import:

Prepare in Excel your Template, but Use the real Pricelistnum like this...

Save to Text-Tabstopped-File.

I use the first line as double...

You only need the Lines A-D:

  OK - browse to txt-File...

Please look about other Price-Systems in B1:

You can use Special-Prices and the import via DTW works fine... Template OSPP.

Hope that helps.

Regards

Markus

[Former Member · Accepted solution]

Thank you for answer.

Currency looks fine:

Funny, Excel-Import works correctly, but i cant see log of import (only errors).

I have hope  Special-Prices  via DTW  will work fine... beacouse via Excel i cant import them.

[kothandaraman_nagarajan]

Please close this thread, if you got answer.