Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Management Reporter - Balance type reversing issue (Dynamics SL)

(0) ShareShare
ReportReport
Posted on by 420

We had a report running quite well for a while against many companies.  Suddenly in one of our companies, the balance sign has switched completely for our revenue accounts.  For all other companies the revenue balance as a credit amount shows as a positive number, but for one specific company, the credit amount is going into MR with a positive balance and MR reverses the sign on it, incorrectly showing it as negative number.  We do have the "C" indicator in the row format definition.  Any ideas?  Did anyone ever come up against this situation?  It is very sudden and I've check in Dynamics SL and all the numbers are correct.

*This post is locked for comments

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Management Reporter - Balance type reversing issue (Dynamics SL)

    You want this one: mbs.microsoft.com/.../SL2011_MR2012_HotFix.zip

    it's called  "Microsoft Dynamics SL 2011 Hot Fix (SL 2011 and SL 2011 SP1)" on the MR downloads page.

  • Mark Fineman Profile Picture
    Mark Fineman 420 on at
    RE: Management Reporter - Balance type reversing issue (Dynamics SL)

    Hi Butch,  thanks for the advice.  I checked in Partnersource and there isn't a specific hotfix... do I need to run all of them.  Is there a specific KB number that I can refer to?  I appreciate the help!

  • Verified answer
    Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Management Reporter - Balance type reversing issue (Dynamics SL)

    If you have access to Customer Source or Partner Source you need a hotfix. I suspect that you overwrote it by executing the "Execute Master Views and Stored Procedures"

    You need the hotfix titled "Microsoft Dynamics SL 2011 Hot Fix (SL 2011 and SL 2011 SP1)"

  • Mark Fineman Profile Picture
    Mark Fineman 420 on at
    RE: Management Reporter - Balance type reversing issue (Dynamics SL)

    UPDATE  

    We can trace the incident back to running a Dynamics SL db utility in 2 of our companies - the "Execute Master Views and Stored Procedures" update.  We have about 14 companies in total.  After that we noticed that for the 2 companies only, all others are ok - the revenue numbers are correct but coming up with the wrong sign... coming up as negative when they should show positive.. on the same report all other companies are showing the revenue amounts with the correct sign.  

    Any ideas? Did anyone ever come up against this situation? It is very sudden and I've check in Dynamics SL and all the numbers are correct.  Everything in MR looks right from a row, column and tree setup.. I'm convinced it's the Utility that did something.  What can I do?

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans