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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Dynamics GP Sales Forecasting Freezing

(0) ShareShare
ReportReport
Posted on by 3,437
Hi:
 
When I try to pull up a forecast in the Manufacturing Sales Forecasting window, GP freezes.
 
Why and how can I fix this, other than by waiting?
 
Thanks!
 
John
Categories:
I have the same question (0)
  • Suggested answer
    Lisa at AonC.com Profile Picture
    1,001 Super User 2025 Season 2 on at
    Is this something that used to work and now isn't working?  (If so, any ideas on what changed?) 

    If you do let it run long enough, does it complete?  (If so, running a SQL Profile to see what is taking so long may provide some insight.)

    Does it happen on all workstations?  What about when GP is launched directly from the SQL Server (if GP is installed there)?
  • JE-20081519-0 Profile Picture
    3,437 on at
     
    This is the first time that I have used it.  The forecast contains 1,530 records and was imported via Table Import.
     
    I have let it run, for almost five minutes, and the forecast is still frozen.
     
    I only use the GP "RDS" server.
     
    Thanks!
     
    John
  • Suggested answer
    Lisa at AonC.com Profile Picture
    1,001 Super User 2025 Season 2 on at
    Following Table Import, did you run Check Links and/or other GP maintenance to validate the data after import?  (Since Table Import is a physical table-level import, related tables may also require imports.)

    (Here is the link to Use Table Import to import data into Microsoft Dynamics GP - Dynamics GP | Microsoft Learn.)

    I recommend thoroughly testing all imports/maintenance in a test company prior to attempting in production.

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

Responsible AI policies

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

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 673 Super User 2025 Season 2

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 673 Super User 2025 Season 2

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 391 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans