Open Forum

Expand all | Collapse all

Where do I find the COST VARIANCE REPORT?

Jump to Best Answer
  • 1.  Where do I find the COST VARIANCE REPORT?

    GPUG ALL STAR
    Posted Jan 03, 2019 05:25 PM
    Hello, Collaborators,

    Our Office Manager, Angie, handles the new duty of entering and posting Receiving transactions. When she posts a Receivings batch, she has access to all of the reports that print (5 of them by default) except for the COST VARIANCE REPORT.

    I could not discover which Security Task included that report. Does anyone here know where it might be so that I can add it to Angie's Security profile?

    Thank you,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach
    2018-12-06_08_06_34-Mozilla_Firefox.jpg
    ───────────────
    Excel Webinar List
    ------------------------------
    GPUG Summit - Post


  • 2.  RE: Where do I find the COST VARIANCE REPORT?

    GPUG ALL STAR
    Posted Jan 03, 2019 05:27 PM
    P.S., As a stop-gap measure I removed the Cost Variance Report from the list of reports that print when posting Receivings Transactions.

    Regards,

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach
    2018-12-06_08_06_34-Mozilla_Firefox.jpg
    ───────────────
    Excel Webinar List
    ------------------------------

    GPUG Summit - Post


  • 3.  RE: Where do I find the COST VARIANCE REPORT?
    Best Answer

    SILVER CONTRIBUTOR
    Posted Jan 03, 2019 08:43 PM
    Hi Steve,

    assuming you are receiving a security error message when posting, telling you that the user do not have access to the report, I suggest you simply install the super useful tool GP Powertools from Winthrop, formerly known as Support debugging tool.

    Here is the link : GP Power Tools Portal
    David Musgrave's Winthrop Development Consultants Blog remove preview
    GP Power Tools Portal
    This is the portal page for GP Power Tools for Microsoft Dynamics GP (based on the product previously known as the Support Debugging Tool for Microsoft Dynamics GP). Find this page using the URL: http://winthropdc.com/GPPT IMPORTANT NOTICE: To ensure continued registration after 01-Jul-2018, please update all workstations to Build 24 or later before the current...
    View this on David Musgrave's Winthrop Development Consultants Blog >

    Once this is installed, you can turn on the automatic popup of security errors window so the user can send you by email a file, that you just have to import into security profiler to know exactly what is the resource missing security :)

    Or, you can use the security profiler "on-demand" to monitor all resources security request while you test it.
    ** This last useful way of profiling just popped in my mind as I was writing the answer, so I gave it a shot for you, and here is the result :
    Security profiler while receiving
    As you can see, the resource is named "IV Cost Variance Report" and is under the Inventory module.

    Cheers

    Luc

    ------------------------------
    Luc St-Yves
    Business Analyst
    Humanware Technologies
    Drummondville QC
    ------------------------------

    GPUG Summit - Post


  • 4.  RE: Where do I find the COST VARIANCE REPORT?

    SILVER CONTRIBUTOR
    Posted Jan 03, 2019 08:47 PM
    Sorry Steve, I just realized why your name sounded familiar ;)  You are an all-star !  So you probably already knew about Powertools and were just looking for a quick answer.

    Hope I did provide what you were looking for ;)

    ------------------------------
    Luc St-Yves
    Business Analyst
    Humanware Technologies
    Drummondville QC
    ------------------------------

    GPUG Summit - Post


  • 5.  RE: Where do I find the COST VARIANCE REPORT?

    GPUG ALL STAR
    Posted Jan 04, 2019 09:26 AM
    @Luc St-Yves,

    Not at all, mon ami! I had used GPPT to look for that report... but I just didn't look under IV. I also neglected to look at Reports in the Security Log for our Office Manager. Once I checked that box and saw the reports she'd been denied access to, I simply checked the box for that report and changed her Security profile... et voilà!

    Thank you for helping me get back on the rails.

    Sincerely,​

    ------------------------------
    "Sparkly" Steve Erbach - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach
    2018-12-06_08_06_34-Mozilla_Firefox.jpg
    ───────────────
    Excel Webinar List
    ------------------------------

    GPUG Summit - Post


If you've found this thread useful, dive deeper into User Group community content by role