web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

error in running spend by procurement category report

(0) ShareShare
ReportReport
Posted on by 504

recently our client tried to run this report at Procurement and sourcing module under spend analysis, so we have deployed Dynamics AX cube as this report requires cube to run, but when we try to run this after filling parameters, it is giving following error, any body knows how to resolve this. Thanks much in advance

procurment-error.png

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi xain,

    Have you processed this cube before you run the report?

    Does the cube contain all the current data including newly created categories, etc.?

    Best regards,

    Ludwig

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello xain,

    Have you been able to get this issue resolved in the meantime?

    Would be great if you could keep us informed here.

    Many thanks,

    Ludwig

  • xain Profile Picture
    504 on at

    Hello Ludwig,

    Sorry for late reply, yes i have process the cube, and i am getting below mentioned error even though cube process successfully, i  wonder if the error in report coming because of htis,

    cubeerror.JPG

    and when i ran the sql query, i am getting below result, what would be remedy steps in this regard

    sqlerror.JPG

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi xain,

    The error says that the procurement category was not found.

    I cannot see this from your screenprint.

    Have you also processed the other cubes, especially the GL one or only the inventory cube?

    Best regards,

    Ludwig

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans