Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP2010 is erroring whe...
Microsoft Dynamics GP (Archived)

GP2010 is erroring when a inventory report is ran

(0) ShareShare
ReportReport
Posted on by warriorlax1234 60

I have an employee who needs to run a 25,000 total product inventory report once a week. When this is done, it gets to about 22,191 products and sometimes less, then has a nice " sorry gp had an error and needs to close" message. Details reveal a dynamics.exe issue with a offset error of 0000120e and modname: ntdll.dll error. I have done a reformat and install on a xp pro, on her machine. Installed GP2010 after all SP's were installed etc... My only successful run of this report was in safe mode with networking. I logged in under her domain credentials, and gp login. Under non safe windows, it fails time and time again when I try certain things. What could this possibly be? On a side note, if she logs in on another computer, using her credentials, it can be ran. But the reformat of her pc is a brand new dell 380 tower, different from her prior hardware setup...

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: GP2010 is erroring when a inventory report is ran

    Hi,

    There are couple of things that you can check- Is excel version on two PCs (Re formatted PC and another PC used for testing) same? When she (user facing the issue) logged in from another machine, did she use her own windows credentials or logged in different windows credential but her own GP Credentials?

    However, as Leslie pointed out Smartlist is not a very good idea for such large report. You can try using Excel refreshable reports for it. You can deploy them at a shared location using Reporting Tools Setup window (Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Reporting Tools Setup)

    You can watch some videos by Belinda about using the excel report. These are not specific to inventory reports but the idea is same

    www.belindathegpcsi.com/.../Excel%20Refreshable%20Reports

    Rubal,

    http://dynamicsgphelp.com/

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: GP2010 is erroring when a inventory report is ran

    SmartList is really not the best answer for a report this size, tell me you are not trying to export this to excel :)

    If Excel is the answer, have you tried the totally unsupported Dex.ini switch of

    ListsFastExcelExport=TRUE or

    SmartlistEnhancedExcelExport=TRUE

    Kind regards,

    Leslie

  • warriorlax1234 Profile Picture
    warriorlax1234 60 on at
    Re: GP2010 is erroring when a inventory report is ran

    This is windows xp, and I have already done that.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: GP2010 is erroring when a inventory report is ran

    Is this WXP or W7? Try disabling any anti-virus software and turn off  UAC if W7.

  • warriorlax1234 Profile Picture
    warriorlax1234 60 on at
    Re: GP2010 is erroring when a inventory report is ran

    It's a smart list. This does not use a reports.dic.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: GP2010 is erroring when a inventory report is ran

    Are you using a local or shared reports dictionary? Are you using a modified version of this report? I would copy the REPORTS.DIC from a working computer to her computer and try to run the report. You could also make sure she is using the default version oft his report and not the modifed version.

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