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

Notifications

Announcements

No record found.

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
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 672 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 534 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 289 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans