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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Blank amount is genera...
Microsoft Dynamics AX (Archived)

Blank amount is generated on Spend by procurement category report

(0) ShareShare
ReportReport
Posted on by YanQ 390

Hi all,

We are using AX2012 R3.  We assigned Procurement category to all items and have been processing invoices for POs.  We want to use Spend by procurement category report at Procurement and sourcing > Reports > Statistics > Spend Analysis.  Report was generated no issue but it was blank at Amount field and #Error at Percentage of total field.  I do understand that the #Error is resulted from blank amount as it is formulated.  But I don't understand why the Amount field is blank.  The default currency is USD in the specified report company and cubes was kicked off.  Actually none of Spend by reports generates data.  My guess is that we might have missed something in configuration.  Does anyone have experience on those reports and know how to get it fixed?

Thanks.

*This post is locked for comments

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

    Hi YanQ,

    If I remember correctly then the Report requires the implementation and processing of the SSAS cubes. Can you try processing them and verify the report results again?

    Best regards,

    Ludwig

  • YanQ Profile Picture
    YanQ 390 on at

    Thank you Ludwig.  We kicked off cubes before generating the report.  I checked the cube data in Excel

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi YanQ,

    Are you regularly recording your expense transactions together with procurement categories or do you usually record all your expense directly in vendor invoice Journals without relation to a category?

    Ludwig

  • YanQ Profile Picture
    YanQ 390 on at

    Hi Ludig,

    We use AP Invoice journal to record misc expense.  The rest is all from PO invoice.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi YanQ,

    It is difficult finding what might be wrong with your report from this end.

    Probably have a look at the following tables and whether include some values:

    VendInvoiceTransExpanded table

    BICOMPANYVIEW table

    EcoResProcurementCategoryExpanded table

    The Report and the tables are described here: technet.microsoft.com/.../hh500171.aspx

    In Addition, also take a look at the following blog post to verify that you did not run into a security issue: axintherealworld.blogspot.de/.../spend-by-procurement-category-ssrs.html

    Hope this helps,

    Ludwig

  • YanQ Profile Picture
    YanQ 390 on at

    Thank you Ludwig.  I created a support incident with MSFT.  Hopefully it will get fixed.

  • Community Member Profile Picture
    Community Member on at

    I've already mentioned this today, almost seems like i'm plugging it, but depending on the complexity of the reports you're looking to produce it might be worth considering an Excel plug-in like Atlas 6.0 or the Dynamics Excel Plugin.

    They link directly into the tables in AX and extract information into the format you require and a lot more adaptable and flexible than standard AX reports -  especially for things like vendor transaction analysis. Both come directly into excel and can be manipulated in the same way as a standard excel worksheet. Atlas seems a lot more adept at dealing with complex reports than the Dynamics Excel Add In, however.

    They are great for this type of report as you can add in and manipulate as much data as you like.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans