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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Export MR to Excel - t...
Microsoft Dynamics GP (Archived)

Export MR to Excel - too many decimal places

(0) ShareShare
ReportReport
Posted on by Althea ADS 10
MR set to 2 decimals. Lines are CAL type. Results look fine. Export to Excel and 7-8 decimal places. We copy/paste results to GP as Journal Entry and always shows out of balance. How to format MR to dump 2 decimals to Excel?

*This post is locked for comments

I have the same question (0)
  • Althea ADS Profile Picture
    Althea ADS 10 on at

    We have tried many formats in MR but all look like they have 2 decimals in MR viewer, but soon as you export to Excel and click on a cell - they are many decimal places.  This makes the customer need to format all using the ROUND formula on all (hundreds of) cells.  Extra step they must do every day.  GP does not like more than 2 decimals in journal entries - says won't post - out of balance.

  • Suggested answer
    ShawnMD Profile Picture
    ShawnMD 1,456 User Group Leader on at

    Unfortunately, I can't help but to say that I have tried TOO many times to get this to stop... so hopefully someone out there has an answer... but for me, I think we are stuck :-/

  • Althea ADS Profile Picture
    Althea ADS 10 on at

    All the rows were using a column that showed $ and another for % (CBR).  So they would not format for Excel or we'd lose the % formatting.  So what I just tried was to make an additional set of rows that just reference the rows above (CAL type / @100 / format #,###.00) and restrict to column B only.  This printed just the description and 2 decimal dollars that did transfer to Excel in the correct format.  Now they can scroll down and copy from the bottom for the journal entry (allocations).  It still doesn't fix the issue, but still a work around.  :-)  Thanks!

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans