DTW Import of Invoice

[Former Member]

Hello,

I am trying to to a DTW import of our outstanding invoices from our legacy system. I used the Document and Document_Lines 1 templates in the DTW templates folder.

I filled in the fields that were required. When I start the import, I get the error msg -- "Can not find this object in B1 Application defined or object defined error 65171"

Does anyone have an idea what may be the issue here?

Thanks,

Mike

[former_member583013 · Accepted solution]

If you can explain the steps that you did in DTW, it would help.

Also paste a few lines of data from the header and rows template for me to see your data for correctness. (only filled columns)

Suda

[Former Member · Accepted solution]

How can I paste here so the text isn't all jumbled together? Easier for you to see?

Thanks,

Mike

[former_member583013 · Accepted solution]

Pick the columns you want.....paste them in a notepad and the add some dots to isolate them.

example:

RecordKey..........CardCode............CardName............DocNum........

[Former Member · Accepted solution]

This is the header and a data line from the Document Template

RecordKey...CardCode...CardName...Comments....DocDate....DocDueDate...DocNum...DocTotal ...DocType...HandWritten...NumAtCard...TaxDate

289...CAKI005...Kidsport Athletic Uniforms...IN...20080629...347016...169.80 ...dDocument_Service...tYES...233...20080515

This is the header and a data line from the Document Line Template

RecordKey...LineNum...AccountCode...ItemDescription...UnitPrice...TaxCode

289..._SYS00000000112...Opening Balance From: 347016...169.80...EX

Steps:

1. Access DTW

2. Select Invoice

3. Select Appropriate templates -- link Document and Document Lines

4. Check mapping -- everything mapped

5. Run Update, Test

6. Failed at first import

[former_member583013 · Accepted solution]

Mike

NOTE:

On the Documents template:

You do not have to fill the BP Name - leave it blank

DocTotal should be left blank. SAP calculates this automatically from the lines.

Which column does 20080629...correspond to. If it is docdate then it is incorrect as it is a future date. If it DocDueDate then DocDate is missing.

Suda

[Former Member · Accepted solution]

2008...corresponds to the DocDate. As I understood, this is the data import date. We are planning to do the final import date this weekend so that is why i set it at that date. However was trying to do a practice beforehand. Do I need to always set the date on the day of import or earlier?

Do I need to fill in Doc Due Date -- I was told to leave blank...

Does everything else look okay?

thanks!!!!1

Mike

[former_member583013 · Accepted solution]

The DocDate in general is the date of the original Invoice. It will not make be helpful to have it set as the date of import because it will show incorrect in the Aging Reports.

Therefore the DocDate and DocDueDate should be exactly as in the Original Invoice.

DocDueDate should be filled. If you are just testing the import then use the current date on the DocDate field (only if you do not have the original dates)

Rest everything looks Ok so far. Remember to enter 0 on the Discount fields both on header and rows.

Suda

[Former Member · Accepted solution]

You mean enter 0 in the Discount Percent Columns for both templates?

Mike

[former_member583013 · Accepted solution]

YES. Thats Correct.

[Former Member · Accepted solution]

Darn! Still not working -- did all changes you listed above. Anything else we could be missing?

Mike

[former_member583013 · Accepted solution]

What is the issue now? Let me know.

[Former Member · Accepted solution]

I did use the entire templates for upload -- I did not delete any columns. The columns and pasted for your viewing before were just the columns that had info -- however, when I did the DTW I kept all headers there in the original template -- just did not have any info in them. Except I added the Discount Percent at 0 per your instructions.

Thanks -- still have not resolved.

Mike

[former_member583013 · Accepted solution]

If you want send me the template and I will review them and reply back here.

sudasampath.sapb1 at gmail

[Former Member · Accepted solution]

Hi Suda -- not sure if you are there but will try to send you template I am doing now to import Credit Notes --

I was able to do Invoices, found out that in DTW I had to check the New Import rather than Update box! I thought we are always updating if the Card Code exists in the system, which it did.

I guess this is not the case for Invoices?

I will e-mail Credit Note Records

Thanks,

Mike

[former_member583013 · Accepted solution]

Cool. Then close this thread and mark it answered.

Best wishes

Suda

[former_member708266]

Dear,

Please kindly check whether following note 894035 is helpful or not:

Symptom

Error when importing a file with the DTW:

Customer record not found: Application-defined or object-defined error

65171

Other terms

template, dtw, object key, Customer record not found, delete, columns,

Application-defined or object-defined error65171

Reason and Prerequisites

Solution

When you remove unused columns from the DTW Templates, you have to keep

the object's key column s(for instance LineNum which is mandatory in

Update Mode only). Even if this one is empty, as DTW needs it in order

to import or update data.

We recommend not to delete columns from the template.

Wish the note could solve your issue.

Regards

Apple