SAP DTW -1005 Error

[Former Member]

Hi Experts,

Iam getting an error (-1005 BAD Date Value) in SAP DTW when tried to upload the XL sheet for an UDO.

I have tried all the formats even i left blank, but the issue is not getting fixed.

Can anybody suggest me some ideas please.

Thanks,

Shangai.

[Former Member · Accepted solution]

Hi Shangai,

What is your B1 version and PL?

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon,

We are using SAP B1 8.8 PL 14 --- DTW version - 88.0.14 --- API Version 8.80.232.

Is there any specific date format to follow. I have tried all these - 01/01/2010 , 20100101....etc

Any suggestions will be helpful.

Thanks,

Shangai.

Edited by: shangai Nights on Jun 16, 2011 12:36 PM

[Former Member · Accepted solution]

Date format is YYYYMMDD. You may post a line of your sample data here to check.

[Former Member · Accepted solution]

Hi Gordon,

Thanks for your reply.

As you said i have given the date format as YYYYMMDD - 20110101 but still I am getting the same error.

             Code   Name     U_ALTDOH    U_ALTSTATS    U_ALTNTCPR    U_ALTFNFST      U_ALTPRBPR   
              1        DTW    20110101     20110101     20110101             H          NGM            

Error Msg :: Unknown error -1005 !UDO ALT_HR_EMD

Thanks,

Shangai.

[Former Member · Accepted solution]

Is this UDO Master or Document type?

[Former Member · Accepted solution]

Hi........

If your UDO type is Document or Master type it creates problem.

If your UDO is No Object type then there is possibility to get it imported without any problem.....

please change the Format cell of the column into Text and then try to import.......

Regards,

Rahul