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

From AutoCount Resource Center

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

Price history error1.png

Possible Reason :

This is a known bug.

Solution :

For version 1.9 - Update to version or above.

For version 2.0 - Update to version or above.

By: Soh Wee 220223, Lay Swan 220224, P220224

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

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