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
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.
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 ?
Try re-runnng the Fix-it tool support.microsoft.com/.../2451854 Store Ops only and BACKUP FIRST!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154