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

From AutoCount Resource Center
Revision as of 01:30, 28 February 2022 by LaySwan (talk | contribs) (Created page with "'''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 File:Price history error1.png <u><b>Possible Reason :</b></u> This is a known bug. <u><b>Solution :</b></u> For version 1.9 - Update to version 1.9.11.74 or above.<br/> For...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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 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

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