Finance | Project Operations, Human Resources, ...

Fixed Assets already depreciated showing not yet acquired.

(0) Share

Report

Posted on by Hossam Fathy

2,611

Hello,

i have one fixed assets already depreciated but it is showing now as not yet acquired.

How to change the status to Open?

Thanks

I have the same question (0)

All responses (14)

Answers (0)

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Hossam,

It can be changed using a x++ job or in the SQL database with a query.

Was this reply helpful? Yes No
Hossam Fathy 2,611 on at

Like (0)

Report

Hi André,

Thx for your reply.

Is this secure to change it from the database.

and why the Fixed Assets status changed from Open to Not yet acquired.

Thank you.

Was this reply helpful? Yes No
Junaid Idrees on at

Like (0)

Report

Hi Hossam,

It is an abnormal system behavior and shouldn't supposed to happen as it can cause the same issue for other fixed assets as well. Is there any customization in the system in FA module?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello Hossam,

On 31 Dec 2019 there is a second but negative acquisition transaction.

This was posted with a different voucher number "JV..."

To me it looks as this transaction is responsible for this.

In my demo machine I can actually replicate something like this.

Just test the following:

Acquire and depreciate a fixed asset and then reverse all of the transactions by hitting the reverse transaction button.

If everything is reversed the status will change to not yet acquired.

Best regards,

Ludwig

Was this reply helpful? Yes No
Hossam Fathy 2,611 on at

Like (0)

Report

Hi Ludwig,

one user make some manual entries on this assets, he record negative acquisition then he record 3 depreciation and make the assets net book value zero.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Right.

That's something similar to what I was able to replicate in my demo machine.

In other words, that's a standard behavior.

Best regards,

Ludwig

Was this reply helpful? Yes No
Hossam Fathy 2,611 on at

Like (0)

Report

Now, i can make new acquisition for this assets or just change the status from the database? and if i make new acquisition is this normal?

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

I personally suggest to create a new acquisition from FA acquisition journal instead of doing it from db because it was system standard behavior to change the status to not yet acquired because accumulated depreciation become net amount of zero.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Hossam Fathy,

You don't need to change the status from the database. If you post a new acquisition transaction in a journal the status will automatically change again to open.

Before doing that discuss with your accounting colleagues whether they don't want to have a new and 'fresh' fixed asset.

That is because adding new transactions will simply add new lines in the transaction form that you shared above. Well, you already got a number of lines plus corrections there and if you just continue posting things might get really difficult to reconcile for example if one day an auditor asks you explaining him/her those transactions. Wouldn't is be better to start with a new and 'fresh' fixed asset?

Best regards,

Ludwig

Was this reply helpful? Yes No
Hossam Fathy 2,611 on at

Like (2)

Report

Hi Ludwig,

They will sell it, so no need to create new asset.

Was this reply helpful? Yes No