web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Help! Red numbers for ...
Microsoft Dynamics GP (Archived)
Suggested Answer

Help! Red numbers for negatives showed up in my report

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I ran this report 2 weeks ago and it was fine.  There was nothing changed in the report at all.  When I went to run it today, all my negative numbers are RED!!   Is there any way to get rid of this?

We are using FRx 6.7.9111negnumbers.JPG

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,552 on at

    Hi,

    The below link was mentioned best solution for this, please check,

    productforums.google.com/forum

    Thanks

    Praveen

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Deborah, when you export to Excel you are then under the control of the environmental settings of Excel and your local workstation.

    It is possible that some time in the past two weeks that somewhere some one made a change in the computer environment setting or in Excel settings that 'requested' the negative numbers be shown as RED

    Praveen provides a like to a discussion on how thsi is done and therefore how to undo the problem.

    I do not believe that this is either a Microsoft Dynamics GP or FRx 6.7 problem - the data is correct, the problem is strictly in the presentation of the data.

    Hope this helps, keep posting.

  • Community Member Profile Picture
    Community Member on at

    Yes, Praveen instructions showed how to conditionally format.

    Thanks for the input, It's really weird because it only does this for this one report.  All of my other financials are all in black.   I've had 2 other users run this report with the same results.  Thanks again to you both.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Deborah, is it running that way directly from FRx?

    So then I have to back track - if you and other users run 'only' this report and get this result, then there is something in this reports configuration that is causing this.  Sorry, I had assumed that this was happening when you export to Excel.  Should have asked first.

    Anyway, best then to look at the various configuration options for the reports and see where it is different than the others.

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

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans