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

From AutoCount Resource Center
Jump to navigation Jump to search

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


Solution:

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


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