Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

GP-other users are using report writer

(0) ShareShare
ReportReport
Posted on by 316

Hello,

I am attempting to access the Report Writer and am getting a message "other users are using report writer"

I had all users log out and made sure that the following tables were clear:

ACTIVITY, SY00800 AND SY00801

There is some reference to "temp" files possibly causing the issue.

Could you help provide more details to a resolution?

Thanks!

*This post is locked for comments

  • RE: GP-other users are using report writer

    nice topic 

  • NorK Profile Picture
    NorK 316 on at
    RE: GP-other users are using report writer

    Hello,  I customized the PM TB with Options summary report.  The instructions were for the detail but I got it to run.  I am missing the header for the 91+ bucket I added and the amount isn't bolded.  Any thoughts on those issues?

  • NorK Profile Picture
    NorK 316 on at
    RE: GP-other users are using report writer

    Restarting the server worked perfectly!

    Thanks again!

  • NorK Profile Picture
    NorK 316 on at
    RE: GP-other users are using report writer

    Thanks so much!  I am always looking for a neat trick to make life simpler :)

  • Verified answer
    twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: GP-other users are using report writer

    Hi Nork

    I would follow the instructions that you have for the detail trial balance and move the additional aging buckets into the report.

    Note that they are 2 different reports the detail and summary HATB's.

  • NorK Profile Picture
    NorK 316 on at
    RE: GP-other users are using report writer

    Yes, I was going to export the customizations and make a backup of reports.dic before making any changes.  Thanks!

  • NorK Profile Picture
    NorK 316 on at
    RE: GP-other users are using report writer

    I am actually going to work a quick mod to add an aging bucket to the Historical Summary TB.  The Historical Detail TB already has it.  Is there a quick way to get it to the Summary from the Detail?  I have the following article to reference

    support.microsoft.com/.../how-to-add-a-new-bucket-to-the-aged-trial-balance-detail-with-options

  • twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: GP-other users are using report writer

    Also, do as I suggest, make a copy of your reports.dic file and work there until you fully test out your modifications.

    Once you are satisfied, move the report into the production reports.dic file.  Easy enough to do with the Customization Maintenance functionality.

  • NorK Profile Picture
    NorK 316 on at
    RE: GP-other users are using report writer

    Hello,

    Thanks!  We will plan on restarting the servers to free up the lock

  • Verified answer
    twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: GP-other users are using report writer

    Hi NorK

    Most likely there is a lock on the reports.dic file.

    My personal favourite way to remove these locks would be to reboot the server that the reports.dic file is on.

    Nothing like giving the server a fresh start.

    If you reports.dic file is also on your SQL server then restarting will also clear the temp files in SQL as well.

    As a note of caution, you shouldn't work in your production reports dictionary while users are on the system as the reports.dic file can become corrupted.

    Best practice is to make a copy and for development and create a new set file to point to this development reports.dic file for new reports or modifications.

    When fully tested you can roll the new or modified report into the production reports.dic file.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans