cancel
Showing results for 
Search instead for 
Did you mean: 

Error while uploading data through DTW for Good Receipt transaction

Underdog
Explorer
0 Kudos
142

In OIGN table I have maintained both DocDate and TaxDate and date format is as per given in General Settings screen, even though system is generating this error and thus unable to run the simulation.


"CServiceData::SetPropertyValueDateString failed; Invalid date format in property 'DocDate' of 'Document'65171 "


Any idea about this ?

View Entire Topic
Simo_Anddam
Explorer

Hi,

The general date format for all dates in DTW is YYYYMMDD. Try formatting the dates in your Excel file to this format and run the simulation again.

If Excel automatically changes the format of the date, set the cell format to General and re-enter the date in the required format

Underdog
Explorer
0 Kudos
In general settings screen the format of the date is set to DDMMYY, now if the set the date format of DTW to YYYYMMDD, will it work ?
Simo_Anddam
Explorer
0 Kudos
Yes, give it a try with the simulation, of course. If you hover over the DocDate cell in the header of your Excel DTW table, you'll see that the format is YYYYMMDD.