web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / FRx generating .tmp files
Microsoft Dynamics GP (Archived)

FRx generating .tmp files

(0) ShareShare
ReportReport
Posted on by leiaduva 130

We've got an issue where the head of accounting sends reports to multiple recipients. Each recipient receives different info based upon their security clearance. The report is being emailed just fine as an .xls file to most of the recipients. However, we had 3 people this time where the system tried to email a .tmp file instead of a .xls file. Our SPAM filter won't let a .tmp file through. We've tried all the usual FRx fixes (compacting the db, forcing a recompile, etc...). Nothing seems to be helping. Has anyone seen anything like this? We're on FRx 6.7 with the latest service pack, and our email agent is Microsoft Outlook 2003. Thank you!

*This post is locked for comments

I have the same question (0)
  • Michael Marinaro Profile Picture
    Michael Marinaro 9 on at
    Re: Re: Re: Re: Re: FRx generating .tmp files

    Glad you got it resolved.  Thanks for the follow up.

  • leiaduva Profile Picture
    leiaduva 130 on at
    Re: Re: Re: Re: FRx generating .tmp files

    I think I may have figured this one out. The resolution was to check mark the option to "Export Formulas" on the Output Options tab. There are multiple segments that are producing divide by zero errors in Excel. By un-checking that box, it tells Excel it must resolve those errors before completing the transform. If you check it, it allows Excel to simply display the error message if it can't resolve it. Also, I also found the file that tells where the user's working directory is for FRx and told him he needs to delete it periodically. It was full of old FRx temp files.

    This file holds the location of the working directory:

    c:\Documents and Settings\[username]\Local Settings\Application Data\FRx Software\FRx 6.7\FRX.INI

    This is the location of the working directory (that user needs to delete routinely)

    c:\Documents and Settings\[username]\Local Settings\Temp

     

  • leiaduva Profile Picture
    leiaduva 130 on at
    Re: Re: Re: FRx generating .tmp files

    One other point to note on this issue:

    If I rename the .tmp to .xls, it's garbage. However, if I rename the .tmp to .frd, I can indeed open it in the FRx Drill Down Viewer. Isn't that weird? I have read several places that you should only use the DDV for drill-through reports, but we have lots of other drill-through reports that work fine in the Excel format.

  • leiaduva Profile Picture
    leiaduva 130 on at
    Re: Re: FRx generating .tmp files

    We thought that, too, but it shows as a .tmp in his Sent Items in Outlook. Yes, all of the recipients are on the same email server with the same settings.  We had read that if the report was too large and ran out of "space" while being created that this could occur. So, we made very sure that the user had emptied his temp files and cleaned up C:/ just in case. That didn't help. This is a drill-through report and I read that you're not supposed to send drill-through reports as .XLS but rather as .FRD. However, he tells me other drill-through reports are being emailed out fine.

  • Michael Marinaro Profile Picture
    Michael Marinaro 9 on at
    Re: FRx generating .tmp files

    Hi,

    It could be that the tmp file is a place holder for the XLS file and it's actually the XLS file that isn't being allowed through by your email security.  Are all of your recipients on the same email server with the same settings?

     

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans