Troubleshooting: Error - Column 'Loc-1Qty' does not belong to table StockBalByLocation

From AutoCount Resource Center
Jump to navigation Jump to search

Question : When I enquiry Stock Balance by Location report, error message prompted: “Column 'Loc-1Qty' does not belong to table StockBalByLocation”. It happens only when I filtered the location PJ. Why?

Loc-1qty1.png

Loc-1qty2.png


Possible Reason :

It could be when importing stock item opening, the location code was accidently inserted with space.


Solution (1) :

Go to Stock > More Stock Maintenance > Item Opening Balance Maintenance, filter with location PJ, and reselect the correct location for all items and click on Save.

Loc-1qty3.png


OR

Solution (2) :

If there was too many items, go to Tools > Change Code > Change Location

Loc-1qty4.png


Change the location to PJNEW

Loc-1qty5.png


Loc-1qty6.png


After changed, change it back to PJ

Loc-1qty7.png

Loc-1qty6.png


Now you should be able to inquiry the Stock Balance by Location report when filtered only location PJ.

Loc-1qty8.png


By : Lay Swan 180912, P180913



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