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
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.
Share
Report
All responses (
Answers (
543
