Open Forum

Expand all | Collapse all

MR attributes for Vendor printing on Budget only lines

  • 1.  MR attributes for Vendor printing on Budget only lines

    GOLD CONTRIBUTOR
    Posted Jun 10, 2019 01:19 PM

    Looking at some reports for a client and they have a Vendor Attribute column.  It is pulling incorrect values, for instance they have a line with only Budget data populated and it is pulling a vendor.  There is not a vendor associated with a budget entry, so I would expect that to be blank.  It seems to be pulling the same Vendor ID on each budget line regardless of the type, so I am not sure where it is pulling the data from and why it would not just leave it blank in the attribute column for those lines with only budget data no actual transactions.

     

    any suggestions on how to stop this from happening?

     

    Thanks

    Dawn



    ------------------------------
    Dawn Schwarz
    Senior Consultant
    Wipfli
    Madison WI
    ------------------------------


  • 2.  RE: MR attributes for Vendor printing on Budget only lines

    GPUG ALL STAR
    Posted Jun 10, 2019 02:40 PM
    Hello fellow Wisconsinite, @Dawn Schwarz!

    It would help to see the Column and Row Definitions. Can you give us some screen shots?

    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

    ───────────────
    Excel Webinar List as of 22-Mar-2019
    ------------------------------



  • 3.  RE: MR attributes for Vendor printing on Budget only lines

    GOLD CONTRIBUTOR
    Posted Jun 10, 2019 05:28 PM
    Steve

    Thanks for the reply!  I am waiting to grab some shots from the client and will update when I have them.

    Dawn

    ------------------------------
    Dawn Schwarz
    Senior Consultant
    Wipfli
    Madison WI
    ------------------------------



  • 4.  RE: MR attributes for Vendor printing on Budget only lines

    GOLD CONTRIBUTOR
    Posted Jul 17, 2019 01:54 PM
    Sorry for the long delay, the statements are Comparative Income statements, Budget to Actual both for month and year.  The attribute is the originating Vendor Master Record Name.  I will attach screen shots here.  We are noting that they are also seeing a vendor on Intercompany GL transactions that are being made, which of course do not have an originating Vendor tied to them.  They are currently on Version 2.1.12000.26.  Thanks for any thoughts you can add to the issue!  When we first looked it seemed that the budget lines that had no actual expenses were pulling the Vendor from the next line, but that is also not always true it just seems to repeat the same vendor on each budget line, regardless of the account.





    ------------------------------
    Dawn Schwarz
    Senior Consultant
    Wipfli
    Madison WI
    ------------------------------



  • 5.  RE: MR attributes for Vendor printing on Budget only lines

    GPUG ALL STAR
    Posted Jul 17, 2019 04:37 PM
    @Dawn Schwarz,

    My first SWAG (Scientific Wild Ass Guess) is that the Attribute column should be positioned to the far right.​ Attributes only show up in the Transaction-level of a Report... and my guess is that they're happier if they live on the right side of the report.

    I would test the report by removing the Attribute column just to see if the numbers come out right. Then add the Attribute column all the way to the right.

    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

    ───────────────
    Excel Webinar List as of 22-Mar-2019
    ------------------------------



  • 6.  RE: MR attributes for Vendor printing on Budget only lines

    GOLD CONTRIBUTOR
    Posted Jul 18, 2019 11:43 AM
    @Steve Erbach...LOL on the SWAG all new meaning!  Thank you for the insight I was not aware of that but will certainly give it a shot and report my findings when able.  Strange things I find with MR at times more fickle than WI weather!

    Thanks
    Dawn​

    ------------------------------
    Dawn Schwarz
    Senior Consultant
    Wipfli
    Madison WI
    ------------------------------



  • 7.  RE: MR attributes for Vendor printing on Budget only lines

    SILVER CONTRIBUTOR
    Posted Jul 22, 2019 09:08 AM
    HI Dawn,

    I couldn't tell from your post if you were using legacy or the data mart as your data provider. Based on the drop down of the Attribute options it looks like data mart.  I haven't had any issues with putting ATTR columns in the middle of reports, MR will ignore these columns until you get to the transaction level. Another suggestion would be to try to add more than 1 ATTR column.  Try adding the Transaction Date and/or Journal entry number.  See if that helps.

    However, I just found this in the CU13 fix list...

    3383462 Originating master Record Name\ID may display a value when it should be blank

    The best option might be to upgrade to CU16 if you can. 


    ------------------------------
    Annette Brown
    Sr. GP Implementation Consulant
    Columbus
    Troy MI
    ------------------------------



  • 8.  RE: MR attributes for Vendor printing on Budget only lines

    GOLD CONTRIBUTOR
    Posted Jul 23, 2019 10:44 PM
    @Annette Brown Thank you very much for the information.  I am following up with the client to see if this might resolve the issue.  I believe they have a datamart as well, but I have not been able to verify this.

    I appreciate the input and I am wiling to try whatever it takes to correct :)

    Dawn​

    ------------------------------
    Dawn Schwarz
    Senior Consultant
    Wipfli
    Madison WI
    ------------------------------



  • 9.  RE: MR attributes for Vendor printing on Budget only lines

    GPUG ALL STAR
    Posted Jul 24, 2019 01:27 PM
    @Dawn Schwarz,

    Looking at your posts again, it occurred to me that your Customer is asking Management Reporter to show the Originating Master Record Name (Vendor or Customer) at the Transaction Level (of course... that's the only level at which the ATTR appears). However, since the Budget is on the report, too, that may be making MR go ga-ga, I think. Budgets aren't defined down to the individual transaction level. Isn't that more of a problem? Maybe MR is getting confused by the dual requirements to show Budget amounts as well as the Originating Master Record Name at the Transaction level.

    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

    ───────────────
    Excel Webinar List as of 22-Mar-2019
    ------------------------------



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