Microsoft Dynamics RMS (Archived)

problems with 2.0.1002 and GMROI etc

(0) Share

Report

Posted on by Community Member

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 (3)

Answers (0)

Jeff @ Check Point ... 13,382 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 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,382 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!!