Error when adding book information of an asset

(0) Share

Report

Posted on by Romryan

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

followed by

and then

and finally

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:

Microsoft Dynamics GP

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Josh Page on at

Like (1)

Report

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.

Was this reply helpful? Yes No