Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / FP1 GMROI report not s...
Microsoft Dynamics RMS (Archived)

FP1 GMROI report not showing data

(0) ShareShare
ReportReport
Posted on by K Verburg 95
I'm working through all the changes of Feature Pack 1 and most of the changes are pretty straight-forward and handy, but I can't get the GMROI and Inventory Turn report or the KPI Data in the Purchase Order to work, after a week all of the KPI and report values still are empty. Does anybody know where the data is coming from (in the report it says ListGMROIItems or #ListGMROI) and what triggers the update? The Net Sales column (needed for a lot of the calculations) does not seem to change, only the inventory values at the beginning and end of the period and the average inventory values seem to be changing when the date of the report changes. I also tried setting up a completely new database, but this doesn't make any difference either. Kenneth Verburg Eldata Advice Group

*This post is locked for comments

  • The Guns and Gear Store Profile Picture
    The Guns and Gear S... 110 on at
    RE: FP1 GMROI report not showing data

    Does anyone know if there is a way to modify the report to account for manual inventory adjustments?

  • The Guns and Gear Store Profile Picture
    The Guns and Gear S... 110 on at
    RE: FP1 GMROI report not showing data

    Why is the GMROI not accurate if you make manual adjustments to inventory?

    Is there a way to account for this in a Custom Report?

    Do you have any experience which can help in this area... this is a problem I have been experiencing.

  • Shawn Meade Profile Picture
    Shawn Meade on at
    Re: FP1 GMROI report not showing data

    In order to use the GMROI report after installing Feature Pack 1, you need to first run the Fixit that will then generate the information needed to the appropriate table.  This can be found below.

    How to generate "Inventory Valuation" and "GMROI and Inventory Turns" reports for dates before Microsoft Dynamics RMS 2.0 Feature Pack 1 was applied

    support.microsoft.com/.../de

    The GMROI will only be accurate if you do not make any manual adjustments or adjustments through SQL.  

  • Saleh Sharaf Profile Picture
    Saleh Sharaf 145 on at
    Re: FP1 GMROI report not showing data

    me to when i run this report i found this error

    can anyone help pls

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans