View source for Troubleshooting: Preview Stock Issue Detail Listing – Unknown Sql Exception

'''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’.)

<b>Version:</b> 1.8 / 1.9 / 2.0

[[File:Invalid column1.png]]




<u><b>Possible Reason:</b></u>

It may due to layout issue.



<u><b>Solution:</b></u>

Try to reset layout or delete the layout manager.

1.	<b>Reset Layout</b>

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


[[File:Invalid column2.png]]




2.	<b>Delete Layout Manager</b>

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

A small dialog box of Layout Manager will be prompted.


[[File:Invalid column3.png]]



Select Layout to delete. Click on <b>Yes</b> to delete.

Inquiry and preview report once again.


[[File:Invalid column4.png]]



<i><span style='color:red'>Note:</span> If the problem still persists after performing the steps as above, please seek assistance from your software dealer for further study.</i> 



By: SW 180420, KM 180423, P180427



{{NavigateForUser}}