Troubleshooting: Save Invoice Error - Arithmetic overflow error converting numeric to data type numeric

From AutoCount Resource Center

Question : When I try to save a new Invoice, system prompts an error message "Unknown Sql Exception (Number=8115.Message=Arithmetic overflow error converting numeric to data type numeric. The statement has been terminated)”. What should I do?

Version : 1.8 / 1.9 / 2.0

Arithmetic overflow1.png

Possible Reason :

Some data not able to update to SQL table when saving this transaction.

Solution :

1) Click on Show Details to check the error, it’s regarding the UTDCosting Table.

Arithmetic overflow2.png

2) Go to Stock > Item Maintenance, to view the item ‘TEST’. The unit cost at Up To Date Cost is showing an unusually huge amount.

Arithmetic overflow3.png

3) Inquiry the Stock Card report for this item. The Balance Cost and Average Balance Cost also showing unusually huge amount. It seems like something is wrong in the costing.

Arithmetic overflow4.png

4) Do a backup and run Recalculate Stock Costing for this item at Tools > Recalculate Stock Costing.

Arithmetic overflow5.png

5) After finished the recalculate, go back to stock card report to inquiry again. Now the cost is updated and looks normal.

Arithmetic overflow6.png

6) Then, try to save the Invoice, and it works fine.

Arithmetic overflow7.png

By : Azirah 180921, Lay Swan 180926, P180928

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