Accounting 2.0 - Stock: Stock Card Report error - Column ‘ItemCode’ has null values in it or Column ‘Location’ has null values in it

From AutoCount Resource Center

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?

Itemcode null value1.png


Itemcode null value2.png


Possible Reason :

You have created a consignment document with empty item code OR empty item code and empty location.

This is a known bug happens in 2.0.28.196 and this issue is fixed in version 2.0.28.197.


Solution :

Please update the Version 2.0.28.197 or later. You should be able to inquiry the stock card report without error.


By: Soh Wee 220414, Lay Swan 220426, P220428



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations