Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Import Specail Price List by DTW

Hello all,

I'm trying to import a Special Price List to expired the current price record, but I get the following error message:

"Method '' of object '' failed65171".

Here is the content of my SpeicalPrices.xls and SpecialPricesDataAreas.xls

RecordKey CardCode ItemCode AutoUpdate Currency DiscountPercent PriceListNum Price

RecordKey CardCode ItemCode AutoUpdate Currency DiscountPercent PriceListNum Price

001 S10001 35823

002 S10002 31972

003 S10004 23800

The DateFrom of these items are 2008.09.01, and now I want to set the Expiry Date to 2008.10.31

RecordKey LineNum AutoUpdate DateFrom Dateto Discount PriceCurrency PriceListNo SpecialPrice

RecordKey LineNum AutoUpdate DateFrom Dateto Discount PriceCurrency PriceListNo SpecialPrice

001 0 2008.10.31

002 0 2008.10.31

003 0 2008.10.31

Thanks

Edited by: hkcm hkcm on Sep 29, 2008 5:54 AM

replied

Try date format 20081031. No deliminator needed for DTW.

Thanks,

Gordon

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question