Troubleshooting: Price History Report error – Unknown Sql Exception (Number=137, Message=Must declare the scalar variable ‘@AccNoPO’.)

Question: When I filter creditor and group by item code on the price history report (more options enable Purchase Invoice only) and inquiry, it prompted an error: Unknown Sql Exception (Number=137, Message = Must declare the scalar variable ‘@dAccNoP0’.)

Version: 1.9 / 2.0

Possible Reason :

This is a known bug.

Solution :

For version 1.9 - Update to version 1.9.11.74 or above.

For version 2.0 - Update to version 2.0.27.192 or above.

By: Soh Wee 220223, Lay Swan 220224, P220224

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations