Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / another blast from the...
Microsoft Dynamics GP (Archived)

another blast from the past question - Frx 6.7 SP 11

(0) ShareShare
ReportReport
Posted on by iruser2 2,046

hi folks

 

another blast from the past question - please no replies to upgrade to MR

 

Frx 6.7 SP11

 

A reporting tree was 230 ish rows long.  More companies were acquired now it is 374 rows long.

 

Previously able to export the resulting financial statement to excel with one tab for each unit on the tree, including export formulas.

 

Now exporting formulas the excel file is not even created if you export the whole tree.

 

If you export portions of the tree you get a file.

 

If you turn off export formulas you can export the whole tree.

 

Suggestions as to how to export the whole tree and formulas?

 

Suggestions that this may be a known bug that is not going to be corrected? (I have read all the posts about spaces in file name and file path - that was supposedly fixed in SP10, but just in case I have taken spaces out of the file name.)

 

thanks!

 

*This post is locked for comments

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: another blast from the past question - Frx 6.7 SP 11

    I was first attempted to think that this was a limitation of the numbers of tabs you can have in Excel (which I thought was 255), but it turns out that this is only limited by the amount of memory you have available.. .Some interesting facts about Excel : office.microsoft.com/.../excel-specifications-and-limits-HP005199291.aspx

  • iruser2 Profile Picture
    iruser2 2,046 on at
    RE: another blast from the past question - Frx 6.7 SP 11

    with 374 rows on the tree one by one is not really practical.  I randomly chose different rows on the tree to export and it was fine.  Finally I ran the report to the frx viewer and from inside the viewer was able to export to excel with the formula.  The result was slightly different than the direct to excel export in that the viewer hid the rows, and the direct to excel summarized the rows.  That is acceptable.  All the tabs are the same shape so the user can select all the tabs and summarize manually.

    thanks for the suggestions folks.

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: another blast from the past question - Frx 6.7 SP 11

    Perhaps you could isolate the problem to a particular unit by running 1 unit in the tree at a time.  Then continue to add units until the problem appears.

    Tim

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: another blast from the past question - Frx 6.7 SP 11

    A long time since I used it - does the formula export create additional tabs?  I wonder if this could be more of an Excel issue - too many tabs in the workbook?  Just clutching at straws really!

  • iruser2 Profile Picture
    iruser2 2,046 on at
    RE: another blast from the past question - Frx 6.7 SP 11

    no worries Jonathan.  This particular customer has a third party that they are in love with that has not updated so they cannot upgrade.  Of course the recommendation is the move off Frx and onto MR, but sadly these people cannot.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: another blast from the past question - Frx 6.7 SP 11

    I do not know MR but I have seen a few posts where you are asking not for responses about upgrading. Please note that if someone from Microsoft reads these type of posts we are inclined to recommend upgrading. While it may not be the resolution you are looking for please understand that we need to do this due to products no longer being supported.

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans