News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) problems with 2.0.1002...

Microsoft Dynamics RMS (Archived)

problems with 2.0.1002 and GMROI etc

(0) Share

Report

Report

Posted on by Community Member 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

All responses Img

All responses (3)

Answers Img

Answers (0)

Jeff @ Check Point ... 13,380 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 ... 13,380 on at

Like (0)

Report

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!!

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans