Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

AA Dimension code inactivation

Posted on by 202

Hi,

I want to inactivate an AA Dimension code never used in GP. I received an error message when I'm in the French version of GP 2015. When I do it in the English version, It works. Find below the error message received : [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'affectation'.[Microsoft][SQL Server Native Client 11.0][SQL Server]Unclosed quotation mark after the character string ' from AAG30000 aaGLHdrTbl with (NOLOCK) inner join...

When I look the table involved when you inactivate a dimension code, AAG30000 is not included. List of tables : AAG00400, AAG00401, AAg00405, AAG00406, AAG00600, AAG00601, AAG00700, AAG01000, AAG01001, AAG01002, AAG02000, SY01400, TEMP. What should I do with this case ? The customer does not want to use an English version.

Thanks,

MSL

*This post is locked for comments

  • Verified answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: AA Dimension code inactivation

    Hi,

    Looks like a bug to me.  

    Try filing a case with Microsoft to verify the issue.  

    On the other hand, since you have an English version, you can just use SQL to inactivate the dimension code.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans