web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 10 takes too much t...
Microsoft Dynamics GP (Archived)

GP 10 takes too much time while posting Sales Transaction.

(0) ShareShare
ReportReport
Posted on by Asif Fattah

Dear All,

I am using Microsoft Dynamics GP 10. from last 3 days when I am going to post Single Sales Transaction Batch It takes 20 to 30 minutes. We are using AA and we don't have more then 2000 entry in Sales Order Process Module. 

Can any body tell me how can I resolve this issue.

Regards,

Asif Fattah

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,854 Moderator on at

    Are you saying you have 2000 invoices in your sales batch and it takes 20 minutes to post or you have 2000 total invoices and even a single invoice takes 20 minutes to post? Was it always this way or did this just start 3 days ago? If it just started you may be experiencing a hardware failure with your RAID array in your server. You will need to bring in server experts to first determine what is causing the problem. Start by running Task Manager and Resource Monitor to determine is there is a hardware issue. Then you could move onto using SQL profiler and try posting these batches while you are the only one in GP. I do not think the problem is with GP there is something wrong with the environment housing GP. Report back what you find and then we can move onto other things.

  • Asif Fattah Profile Picture
    Asif Fattah on at

    Currently in our existing GP Server I have Total No. of Sales Transaction are 2000. In single batch I have one or two Transaction which I am going to Post but that 1 or 2 Transaction taking 20 to 30 minute. This delay only happen in Sales Transaction. When I am going to post other then Sales Transaction Its working fine. delay only occur during posting of Sales Transaction. So I think this problem relates to GP.  

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    And did your all 2 to 3 transactions get posted successfully after 20 to 30 minutes or you get some errors?

    almas

  • Asif Fattah Profile Picture
    Asif Fattah on at

    Yes, all Transaction posted without any error.

    If No. of Transaction Increase in Sales Batch the time is also increased. If we have 10 Transaction in Batch then It may take 1 to 1.5 Hour.

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    and do you have any customization on sales entry window or on posting?

  • Asif Fattah Profile Picture
    Asif Fattah on at

    No customization at all.

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    Then I would say without looking into your environment can't say anything, need to check this through several means, did you try sql profiler? is it happening with some specific user?

  • Asif Fattah Profile Picture
    Asif Fattah on at

    Is there any Check list which I can go through to check the performance of Microsoft Dynamics GP.

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    If there is any specific list I would also love to know, but in your situation I would first try sql profiler , I have same delay issue on gp login it takes 10 to 15 minutess to login and I found, it is calling some procedure repeatedly.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,854 Moderator on at

    If it is only in SOP posting perhaps there are corrupt records in inventory or a locked record in SQL. If you can I would reboot the SQL server and then in SSMS run this command while NO one is in GP.

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

    If this does not help, I would try these steps.

    1) Backup company database

    2) Run Check Links on all modules all series

    3) Run Inventory Reconcile

    4) Try posting again. If problem persists run SQL Profiler while posting.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans