I tried to delete an asset, but after receiving the message that the asset was deleted, the asset can still be queried and does not appear to have been deleted.

This situation may occur after you convert or import data.

If the ASSET table is filled with rows in which the ASSET_ID has more characters than the limit you defined on the Configure Fixed Assets Settings screen, the system will appear to delete these assets, but they will not actually be deleted from the table.

Query functions will display the whole asset number, so you can use these as tools to verify that this is the problem. Example: Query displays the Asset Number as 123456. When you select the Asset, it will display as Asset Number 12345. If you delete this asset, the system attempts to delete 12345 and thinks it was successful, but 123456 still exists.

It is very important that all numeric asset numbers be the length specified in the Length of Asset Number field on the Configure Fixed Assets Settings screen and that all alpha-numeric assets numbers be equal to or less than that length before you import or convert your data, because you cannot change the asset number length on the Configure Fixed Assets Settings screen once Asset Master records have been created. If records of different asset number lengths have been used, you should contact our Technical support staff to discuss the solution options.