cancel
Showing results for 
Search instead for 
Did you mean: 

Field of unit price in template

Former Member
0 Kudos

Hi

i want to import the unit price of item in the system.where is the field for that?

i tried to import it in item price template where iused the rec key of item and line number as the price list no. and mentioned the price in the price column but it didnt pick the price.

How to do this

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The "Items_Prices.xlt" Template available in the DTW Templates Folder is not correct. You have to manually create the template.

Steps to Create a Template Manually:

Log in to DTW and select Advaced -> Maintain Interface.

From the window, from the choose from list, select the 'oItems'. From here select, 'Items_Prices'

Select this and right click and select 'Create Template' .

Save the template and fill this and import.

Former Member
0 Kudos

Yes i have done so but while importing im now considering 2 temp one for items and other for itemPrice.

its giving error "This entry already exist in foll table (ODBC)"

im importing and updating both.

What to do?

Thanks

Former Member
0 Kudos

Thanks.

Former Member
0 Kudos

Hi Krishna,

Use the import from excel option

Adminisration> Data Import/Export> Data Import> Item

Update exsisting records should be ticked

Itemcode,Pricelist code, currency,price.

You should have the price list defined in SAP pror to this.

You can also visit this thread if your problem is regardind unit price in documents

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

What you can upload is item price for each price list. The template is Items_Prices under oItems. You can check forum to find the detailed data formats. If you are trying to update marketing document, please specify.

Thanks,

Gordon