Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / A get/change operation...
Microsoft Dynamics GP (Archived)

A get/change operation on table 'FA_Company_SETP' cannot find the table.

(0) ShareShare
ReportReport
Posted on by JBS ERP 1,175

I installed fixed asset and I find it worked fine on the production company. However, when I use the demo company (TWO database), I receive the following error messages. This error message pops up when I try to post receving transactions, but it also saying that intrupt sales order transactions.

A get/change operation on table 'FA_Company_SETP' cannot find the table.

A get/change operation on table 'FA_PO_Additional_Information_MSTR'  cannot find the table.

[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'TWO.dbo.FA01300'.

please advise how I can fix this error.

*This post is locked for comments

  • JBS ERP Profile Picture
    JBS ERP 1,175 on at
    RE: A get/change operation on table 'FA_Company_SETP' cannot find the table.

    Thank you!

  • Verified answer
    Dedi Hermawan Profile Picture
    Dedi Hermawan 295 on at
    RE: A get/change operation on table 'FA_Company_SETP' cannot find the table.

    Hello Jbserp

    I've experienced it

    the solution is with maintenance table

    Microsoft Dynamics GP menu >> Maintenance >> SQL

    Database : Your Company

    Product : Fixed Asset

    Name : Company Setup Series Financial

    FA_Company_SETP  table FA49900

    PO Additional Information Master series Financial

    FA_PO_Additional_Information_MSTR table FA01300

    Good Luck

  • Sureshn07 Profile Picture
    Sureshn07 700 on at
    Re: A get/change operation on table 'FA_Company_SETP' cannot find the table.

    try running the grant.sql script file available in the GP folder in the TWO db.

  • Verified answer
    Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus 3,930 on at
    Re: A get/change operation on table 'FA_Company_SETP' cannot find the table.

    Hi,

    Try visiting the FA company setup window and apply INTERNAL as your corporate book.

  • JBS ERP Profile Picture
    JBS ERP 1,175 on at
    Re: A get/change operation on table 'FA_Company_SETP' cannot find the table.

    Thank you, Leslie.

    As you mentioned, the FA table didn't exist so I created it using SQL Maintenance. However, I still receive error messages when I post receiving transactions.

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'FA_Allow_Reporting_Ledge'.

    Please advise what I missed..

     

     

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    Re: A get/change operation on table 'FA_Company_SETP' cannot find the table.

    You most likely need to set up FA in TWO before you try to post. Check SQL Server and see if the table exists. If it does not, then you can create it using SQL Maintenance from within the GP interface.

    kind regards,

    Leslie

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans