Deleted Fixed Asset by error

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I accidently deleted a depreciated fixed asset from FA Module while I should have retired it.

I could not do any enquiry with that asset ID. Does it mean it has just gone? Is there any way to undo the delete? Is General Journal the only way to fix?

Thanks

*This post is locked for comments

All responses (7)

Answers (1)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: Deleted Fixed Asset by error

Katie -

When GP does not behave as expected, creating a support ticket with Microsoft is often the best move for customers and partners alike. It is possible there are remnants of the deleted asset in some, but not all fixed asset tables. For instance if you can't find the Asset it is not in the FA00100 Asset General Information Master table, but if remnants of the asset remained in the FA00200 table (Book Master) GP might continue to try and depreciate the asset (this is totally hypothetical).
Community Member Microsoft Employee on at

Like (0)

Report

RE: Deleted Fixed Asset by error

Hi Harry,

I don't know if you would know what to do in my case but here it is:

I rolled back and deleted an asset that should not have been set up. But now when I'm trying to run deprec for the periods again in the FA module, an error message keeps coming up saying it can't find the asset I deleted. I don't know why it still knows about it and wants to depreciate it since I can't even find a record of the asset anymore. I can;t figure out how to 'fully' delete the asset or tell the system its not there and shouldn't be depreciated.

Anyway, if you have any thoughts it would help me out.

Katie
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: Deleted Fixed Asset by error

Blue -

Deleting an asset using the utility as you described in your post does not do anything to the General Ledger, but it does completely clear out all activity related to the deleted asset in the Fixed Asset sub ledger. It sounds like you took the time to make the changes to the General Ledger yourself. This means when you set up the asset again, you follow all the steps in my original post save one. You should not delete the GL Batch created by the addition and depreciation of this asset, which will need to be posted to the GL instead. Alternatively you could delete the batch, as I describe and make manual adjustments to the GL as you did when you deleted the asset.

Harry
Blue Smart 110 on at

Like (0)

Report

RE: Deleted Fixed Asset by error

Hi Harry Lee

i think i facing the same problem

but there are some points you mentioned not cleared to me ..

so my case is if i deleted fixed asset card by mistake in Feb. 2016 which added in 2015 via MS>>>Tools>>>>Utility>>>>Fixed Assets>>>Delete , and then i processed manually the required reversed Journal Entries in General ledger Transactions

Note: we already closing the year 2015 and depreciated only one month in Jan.2016 ...

thanks in advance
Redbeard 12,931 on at

Like (0)

Report

RE: Deleted Fixed Asset by error

You are welcome Rachel.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Deleted Fixed Asset by error

Thanks Harry! It worked perfectly!
Verified answer

Redbeard 12,931 on at

Like (2)

Report

RE: Deleted Fixed Asset by error

Rachel,

Deleted fixed assets can be added to the system again. Make sure you duplicate the setup of the deleted asset exactly. Once you've recreated the asset, depreciate it to it's depreciated to date again, interface to GL and delete the batch from the system. Don't post the batch to the GL (the entries are already in the GL, as deleting the asset does not remove entries from the GL).

Make sure you clear out any other GL entries you want to keep, in order to make sure you can cleanly delete the GL Batch created by the GL interface.

This approach has worked for numerous clients on assorted versions of GP. I would recommend trying this in a test database, copied from your live company, to make sure it is going to work as planned.