FA Troubleshooting: Import Asset error-String was not recognized as a valid Date Time

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?

Possible Reason:

You have maintained an incorrect Date Time in Excel worksheet.

Solution:

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

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations