Hello,
I get this error if i want to assign a fixed asset to accounts
'A save opetration cannot find table FA_ACOUNT_MSTR cannot find the table'
The detail information about the error is ' [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'ACCAUDITRL.dbo.FA00400_AUDIT''
please what can i do to resolve this issue.
Thank you and God bless
*This post is locked for comments
Great to hear that!!
Remember, if you need to start auditing the changes on fixed assets again, you will need to create a table called FA00400_AUDIT in a database called ACCAUDITRL and then enable the trigger again. Alternatively, you could change the database and table names in the trigger to something else.
Thanks for your responce it is reolved now
Thank you for responce it worked.
Hi,
It looks like there may have been a trigger on the FA00400 table with the additions/changes/deletions being stored in the FA00400_AUDIT table....I use the same naming convention for my audit tables!
Check if there are any triggers on the FA00400 table and disable them.
Ritesh
Do you have any 3rd party addons or customizations in your system? 'ACCAUDITRL.dbo.FA00400_AUDIT'' does not look like a standard GP table.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (