Skip to Content
0
Former Member
Mar 04, 2009 at 05:16 PM

last purchase price and item

360 Views

Hello,

I want to use either the SAP Data Import from Excel function or the DTW to update our items to show the Last Purchase Price as the price list in the Inventory Item Master Data, field OPLN ListName.

If I look at the OPLN database for all the price lists, the Last Purchase Price does not have a code. Looking further, under Inventory, Price Lists, Price Lists, then do a find on all price lists, then print the table, I see that Evaluated Price is listed as #1, Last Purchase Price is #2, then my created price lists are #1, #2, etc.

How can I update the ListName field to reflect the Last Purchase Price without having to do each item manually?

Thanks,

Shelby