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, ...
Answered

Error when adding book information of an asset

(0) ShareShare
ReportReport
Posted on by

Hi All,

I have an issue in my clients Fixed asset module. When adding Fixed asset Book information i.e. having saved the General Information first, I am getting the errors after click save to save book information. That errors read

pastedimage1608756904714v1.png

followed by

pastedimage1608756944399v2.png

and then

pastedimage1608756980634v3.png

and finally 

pastedimage1608757010838v4.png

It might keep on repeating these errors and at some point they go away.

Any help please on how am gonna resolve them?.

Regards,

RomRyan

Categories:
I have the same question (0)
  • Verified answer
    Josh Page Profile Picture
    Microsoft Employee on at

    Your most likely missing at last one index on the FA00902 table. (FA00902_SRCDOC)

    By default there are the following.

    AK2FA00902

    AK3FA00902

    AK4FA00902

    AK5FA00902

    AK6FA00902

    AK7FA00902

    AK8FA00902

    FA00902_SRCDOC

    PKFA00902

    Note the final one is the PK and cannot be recreated without rebuilding the table (which will cause data loss). If the PK is missing, you will want to open up a case with the GP support team. For the others, you could script out the index from a different company to create it in this company. (be sure to backup the company first in case there are any issues).

    To script out the index Expand the table>index right click on the index and select script index as>create to>new query editor window. You can then change the DB name in the output script to create the missing index in the problem company.

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
André Arnaud de Calavon Profile Picture

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

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 311

#3
Diego Mancassola Profile Picture

Diego Mancassola 271

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans