DTW - Method of object failed

[Former Member]

Hi

I'm trying do do an import of AP Credit Notes and getting the error 'Method '_{' of object '}' failed 65171'.

No matter what I try - can't get past this one. Has anyone seen this before?

Regards

Danie

[Former Member · Accepted solution]

Hi,

In the Documents --> Record key, Card code, currency, docdate, docduedate

document lines --> Record key, Price, Item code, quantity

are the fields required. Check if you Record key is correct how many lines you have in the AP credit note document lines .

If Record key in Dcuments is 1 and the Document lines have five rows the all the record key in the rows needss to be 1 for five rows.

Regards,

Rakesh N

[Former Member]

Hi

Thx for all the suggestions - I tried them all - but still get the error - I tried a similar import on the demo db (OEC Computers) on my laptop - no problem there - so I'm going to uninstall and reinstall the DTW on the company machine and see whether the DTW is maybe corrupt/broken.

Regards

Danie

[Former Member]

Hi

I have the following columns in my

Header:

Record Key - 1, 2, 3, ......

CardCode - V-TRA007......

Comments - Credit Inv no 6316 .....

DocCurrency - R

DocDate 20110125

DocType - dDocument_Items

Lines:

ParentKey - 1, 2, 3,3, 4, 5,5,5, 6.......

No LineNum as this is new import not update - Although it makes no diff to the error I'm getting

BaseEntry - which is DocEntry of PCH1 (Although DocNUm and DocEntry are the same in both tables)

BaseLine - corresponds to the line no's in PCH1

BaseType - 18

CostingCode - PC

ItemCode - SFEE_Accomod

Price - 171.05

Quantity - 1

VatGroup - I0

Warehouse - FCS-FIND

Regards

Danie

[Former Member]

Hi Danie,

The line num for lines should start from zero. Also, please include Doctotal in order and use tax in lines as well and make sure that the total in lines after taxes matches that mentioned in document header.

Thanks,

Joseph

[Former Member]

Hi Danie,

Header:

Record Key - 1, 2, 3, ......

CardCode - V-TRA007......

Comments - Credit Inv no 6316 .....

DocCurrency - R (are you sure you currency is R just leave it empty it will take the local currency)

DocDate 20110125

DocType - dDocument_Items

Lines:

ParentKey - 1, 2, 3,3, 4, 5,5,5, 6.......

LineNum - 0,0,0,1,0,0,1,2,3,0..

BaseEntry - which is DocEntry of PCH1 (Although DocNUm and DocEntry are the same in both tables)

BaseLine - corresponds to the line no's in PCH1

BaseType - 18 ( Try to leave this field empty as you will be importing AP credit selection)

CostingCode - PC

ItemCode - SFEE_Accomod

Price - 171.05

Quantity - 1

VatGroup - I0

Warehouse - FCS-FIND

Regards,

Rakesh N

[kvbalakumar]

Hi Danie,

Give a try to this,

if you are using csv(comma delimited) format for import, just try once with Tab delimited.

Regards,

Bala

[Former Member]

Hi Danie.......

I would suggest you to keep your Cell Format of your Template as Text and then try........

Regards,

Rahul

[Former Member]

Hi danie,

What is the document type that you are using on header?

Thanks,

Joseph