218.486.5095

Implementation Specialists

Microsoft Partner providing ERP solutions, support and consulting.

Home / Dynamics GP

Dynamics GP

Mastering Manual Payroll Adjustments in Dynamics GP

Payroll corrections happen to the best of us. Whether it’s a missed wage, an incorrect tax withholding, or a benefit balance that needs fixing, knowing how to handle manual payroll adjustments in Dynamics GP is essential – not just for clean books, but for W-2s, 941 reporting, GL accuracy, and employee trust.

In our webinar, “Mastering Manual Payroll Adjustments in Dynamics GP,” President of Implementation Specialists, Deb Sletmoen walked through the most common payroll correction scenarios and shared best practices for fixing them the right way.

Here’s a recap of what we covered.

Why Payroll Adjustments Matter

Even small payroll errors can ripple through your system – impacting payroll history, W-2s, 941 reporting, the General Ledger, and most importantly, employee trust. That’s why understanding how and when to make corrections is so critical.

The Manual Adjustment Toolkit

In Dynamics GP, you have three main tools for making payroll corrections:

  • Manual Checks – Best for missed payments, off-cycle checks, or urgent corrections. Updates payroll history, GL, and bank.
  • Adjustments – Best for tax, wage, or benefit corrections that don’t require a new payment. Updates payroll history and GL, but not the bank.
  • Beginning Balances – Best for conversions or historical loads. Updates payroll history only.

Which Correction Type Should You Use?

Correction Type Updates
Payroll
History		 Updates
GL		 Updates
Bank		 Best Use Case
Manual Check Yes Yes Yes Missed payment, off-cycle check, urgent correction
Adjustment Yes Yes No Tax, wage, or benefit correction without new payment
Beginning Balance Yes No No Conversion or historical load

Common Payroll Correction Scenarios

Here are the situations we see most often:

  • Missed wages
  • Incorrect taxes
  • Benefit corrections (HSA, insurance, retirement, employer contributions)
  • Overpayments
  • State tax errors

Walkthrough: Manual Checks vs. Adjustments

Manual Checks

Navigate to Transactions > Payroll > Manual Checks, choose your check type, enter the details (it hits Bank Rec), and review distributions – this will update the GL.

Adjustments

Use these when the net and gross impact must remain zero. Separate transactions by type, and always check distributions to review the impact on Bank Rec.

State Tax Fixes and Reconciliation

When fixing state tax errors, you’ll need to correct both taxable wages and withholding, move them from the incorrect state to the correct one, confirm with the State Tax Summary, and verify quarterly and annual impacts.

For Payroll Reconciliation, always:

  • Validate employee summary records and payroll history
  • Verify with before/after summary reports
  • Confirm dates for both 941 and GL impacts

Year-End Considerations

Year-end is when payroll errors come back to haunt you. To avoid W-2 and quarterly filing headaches:

  • Make adjustments timely with good record keeping
  • Validate 941 impact as you go
  • Keep an audit trail for backup

Reporting Validation Checklist

Before you call a correction “done,” run through this list:

  • Gross-to-Net
  • Payroll Summary
  • Payroll Register
  • GL Posting Reports

Common Mistakes to Avoid

Need More Power? Try wsTOOLS

For more advanced payroll corrections, our wsTOOLS suite includes utilities built specifically to make these fixes easier:

  • PayrollRewind
  • PayrollReset
  • PayCorrect
  • State Tax Correct

Best Practices to Live By

  • Test first – always use your test company
  • Back up your database
  • Document every adjustment
  • Reconcile payroll thoroughly
  • Corrections get messy fast – don’t hesitate to call for help

Final Takeaways

There are lots of ways to handle payroll adjustments in Dynamics GP – but the keys are simple:

  • Know your numbers
  • Use the right correction type
  • And remember: no batch works!

Have a payroll correction giving you trouble?

Our team at Implementation Specialists is here to help.

Contact Consulting: support@iscorp.biz

Contact Sales: sales@iscorp.biz

Author: Deb Sletmoen at Implementation Specialists

Choosing the Right Microsoft Partner for Your ERP Migration

The Value of a Trusted ERP Migration Advisor

Migrating your ERP system is one of the most important technology decisions your organization will make. Whether you’re moving from Microsoft Dynamics GP or evaluating a transition to Dynamics 365 Business Central, success is not just about the software – it’s about the partner you choose to guide you.

The right Microsoft partner doesn’t just implement technology. They act as a strategic advisor throughout your migration and beyond.

Why Your Microsoft Partner Matters

ERP migration is complex. It involves more than just moving data – it requires aligning technology with your business processes, ensuring user adoption, and setting a foundation for long-term growth.

An experienced partner brings proven methodologies, deep knowledge of Microsoft ERP solutions, industry-specific insights, and ongoing support long after go-live.

Key Factors to Consider

1. Proven ERP Migration Experience

Look for a partner with a track record of successfully migrating organizations from legacy systems like Dynamics GP to modern cloud platforms. Experienced partners understand data structures, legacy customizations, and potential risks, ensuring a smooth transition with minimal disruption.

2. A Structured Implementation Approach

The best partners follow a structured lifecycle including discovery, design, configuration, testing, training, and go-live support. This approach reduces risk, improves timelines, and ensures alignment with business goals.

3. Industry Expertise

ERP systems touch every part of your business. A strong partner understands your industry and can tailor solutions to meet your unique operational needs.

4. Strong Migration Strategy

A strong partner develops a detailed migration plan, supports data cleanup, ensures validation, and communicates clearly throughout the process.

5. Focus on User Adoption

Training and user enablement are critical. The right partner provides role-based training and ongoing support to ensure long-term success.

6. Long-Term Partnership

ERP is not a one-time project. The best partners provide ongoing support, optimization, and strategic guidance as your business evolves.

Business Central Tip: According to a Forrester Total Economic Impact™ study cited by Microsoft, organizations using Dynamics 365 Business Central may achieve more than 200% ROI over three years with a payback period of about six months. (Source: Microsoft)

What Sets Implementation Specialists Apart

At Implementation Specialists, we combine deep Microsoft ERP expertise with a client-first approach. With proven experience in Dynamics GP and Business Central, a structured methodology, and strong industry knowledge, we deliver end-to-end services – from planning and migration to training and support. Most importantly, we serve as a trusted advisor focused on long-term success.

Conclusion

Choosing the right Microsoft partner is just as important as choosing the right ERP system. The right partner reduces risk, accelerates time to value, improves user adoption, and ensures long-term success.

ERP success isn’t just about technology – it’s about partnership.

To learn more about ERP migration contact us at:

Consulting: support@iscorp.biz
Sales: sales@iscorp.biz

How to Prepare Your Distribution Strategy when Moving to Business Central

Key Distribution Strategy Checks Before Moving to Business Central

If you’re planning a move from Microsoft Dynamics GP to Business Central, preparing your data ahead of time is one of the most important steps you can take. In the next episode of our GP to BC migration webinar series, “Moving to BC? Things to Think About – Episode #3: Distribution Strategy for Business Central“, we focused on the distribution side of things, covering key areas in inventory, sales order processing (SOP), and purchase order processing (POP) that need attention before making the switch.

In Episode #1, we covered accounts, segments, and dimensions. In Episode #2, we tackled cleaning up customers and vendors. Now, let’s dive into your distribution data.

Review Your Customer and Vendor Data

Before we get into the distribution strategy, it’s worth revisiting some customer and vendor data points that directly affect your transactions. These are items we touched on in our last session, but they’re worth repeating because they carry over into your distribution workflows:

  • Phone numbers and email addresses should be in the correct format
  • Address IDs cannot be greater than 10 characters in Business Central
  • Payment terms should be no more than 10 characters (GP allows up to 20)
  • Customer City fields are 5 characters shorter in BC than in GP
  • Address 2 is 10 characters shorter than GP
  • Address 3 does not exist in Business Central
  • User Defined Data should be reviewed for relevance

A helpful tip: once you’ve identified inactive customers and vendors, you can choose not to bring them over during the migration. This keeps your new system clean and clutter free from day one.

Inventory, SOP, and POP Data Analysis

This is where the bulk of the preparation comes in.

Here are the key areas to review:

  • Types of inventory items – Understand what item types you’re working with and how they’ll map to Business Central.
  • Item number length – Watch for duplication when item numbers are truncated, and check for leading spaces.
  • Unit of Measure (UofM) schedules – Make sure active items have a UofM schedule assigned.
  • Item classes – Review and clean up as needed.
  • Purchase receipts – Ensure all purchase receipts have a valuation method on the record.
  • Serial and lot settings – Confirm these are accurate before migration.
  • Site and BIN lengths – Both are limited to 10 characters in Business Central.

dynamics gp software screen showing item maintenance inventory sop and pop to prep for distribution strategy data clean up

It’s also important to note that vendor items do not automatically come over to Business Central, and pricing levels do not carry forward. Business Central offers different pricing options, so this is a great time to rethink your pricing strategy.

Clean Up Your Purchase Orders

Take a close look at your open purchase orders. Ask yourself:

  • Do you have open POs with inactive or discontinued items?
  • When was the last time you moved completed POs to history? We’ve seen customers move tens of thousands of POs to history, and the performance improvement in GP alone is significant.
  • Are there POs that have been open for years that you’ll never receive or invoice? Maybe an AP invoice was entered by mistake instead?

If PO cleanup feels overwhelming, our MassPOClose tool can help streamline the process.

Review Your Sales Orders, Quotes, and Invoices

Before migrating, take a fresh look at your sales data:

  • When was the last time quotes were reviewed? What about open orders or unposted invoices?
  • Comments (CMNT) on orders and invoices do not automatically come over to Business Central. If you need them, work with your consultant to plan for that.
  • Attachments do not automatically migrate to BC either, so plan accordingly.

This is also the perfect time to evaluate any custom functionality or custom data you’re currently using in GP. Think about what you truly need moving forward. Migration is the ideal moment to think about the future of your business processes.

How Implementation Specialists Can Help

Not sure where your data stands? We offer several tools and resources to help you get migration ready:

  • Diagnostic Data Tool – Helps you understand what data needs to be changed before moving to Business Central.
  • Smartlists – Identify data that should be reviewed so you can make informed decisions about what to inactivate, delete, or merge.
  • Feature comparison guidance – We can walk you through what’s different between GP and BC so you understand what data can be transitioned and what will need to be set up fresh in Business Central.

Our consultants can guide you through the process at any time, and we recommend starting before you kick off your Business Central project.

Ready to Get Started?

If you have questions or need help preparing for your move to Business Central, we’re here for you.

Contact Consulting: support@iscorp.biz

Contact Sales: sales@iscorp.biz

Management Reporter Tips and Tricks for Dynamics GP

Practical Ways to Build Better Reports in Dynamics GP

Management Reporter is a powerful reporting tool, but many users only scratch the surface of what it can do. Small configuration changes, built‑in tools, and smarter setup choices can make reports cleaner, easier to maintain, and far more useful. In our webinar,“Tips and Tricks in Management Reporter“, we walked through practical techniques to help Dynamics GP users save time, improve formatting, and gain better insight from their financial reports.

Start Faster With Quick Reports

Default report definitions provide preconfigured rows and columns that serve as a strong starting point for common financial statements. Modifying these templates helps reduce setup time and align reports with best practices. Insert Rows from Dimensions also allows users to pull accounts and departments directly from the chart of accounts rather than entering values manually.

software screen of quick reports column definitions in management reporter tips and tricks using dynamics gp

Build Detailed Rows Using Excel and SmartLists

Exporting account data from SmartLists into Excel makes it easier to build complex rows. Simple formulas can be used to structure account strings, which can then be copied directly into Management Reporter for faster setup and updates.

software screen of management reporter using excel and smartlists in dynamics gp

Improve Report Formatting

Formatting options such as boxes, indentation tools, find and replace, and suppressing blank rows help improve readability and consistency. Reports become easier to review and more professional in presentation.

software screen of management reporter using formatting highlighting in dynamics gp

Flexible Report Layouts

Departments or entities can be displayed on rows instead of columns, allowing for easier comparisons without drilling into reports. This layout is ideal for financial reviews that require quick visibility across departments.

software screen of management reporter using formatting drilldown and departments on rows in dynamics gp

Scheduling and Distribution

Schedules and report groups allow teams to automate report generation and standardize delivery. Report Viewer and Web Viewer features enable collaboration, comments, and summary-only views for large reports.

management reporter tips and tricks report viewer or web viewer

User Security and Access

Management Reporter security roles include Viewer, Generator, Designer, and Administrator. Permissions can be assigned by user, group, or company, helping organizations maintain control over report access and editing.

software screen of management reporter tips and tricks report viewer or web viewer

software screen of modify user in management reporter tips and tricks in dynamics gp

Smarter Column Definitions

Columns can be configured for rolling periods, dynamic headers, weekly or daily reporting, and advanced calculations. These features reduce maintenance and allow reports to adapt as data changes.

software screen of columns in management reporter tips and tricks using dynamics gp

Reporting Trees

Reporting trees support departmental, multi‑entity, and consolidated reporting. Users can generate a single report and view results by unit or summary without maintaining multiple report versions.

software screen of reporting trees in management reporter tips and tricks using dynamics gp

software screen of reporting trees reporting units in management reporter tips and tricks using dynamics gp

Built‑In Tools That Help Maintain Accuracy

Tools such as Missing Account Analysis, duplicate account checks, archiving, and upgrade prep help ensure reports remain accurate and ready for future changes.

software screen of the missing accounts upgrade in management reporter in dynamics gp

Final Thoughts

With the right setup and tools, Management Reporter can deliver clean, reliable, and actionable financial reports. Applying these Management Reporter tips and tricks helps reduce maintenance time and improves reporting confidence for Dynamics GP users.

Want to know more about Management Reporter Tips and Tricks in Dynamics GP?

Contact us at: sales@iscorp.biz

Contact us at: solutions@iscorp.biz

Moving to Business Central: Chart of Accounts

As more organizations prepare to transition from Microsoft Dynamics GP to Business Central (BC), one of the most important foundational steps is revisiting — and often redesigning — the Chart of Accounts (COA). In our webinar, Moving to BC? Things to Think About – Episode 1: Chart of Accounts Clean-Up, Vice President Cheryl Simmons and Director of GP Services, Gina Bothun, walked through what companies should evaluate long before migration begins.

A clean, modern, and strategically structured Chart of Accounts (COA) doesn’t just make the move to Business Central smoother — it sets your financial system up for scalability, clarity, and long-term success.

Understanding Your Current GP Chart of Accounts

Dynamics GP uses a segmented account format that defines how all windows, reports, and ISV solutions reference account numbers. In many environments, this structure has evolved over years (or decades), creating inconsistencies, duplicates, and formatting challenges.

Key things GP users should review:

  • Account structure and maximum lengths — GP allows up to 45 characters and 5 segments, but many companies don’t use them intentionally.
  • Segment names and purposes — Properly naming segments helps ensure accounts are automatically and consistently named as they’re created.
  • Use of segments for filtering — Segments can be powerful report filters — if they’re structured well.

account format setup and account maintenance in chart of accounts clean up in dynamics gp

Before moving to BC, take a critical look at whether your segments still make sense for reporting, departmental needs, and future growth.

Account Types in GP: Are You Using Them Effectively?

GP offers several account types, each serving a unique purpose. Cleaning these up now can prevent confusion later.

  • Posting Accounts — Your standard accounts used for day-to-day financial activity.
  • Unit Accounts — Track non-financial data (e.g., number of employees, units installed, square footage). These can become valuable dimensions in BC.
  • Fixed Allocation Accounts — Used to automatically distribute transactions across multiple accounts based on predefined percentages.
  • Variable Allocation Accounts — Use actual account balances — such as unit accounts — to allocate expenses proportionally.

software screen of posting and unit accounts maintenance in chart of accounts clean up in dynamics gpsoftware screen of fixed accounts and variable accounts allocation maintenance in chart of accounts clean up in gp dynamics

Many companies discover unused, incorrectly configured, or outdated allocation accounts during COA cleanup. Fixing this early prevents messy financial data from migrating into BC.

Moving to Business Central: What Changes?

Business Central handles accounts very differently from GP, especially in how it handles segmentation and allocations.

  • Statistical Accounts in BC — BC provides statistical accounts to store non-financial metrics. These are often used as allocation drivers — similar to unit accounts in GP, but with more power and better integration.
  • Allocation Accounts — BC supports fixed and variable allocations, using:
    • Amounts
    • Quantities
    • Statistical account balances
    • Assigned dimensions

    This makes allocations more flexible and more visible within the financial data model.

software screen of statistical accounts in chart of accounts clean up in business centralsoftware screen of allocation accounts in chart of accounts clean up in business central

Dimensions: The Biggest Shift from GP to BC

GP relies heavily on segments within the account string. BC, however, uses Dimensions to provide granularity.

Dimensions in BC include:

  • 2 Global Dimensions that are always available on postings
  • 8 Shortcut Dimensions that are quickly accessible throughout the system
  • Unlimited dimension values for tracking customers, departments, projects, and more
  • Rules, priorities, and blocked combinations for maintaining data quality

software screen of general ledger dimensions for chart of accounts clean up in business central

software screen of dimensions value for chart of accounts clean up in business central

Why this matters:

Dimensions eliminate the need for overly long or overly segmented account structures. Instead of dozens of accounts representing every possible combination, BC streamlines your COA and lets dimensions handle the detail.

Chart of Accounts Considerations Before You Migrate

Our VP, Cheryl Simmons, and Director of GP Services, Gina Bothun, emphasized several critical questions every company should ask now, not later:

  • Do you have multiple accounts with the same name? This is common in GP but creates confusion during migration.
  • Have you marked inactive accounts — or are you carrying around years of unused ones? Clearing them out reduces clutter and improves mapping accuracy.
  • How will your organization grow? Your new COA should support:
    • New locations
    • Growth in business units
    • New reporting expectations
    • Scalability in BC
  • What do you want your NEW Chart of Accounts to look like? Designing it intentionally — instead of replicating GP’s structure — leads to cleaner reporting and more flexible financial insights.

Start Planning Your New COA Now

A migration to Business Central is the perfect time to:

  • Redesign a modern, simplified COA
  • Leverage dimensions for better reporting
  • Clean up old, duplicate, or unused accounts
  • Standardize naming, numbering, and allocation methods
  • Reduce manual work and increase automation

The sooner these conversations begin, the smoother your migration will be.

Need Help Restructuring Your COA or Planning Your GP to BC Move?

Our GP and BC experts can help assess your current setup, design a modern Chart of Accounts, and ensure a seamless transition.

For consulting and technical guidance, contact: support@iscorp.biz
For solution discussions and migration planning: sales@iscorp.biz

Business Central Migration: Why Planning Your Move from GP Is Critical

How a Business Central Migration Protects Business Continuity

For decades, Microsoft Dynamics GP has been the trusted ERP platform for finance and operations teams. It powered growth for thousands of organizations and became deeply embedded in day-to-day accounting, reporting, and operational workflows. But the ERP landscape has fundamentally changed – and so has Microsoft’s strategy.

Today, delaying a move from Dynamics GP is no longer just a technical decision: It is a business risk decision. Migrating to Microsoft Dynamics 365 Business Central is no longer a “someday” initiative; it is a critical step toward protecting business continuity, enabling growth, and staying competitive in a cloud-first, AI-driven world.

1. Dynamics GP Is a Legacy Platform with a Defined End

Microsoft has clearly communicated the long-term direction of its ERP portfolio. Dynamics GP is approaching the end of its lifecycle, with mainstream support ending in December 2029 and security updates ending in April 2031. After that point, organizations will be running a mission-critical financial system without full vendor support, regulatory updates, or product innovation.

While this may seem distant, ERP migrations are not short-term projects. Waiting until support deadlines approach compresses timelines, increases risk, and limits partner availability.

2. On-Premises ERP No Longer Aligns with Modern Business Needs

Dynamics GP was designed for an on-premises world. Even when hosted in third-party environments, it still requires server management, manual upgrades, specialized technical skills, and higher long-term IT overhead.

Business Central, by contrast, is a cloud-first ERP with automatic updates, built-in security, and reduced infrastructure burden – freeing IT teams to focus on strategic initiatives.

3. Microsoft Innovation Is Focused on Business Central

Microsoft’s investment roadmap is unambiguous. New functionality, AI capabilities, and platform enhancements are being delivered to Dynamics 365 Business Central – not Dynamics GP.

Organizations that delay moving from GP to Business Central, fall further behind each year in automation, analytics, and integration capabilities. 

The limitations of on-premises systems can hinder agility and responsiveness. Without the flexibility offered by cloud solutions, businesses may find themselves struggling to keep pace with evolving industry standards and customer expectations.

4. Security, Compliance, and Audit Risk Increases Over Time

As Dynamics GP nears the end of support, businesses face growing exposure related to compliance, audits, and cybersecurity. Business Central benefits from Microsoft’s enterprise-grade cloud security, compliance certifications, and continuous monitoring.

5. Business Central Enables Scalability and Growth

Business Central supports modern extension-based customization, dimensional accounting, multi-entity growth, and seamless integration with the broader Microsoft ecosystem – capabilities that are increasingly difficult and expensive to maintain in GP.

Organizations that embrace a Business Central migration can benefit from a more agile infrastructure, allowing them to respond quickly to market changes, customer demands, and industry trends.

6. Business Central Migration Is a Strategic Opportunity

Migrating from Dynamics GP to Business Central is not just a technical upgrade. It is an opportunity to eliminate technical debt, modernize processes, improve reporting, and align ERP capabilities with long-term business goals.

Looking Forward to Business Central

Dynamics GP has maintained a long and successful run, yet the future of ERP is cloud-based, continuously updated, and AI-enabled.

For organizations still running Dynamics GP, the most critical question is no longer if you should migrate to Business Central, but how soon you want to secure your future, and we are here to help you every step of the way.

To learn more about your migration path contact us at:

Consulting: support@iscorp.biz
Sales: sales@iscorp.biz