Question 1

I can't log in to Dynamics GP. What should I check first?

Accepted Answer

Start by verifying your credentials — check for typos, caps lock, or extra spaces in the username or password. If login still fails, a GP administrator can log in with elevated credentials (such as ‘sa’) and reset your password via Administration > Setup > User. If that doesn’t work, your SQL administrator or GP partner can reset the password directly in SQL Server Management Studio (SSMS). If you’re not a system admin, escalate to your IT team or Dynamics GP partner for SQL-level access.

Question 2

GP says a user is in a module, but they've already logged out. How do I fix this?

Accepted Answer

This happens when GP retains a stuck activity record. A GP administrator should log in and navigate to User Activity to verify who is listed as active. If a user is incorrectly shown, use the Remove User tool to clear them. In some cases, you may need to manually clear the activity record via SQL — always back up your database before making direct SQL changes. If this happens frequently, it may indicate network instability or improper shutdown procedures.

Question 3

How do I set up a test company with a copy of live data?

Accepted Answer

In SQL Server Management Studio, back up your live company database, then restore it with a new name (e.g., ‘TWO’ for test). In Dynamics GP, go to Microsoft Dynamics GP > Maintenance > Create Company and register the restored database. This gives you a safe sandbox to test configurations, customizations, and year-end procedures without risking production data. Microsoft recommends always testing in a separate company before making changes to your live environment.

Question 4

I clicked 'Print' but the GP report won't appear. What's happening?

Accepted Answer

This is a surprisingly common issue. Dynamics GP queues print jobs and won’t open the next report until the previous one is closed. Check your Windows taskbar for a minimized report window. If there’s no window visible, go to Microsoft Dynamics GP > Process Monitor: if the report is listed, wait a few minutes (large reports like Historical Aged Trial Balances can take significant time). If it’s not listed, try clicking Print again and watch for it in the queue.

Question 5

SmartList isn't opening when I click on it. Is GP broken?

Accepted Answer

GP is likely fine — the SmartList window is probably just hidden. Check the Windows taskbar for a minimized SmartList window, right-click it, and select Maximize. If it still doesn’t appear, close and reopen SmartList from the menu. If you’re using multiple monitors or a remote desktop session, GP windows may open offscreen. Try disconnecting additional displays or using Windows + Arrow Keys to move the window back into view.

Question 6

How do I troubleshoot Report Writer issues in GP?

Accepted Answer

Common Report Writer problems include missing fields, incorrect calculations, and formatting issues. First, verify you’re modifying the correct report by checking Reports > Report Writer > Reports. If fields are missing, ensure the table containing the field is linked in the report’s table relationships. For calculation errors, review the calculated fields and their expressions. Always test modified reports in a test company first, and keep a backup of the original report dictionary before making changes.

Question 7

A batch is stuck in 'Printing,' 'Posting,' or 'Receiving' status. How do I fix it?

Accepted Answer

When a batch stalls mid-process, it blocks your team from continuing. If you’re using PowerGP Online, go to PowerGP Online > Utilities > Batch Reset, choose the Batch ID, and click Reset — no SQL scripts required. For on-premises environments, you’ll need help from a SQL administrator to run backend scripts that clear the stuck status. Always back up your database before running any SQL scripts, and follow trusted guidance to avoid further complications.

Question 8

How do I post to a closed year or closed period in GP?

Accepted Answer

Navigate to Microsoft Dynamics GP > Tools > Setup > Company > Fiscal Periods. Uncheck the closing flag for the period you need to post to, make your entries, then re-close the period. Be cautious: posting to a closed period affects your financial statements and may require adjustments to retained earnings. Document all entries made to closed periods for audit purposes, and always coordinate with your accounting team before reopening periods.

Question 9

My transaction-level posting session says it hasn't finished processing. What should I do?

Accepted Answer

This error typically occurs when a previous posting session was interrupted (e.g., by a network drop or system crash). First, check Process Monitor to see if any posting processes are still running. If nothing is active, you may need to clear the stuck posting record. Navigate to Microsoft Dynamics GP > Maintenance > Check Links on the Financial series to clean up orphaned records. If the issue persists, a SQL administrator can clear the SY00800 (Activity) and SY00801 (Resource Activity) tables after backing up the database.

Question 10

What is the correct order for closing modules at year-end in Dynamics GP?

Accepted Answer

Microsoft recommends closing modules in this order: (1) Inventory, (2) Receivables Management, (3) Payables Management, (4) Fixed Assets, (5) Payroll, (6) General Ledger. Each module has specific year-end procedures that must be completed before moving to the next. Always install the latest year-end update from Microsoft before beginning the close process, and perform a full database backup before starting any year-end procedures.

Dynamics ERP Knowledge Base

Microsoft Dynamics GP

Login & Access

Printing & Reports

Batches & Posting

Year-End Closing

Integration & Performance

Financial Management

Can't Find Your Answer?

Get ERP Tips & Updates