FA Troubleshooting: Attempted to divide by zero error when load new asset

From AutoCount Resource Center

Questions: When I try to load a new asset from Purchase Invoice, there is an error message prompted ‘Attempted to divide by zero error’. Why can’t I load a new asset from purchase invoice?

Divided zero1.png

Possible Reason:

You may have keyed in '0' for asset quantity in Purchase Invoice.

Divided zero2.png


Find out the related purchase invoice and double check if the purchased quantity is correct. You may search the entry by using SQL Query:

1. Login into AutoCount Management Studio and go to Tools > SQL Query

Divided zero3.png

2. Run SQL Query to identify which Purchase Invoice contains where Quantity is “0.00”

Select * from PIdtl where qty = ‘0’

Divided zero4.png

3. Get the dockey and run SQL Query to find out related Purchase Invoice

Select * from PI where dockey in (‘35278’,’35279’)

Divided zero5.png

All the related Purchase Invoice will be listed out. You may check the asset’s quantity accordingly.

Alternatively, you may find out the related asset from load new asset from Purchase Invoice.

Divided zero6.png

By: Aimi 180119, KM 180201, P180202

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