Why the Projects: Spreadsheet Expenditure Entry WebADI doesn't validate the Expenditure class and Ex

Dear Experts,

The Projects: Spreadsheet Expenditure Entry webadi rejects validation for Expnd Type Class. Then if I enter Expnd Type Class although it is not a mandatory field in the webadi excel, the error goes away. Now the error is at the Expnd Ending Date. It didnt get rejected during pre validation, but got rejected at the Transaction Import. Can you kindly say why is it so?

I came across a note 986897.1 which says not all validations are performed in web adi pre-validation to prevent performance issues.

So can you suggest what should I enter the correct expenditure ending date so that it doesn't error out in Transaction import. Basically none of my expenditure batch created using WebADI has gone through successfully in transaction import. During pre approved expenditure batch creation we dont get such issues.