FA Troubleshooting: Attempted to divide by zero error when load new asset
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?
You may have keyed in '0' for asset quantity in Purchase Invoice.
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
2. Run SQL Query to identify which Purchase Invoice contains where Quantity is “0.00”
Select * from PIdtl where qty = ‘0’
3. Get the dockey and run SQL Query to find out related Purchase Invoice
Select * from PI where dockey in (‘35278’,’35279’)
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.
By: Aimi 180119, KM 180201, P180202
|AutoCount Accounting 2.0
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations