cancel
Showing results for 
Search instead for 
Did you mean: 

DTW Import of Invoice

Former Member
0 Kudos
738

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member583013
Active Contributor
0 Kudos

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
0 Kudos

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

Thanks,

Mike

former_member583013
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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

Mike

former_member583013
Active Contributor
0 Kudos

YES. Thats Correct.

Former Member
0 Kudos

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

Mike

former_member583013
Active Contributor
0 Kudos

What is the issue now? Let me know.

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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

sudasampath.sapb1 at gmail

Former Member
0 Kudos

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
Active Contributor
0 Kudos

Cool. Then close this thread and mark it answered.

Best wishes

Suda

Answers (1)

Answers (1)

former_member708266
Contributor
0 Kudos

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