Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Fixed allocation SSRS

Posted on by 3,015

How do I get past this error so that I can pull the needed fixed allocation data?

I am inserting the following into report builder 2.0 and it results in the error above

SELECT
ACTINDX as [Account Index],
DSTINDX as [Distribution Account Index],
PRCNTAGE as [Percentage]
FROM GL00103

*This post is locked for comments

  • Verified answer
    RE: Fixed allocation SSRS

    Hello,

    You need to give the calling user select access to this table as the error implies.  To figure out the calling user, take a look at your data sources to see what user is being utilitized to make the connection to the database.

    Thanks

    Rob

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