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 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.
--Source from AutoCount Wiki --
Related Articles
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. ...
A5.92 : Stock - Reports : Stock Card
This function allows you to generate Stock Card report. Stock Card is used to track and trace the movement of stock including purchases, sales, adjustments and transfers. It can also be used to check against your stock balances and calculation of ...
A5.90 : Stock - Transactions : Stock Transfer
This function allows you to manage your Stock Transfers. Stock Transfer is usually used to transfer stock from one location to another location. *Stock Transfer will deduct your stock from the source location (From Location) and add into the target ...
UBSA1.186 : Access UBS (Accounting): How to set up the maintain stock values
DescriptionHow do I ensure the balance of the stock will include in the P&L report? How do I set up OS, BS and CS? Why my stock account is not appearing in report? EnvironmentAccess UBS (Accounting) Solution To set up the maintain stock values: Go to ...
A5.89 : Stock - Transactions : Stock Adjustment
This function allows you to manage your Stock Adjustments. Stock Adjustment is usually used to adjust the quantity of your stock due to specific reason such as stock damage, loss etc. *Stock Adjustment will add or deduct your stock quantity depending ...