Error when using DTW to migrate Invoices

[Former Member]

Hi all,

I'm trying to migrate Invoices from a DB to another. I use two .csv files, one for the headers and one for lines. When it finishes the process, it doesn't import any of the 79 invoices and it shows the following error message:

"Customer Record Not Found / Application-defined or object-defined error oinvoices"

I use the headers file on Queryparam and on Documents, and the lines file on the Document_Lines. When I don't use any file on QueryParam, i get the error "A source file must be provided". Any ideia?

Kind regards,

Pedro Santos

[former_member583013 · Accepted solution]

Pedro,

If your DTW version has QueryParam then you need to link the header file to this. You did it right.

But the QueryParam's were only shown in Old Patch level for SBO2005.

Please let me know which version of SBO you are using and Patch level?

Also let me know if you are importing a Service or Item type invoice?

When you say one DB to another I am presuming that both database are SBO company databases.

The error points at BPCode not in BP Master.

If you want to send the template send them to sudasampath.sapb1 @ gmail.com

I will take a look and reply you here.

Best regards

Suda

[Former Member]

Hello Pedro,

First of all, you must check if the codes of custormers in source company do exist in target company.

It seems to me that this could be the problem.

You could try to set DTW with no rollover to see which records cause the error.

Hope this helps.

Regards.

[Former Member]

The codes of customers in source company exist in target company, so that's not the problem. Is it possible to send you the files by e-mail so you can check it?

We are trying many ways but none is resulting. Thanks

[former_member186095]

Hi,

I've got a certain PL that there is a queryparam in one part of the DTW, I am not sure but prior to PL 39, I think it is 36. Anyway, what PL and version you are using ?

The query parameter must be use. you must include it or fill it with header template. then, the same file fill it too to the next level until template for document_lines.

About the error, you must make sure the customer code in the source database must be same with target database. In the step 3 of data import wizard (DTW), you must check map rule. See if source field and target field (B1) columns entries must be same and not empty especially for cardcode. So, cardcode in source field and target field must be same and avaialable in both.

Rgds,