Import Specail Price List by DTW

[Former Member]

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

[Former Member · Accepted solution]

Try date format 20081031. No deliminator needed for DTW.

Thanks,

Gordon

[Former Member]

It works fine after changing the date format.

thank you very much.

[former_member186095]

Hi,

I think it is caused by your record key data. it must not be 001 but it shoud be 1, 2, 3, etc.

I am sure you put the symbol ' near the zero. it is probably '001. '002, etc. this is not the requirement but it must be 1, 2, 3.etc.

Let me know if you still find error although you have change the record key to be 1, 2, 3, etc.

Rgds,