Troubleshooting: Preview Stock Issue Detail Listing – Unknown Sql Exception

From AutoCount Resource Center
Jump to navigation Jump to search

Question: When I try to preview my stock Issue Detail Listing Report, it shows me the error: Unknown Sql Exception (Number = 207. Message = Invalid column name ‘Subtotal’.)


Invalid column1.png



Possible Reason:

It may due to layout issue.


Solution:

Try to reset layout or delete the layout manager.

1. Reset Layout

Right click on any detail header and click on Reset Layout, then Inquiry and preview report once again.


Invalid column2.png



2. Delete Layout Manager

Right click on any detail header and click on Layout Manager.

A small dialog box of Layout Manager will be prompted.


Invalid column3.png


Select Layout to delete. Click on Yes to delete.

Inquiry and preview report once again.


Invalid column4.png


Note: If the problem still persists after performing the steps as above, please seek assistance from your software dealer for further study.


By: SW 180420, KM 180423, P180427



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