Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 2013 Budget Macro E...
Microsoft Dynamics GP (Archived)

GP 2013 Budget Macro Extremely Slow now

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

All of a sudden our Dynamics GP budget Macro which has about 171 time entries and 20 expense entries is running at a snails pace.  It would take 1 minute to run previously and now it takes 45 minutes.  The SQL server is running like a champ and I have watched the profiler, activity monitor, and resource monitor and nothing even close to an issue on the performance end is occurring.  I have ran the budget macro from many different machines all the same response.  

What can I look at to investigate this issue?  

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: GP 2013 Budget Macro Extremely Slow now

    One of the weirdest cases I have ever heard of

    Glad you got it resolved finally.

  • KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: GP 2013 Budget Macro Extremely Slow now

    Wow! How did you end up tracking this down?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2013 Budget Macro Extremely Slow now

    I figured it out after 2 weeks which was terrible for us.  Anyway someone created the fiscal year 2800 on accident so it had to process 800 years each line.  

  • Suggested answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: GP 2013 Budget Macro Extremely Slow now

    Hi Paul,

    Any chance someone accidentally turned on SQL logging in the dex.ini file and forgot to switch it off? I haven't tried it but I imagine having it enabled while executing a lengthy macro could cause performance issues.

    Good luck!

    Kirk

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2013 Budget Macro Extremely Slow now

    Yes but thats not a good indication takes about the same amount of time to manually do it fast.  

  • soma Profile Picture
    soma 24,406 on at
    RE: GP 2013 Budget Macro Extremely Slow now

    Have you tried to manually enter a transaction in GP?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2013 Budget Macro Extremely Slow now

    I have a ticket open with MS, I have outside consultants looking at it, no one can figure it out.  Its a GP macro file.  You go to Play --> and then point to the macro file.  

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: GP 2013 Budget Macro Extremely Slow now

    Hi Paul,

    If you enter the transaction manually, does it go fast? A macro, if it's a Dynamics GP macro is simply a keyboard replicator. There is no reason I can think of that would cause it to be slower than typing it in yourself. Has anyone changed the macro. I'm guessing that you aren't talking about a GP Macro.

    What kind of macro are you running? What kind of budget are you populating?

    Kind regards,

    Leslie

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans