Skip to main content

Notifications

Microsoft Dynamics RMS forum

problems with 2.0.1002 and GMROI etc

Posted on by Microsoft Employee

seems all gmroi reports since a few months now, don't work no more,

 

we get WEIRD opening inventory/closing inventory , then empty NET sales, empty COGS, empty GM /GM% etc...

 

tried multiple ranges, tried today.. since yesterday.. etc

 

Tries on stores, and tried on hq...

 

all same....

 

any idea on what to check in SQL DB's ? i see theres a stored proc called '#ListGMROIStore' but i can't seem to find that as well on the db's....used to work as i got that working in june... tried in december and now all broken.. since then i upped to .1002

*This post is locked for comments

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: problems with 2.0.1002 and GMROI etc

    Dunno, we've run it after the FP1 install without issue..  Its just calculating data

    You can see the triggers using SQL Management Studio Express or the $$$ version.  

    www.microsoft.com/.../details.aspx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: problems with 2.0.1002 and GMROI etc

    yes, and it says "y Turns" reports for dates before Microsoft Dynamics RMS 2.0 Feature Pack 1 was installed."

    FOR SALES BEFORE FP1.... i can't even see GMROI on todays or last day's SALE...

    i think a trigger is not being triggered...any way to see trigger etc in SQL ?

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: problems with 2.0.1002 and GMROI etc

    Try re-runnng the Fix-it tool  support.microsoft.com/.../2451854  Store Ops only and BACKUP FIRST!!

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans