Skip to Content
avatar image
Former Member

Data Error

Hi All,

When importing invoice for opening balance need using DTW, I've got error message:

"customer record not found[INV1.ActDelDate][Line:1]Application-defined or object-defined error..."

The SAP B1 version used is 2005A SP01 PL50.

Pls give advice. Thx

John

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 20, 2008 at 03:50 PM

    Hi John,

    What date format is in your data? It should be yyyymmdd.

    If you have right format but still get error, please post some of your sample data here.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2008 at 03:53 PM

    Hi,

    Please check Note No. 894772 regarding the issue.

    Check if it helps.

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 04:28 PM

    Dear John,

    Please check the following 2 things :-

    1. Please make sure that the Customer code that you have entered in the template is present

    in the database. If not please add the customer code in the database then import the data.

    2. Please make sure that you have correctly filled the data in the DTW template file as per the

    information present in DI API help file. Also please do not remove any column in the template

    if you do not want to enter any data in a particular column then please leave it as a blank column in

    the template.

    Regards,

    Rakesh Pati

    SAP Business One Forum team

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 22, 2008 at 04:00 AM

    Dear All,

    tks for answers. I will try

    John

    Add comment
    10|10000 characters needed characters exceeded