Update with DTW

[vasileiosfasolis]

Hello to all

i have made some pricelists and i have assigned p rices to the items.

the requirement now is to update the prices of some of the items

how can i do it because by using the DTW with Update existing or Import new it displays that the itemcode .... already exists

[Former Member · Accepted solution]

Hi,

Based on your question last year: http://forums.sdn.sap.com/thread.jspa?messageID=10776938#10776938

You have been given the idea how this DTW work.

To update existing price by DTW, you need to find out the pricelist number and put Linenum=pricelist number -1.

Thanks,

Gordon

[ashish_shah6]

Can u please here put your example ?....

[ashish_shah6]

Hi,

Can u please here put your example ?....

what is your SAP version and PL? If your SAP Version is 8.81 then please install DTW for that version.

Thanks,

Ashish Shah

[vasileiosfasolis]

Hi Asish

my SAP version is quite old

SAP Business One 2005 A (6.80.318) SP: 01 PL: 12

[Former Member]

Hi.......

Cam you please mention which DTW Template you are running in order to update Item Prices?

Regards,

Rahul

[vasileiosfasolis]

HI Rahul

i use the oItems->Items.xlt and the oItems->Items_Prices.xlt

[Former Member]

Hi.......

Are you trying to add Item Prices or Update?

I mean while running DTW which option you are going under?

Add or Update?

Regards,

Rahul

[vasileiosfasolis]

I tried both Rahul

[ashish_shah6]

Try with Import from excel option in SAP

Select

Item No., Price List Code, Price According to Price List, Price List Price Currency

In the bottom tick on check box Update Existing Records