web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Duplicate fixed asset index.

(0) ShareShare
ReportReport
Posted on by 75,852 Moderator

I just noticed in the FA00100 there is one asset ID with two different asset indexes. When I pull up the asset ID I only see the with an acquisition cost of $260,000. The one that has an acquisition cost of $100,000 never appears. Is it safe to delete this second one from the FA00100 table?

Categories:
I have the same question (0)
  • Hokuminaria Profile Picture
    2,950 on at

    Hey Richard,

    I would not delete this until you fully review. It is a valid data condition if an asset was partially retired. You should check the ASSETSTATUS flag in the FA00100 on both of those and see if one is partially retired.

    As you can see in mine below.

    pastedimage1675204029949v1.png

    I would use the Reconcile Fixed Assets to General Ledger Report to compare what posted to the GL. If you do decide to delete this, you will need to address the GL as well.

    I hope this helps!

    Thank you!

    Brandon | Microsoft Support Engineer

  • Richard Wheeler Profile Picture
    75,852 Moderator on at

    Brandon, how do I interpret the results of the FA reconciliation report? In this case the asset ID is 51336. Putting this into the range yields no results. Looking at the FA00100, the duplicate asset index has an assetstatus of 4. It has been retired. Here is the client's question.

    Prior to our retirement entry asset index 6823 had column L value of $270000.  That has been reduced to $260000 so I would say remove line 3.

    Asset Index 6823 should have cost of $260000 and accumulated depreciation of $55278.84 for a net book value of $204721.16.

    Does that all check out if you remove asset index 7446 or does 6823 revert to 270000 cost?

  • smith68574 Profile Picture
    20 on at

    A duplicate fixed asset index occurs when there are multiple entries in the fixed asset register for the same asset. This can happen due to human error, system glitches, or incorrect data entry. It is important to identify and resolve duplicates in order to maintain an accurate and up-to-date record of the company's fixed assets. This can be done by comparing the asset details and using an asset management software to automatically detect and merge duplicates.   https://www.hyveehuddle.net/

  • Hokuminaria Profile Picture
    2,950 on at

    Hey Richard,

    The report shows you what was posted in Fixed Assets and what was posted in the General Ledger for the accounts. The point of this was if stuff pushed to the GL for the one you want to delete, you have to correct the GL for those postings as well or your FA will be out of balance.

    Based on the information provided, this just sounds like the asset was partially retired. Below is an article on partial retirements and what they do.

    (+) How does Fixed Asset handle partial asset retirements - Microsoft Dynamics GP Community  -Added as missed initially.

    If you still want to remove this, I recommend you use the Delete Asset utility to know it was removed from all the tables. If you start messing with the FA00902, FA00905 and FA15000, if these become out of synch, you are going to start seeing errors. These are not easy to correct.

    Another option is to try unretiring this in test and see what it looks like since as it seems the values are incorrect as well.

    Without actually seeing all the data for both of these, I can only speculate. The only two things I know that will allow the same asset id. The first is if they use different Suffix's. The second is when they partially retire. This creates a second asset with an increased suffix.

    I hope this helps!

    Thank you!

    Brandon | Microsoft Support Engineer.

    .

  • Richard Wheeler Profile Picture
    75,852 Moderator on at

    I will check with the client and ask what it is they are trying to accomplish. If they do opt to delete I will use the Delete Asset utility in GP.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 617

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 461 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans