Question: When I copy and paste Excel template onto Import Asset Excel Worksheet, it prompted error: “String was not recognized as a Valid Date Time.” Why?
You have maintained an incorrect Date Time in Excel worksheet.
Please check on screen for Action column, if the action is blank, means the issue occur start from this asset. This asset Purchase Date is 31/06/2019, this is not a valid date as June does not have 31st.
Correct the date at Excel template, please make sure other asset’s date column is a valid date too, then copy and paste again. Now you should be able to import successfully.
By: Park Yao 230418, Lay Swan 230425, P230426
|AutoCount Accounting 2.0 & 2.1
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations