Accounting 2.0 - Prompted Message: Import Item Opening error - Cannot insert the value NULL into column 'Guid'

Question: Error message prompted - Cannot insert the value NULL into column ‘Guid’…when import Stock Item Opening at AutoCount Accounting Management Studio. Why?

Possible Reason :

This is due to you did not create the stock location before import.

This is a known bug as the system is supposed to auto create the Location while import and this issue is fixed in version 2.0.28.196.

Solution :

Update to Version 2.0.28.196 or later, and you should be able to import Item Opening.

If you do not wish to update your version, the alternative solution is manually create the stock location before import.

Below is the excel template which location KL is not created yet.

Go to Stock > Stock Location Maintenance, to create new stock location ‘KL’.

Then you should be able to import the Item Opening successfully.

By: Ju Lee 220413, Lay Swan 220414, P220418

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