A1.108 : 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.
--Source from AutoCount Wiki --
Related Articles
A1.100 : Prompted Message: Import Data Error – Fail to save Item: xxx. The value of column IngredientItemCode is table ItemIngredient does not exist in its master file
Question: I have exported all data from account book ABC Sdn Bhd. When try to import all data to account book AIMI Sdn Bhd. Some of the items failed to import with error “The value of column IngredientItemCode is table ItemIngredient does not exist ...A1.113 : Prompted Message: Error during upgrade to 2-Invalid Data Definition Language Statement and ALTER TABLE dbo.ADVQT…Guid
Question: When upgrade database from 1.9 to version 2.0, error message prompted “Invalid Data Definition Language Statement, error message is Column already has a DEFAULT bound to it”. After click OK, another message prompted “ALTER TABLE ...A1.72 : Stock: Stock Card Report error - Column ‘ItemCode’ has null values in it or Column ‘Location’ has null values in it
Question: When I inquiry stock card report, it prompted error “Column ‘ItemCode’ has null values in it.” or “Column ‘Location’ has null values in it.” Why? Possible Reason : You have created a consignment document with empty item code OR empty item ...A1.102 : Prompted Message: Change Item Code error – Invalid column name ‘Key1’
Question: When I try to change item code, error prompted: Invalid column name ‘Key1’. Why? Version: 2.0 Possible Reason : The database detected POS 3 is installed, the database is upgraded from version 1.9 to 2.0, but the POS table is not updated. ...A1.116 : Prompted Message: Change Item UOM rate error – Invalid object name ‘Sync’
Question: When I change item uom rate, system prompted an error: “Unknown Sql Exception (Number = 208, Message = Invalid object name ‘Sync’.). Why? Possible Reason: The registry value failed to upgrade properly when upgrading the database. Solution: ...