SOC 1 Type 11 Reporting


Dynamics GP Year-End Premier Training

Posted by Samantha DeLaire

Dec 21, 2018

Don’t miss out on SMB Suite’s year-end training classes!


SMB Suite - Premier Services Training

  • Free for Premier Service Customers who receive unlimited Help Desk Support
  • $100 for Non-Premier Service Customers

Up to 25 attendees can attend the GoToWebinar, reserve your seat now! No limit on number of attendees per customer.

Premier Service Training Schedule


Best Practices - Year End Close Process

  • Recommended Order to Close Modules
  • Steps prior to closing the module
  • What does the close process do

Best Practices – 1099 Year End Process

  • Vendor Setup
  • Transaction Processing
  • Editing 1099 Information
  • 1099 Printing


Read More

Topics: tips and tricks, Microsoft Dynamics GP, Dynamics GP, GP 2018 R2, year-end

Microsoft Dynamics GP 2018 R2 Tips!

Posted by Samantha DeLaire

Nov 7, 2018

In the newly released version of GP 2018 R2, there are new features available to help you save time and your sanity!


Post Through – Transaction Level Posting

  • Super helpful for SOP transactions
  • You can select to allow for transaction level posting and post through General Ledger files


No More Hanging Batches


Default AP Checkbook on Payments!

  • Setting default checkbook
  • Purchasing -> Setup -> Payables


It Defaults on AP Batches!


Default Recurring Batches – Last Day

  • Monthly/ Bi-Monthly


Allow Partial Purchase in the PO that was initially made from a Purchase Requisition


Print and Email SOP document at the same time

Read More

Topics: tips and tricks, Microsoft Dynamics GP, Dynamics GP, GP 2018 R2

SMB Suite’s Dynamics GP in the Cloud, Embrace Your Opportunity!

Posted by Samantha DeLaire

Aug 8, 2018

Brief history: ERP in the cloud has been referred to by many names, including application service provider (ASP) accounting solution, accounting software on demand, software-as-a-service accounting (SaaS Accounting), and recently from Microsoft Dynamics GP, hosted accounting. Although there may be some minor variations among these terms, the underlying principle is largely the same: under a cloud ERP delivery model, applications are housed in a remote location and delivered directly to end users as a service via the Internet. 

Is this a good fit for my business?  A small or medium business: A company that needs flexibility, low costs and better ways to analyze and deploy information through IT resources so they can stay competitive. That’s what it’s all about right—less capital, more gain.

How did SMB Suite address this issue? By launching Dynamics GP in the cloud! In fact, there’s nothing better than the robust environment of an ERP system developed for the Small to Medium Business Market to embrace opportunities that today’s business environment brings. Dynamics GP in the cloud shifts much of the burden of onsite systems into a solution that provides benefits.

Here are some fun facts as to why shifting from internal staff management to the cloud is a game changer:

  • NO up-front Capital investment. True, Monthly Subscription OPEX and lower total cost of ownership (TCO) for you, the customer.
  • Rapid deployment of the application. We are talking about shaving months off of on-premise implementation. Yeah, you read it right, months.
  • Software upgrades, maintenance, and innovations? As the provider of the Dynamics GP Cloud, it’s already included in the subscription price so you’ll get them without the hassle and additional cost seen from traditional providers.
  • Re-purposed budgets—you won’t be spending all your capital upfront on your ERP solution so you can re-purpose that investment into revenue generating assets. The ability to redeploy IT support tasks to more value-creating business initiatives. 
Read More

Topics: Microsoft Dynamics GP, cloud ERP

7 Reasons to Attend Microsoft's Dynamics User Group Summit

Posted by Samantha DeLaire

Jul 30, 2018

Microsoft Dynamics is having a user group summit in Phoenix, Arizona this October 15th through the 18th.

Users of Dynamics GP, NAV & Business Central have the opportunity to meet with peers, Dynamics specialists and third-party solution providers.

The User Group Summit is the largest and most comprehensive event for Microsoft Dynamics and other technology professionals.  The event tackles what is going on in the industry and follows the trends in the Microsoft ecosystem. Not only is this a great opportunity for professional development, but for the bottom line of an organization.  Connecting with and learning from other Dynamics and technology professionals from across the globe generates new ideas to bring back to your team.

This is an ideal venue for finding partners who are perfect fits for your specific needs. The Expo Hall is filled with third-party solution providers, implementation consultants, and training partners who not only specialize in Microsoft Dynamics and other technologies but who truly understand the challenges unique to your industry.

Top Reasons for Attending:

  1. Summit Phoenix’s dedication to bringing users to the forefront of technology problem-solving and product development will help your team gain a stronger sense of what’s available and how you can put these tools and techniques into practice.
  2. Summit Phoenix is created by users, for users; for every job role. The Programming Committee members who determine the content come from fields like administration, development, finance, and IT. They pride themselves on staying current with what matters most and understanding user needs for a variety of product versions.
  3. Experts, MVPs, and Microsoft team members will discuss industry trends, product roadmaps, and learning strategies impacting your organization.
  4. The practical, hands-on Conference Academy workshops will show us how to solve your team’s challenges and use your products in better, more efficient ways.
  5. It’s a networking opportunity that can’t be compared. Summit Phoenix creates the space for easy knowledge sharing so you will learn from peer experiences that only come from unscripted conversations.
  6. The user group community is year-round so the networking won’t stop on-site. This vibrant and virtual network will help you continue to make the most of our software year-round.
  7. The expo is filled with more than 380 leading industry suppliers and the latest and greatest tools and technologies, all ready to help you solve our organization’s biggest challenges.


For more information about Summit Phoenix, please visit:

Read More

Topics: Microsoft Dynamics NAV, Microsoft Dynamics GP, microsoft dynamics 365, Microsoft Summit 2018

Dynamics GP and NAV in the Cloud

Posted by Samantha DeLaire

Jul 17, 2018

Join us for a Q&A session led by Steve Anderson to see what GP and NAV look like in SMB Suite’s Cloud.

What integration is available with other Microsoft products?

  • Office 365
  • Dynamics 365 for Sales
  • Power BI
  • Add-on Enhancements

How are customizations handled?


Ongoing support help?


User administration?

System monitoring?

Threat protection?




Register for the webinar today!

Thursday, July 19th @ 1:00pm CST:

Register Here


Read More

Topics: webinar, Microsoft Dynamics GP, Microsoft Dynamics NAV, cloud solution

Jet Remote Data Services with SMB Suite

Posted by Samantha DeLaire

Mar 28, 2018

SMB Suite will offer a hosted Jet Remote Data Service (JRDS) instance for our SMB Cloud GP customers beginning in Q2 2018.

The Jet Remote Data Service (JRDS) data source presents a three-tier architectural design with a service component that is hosted within Internet Information Services (IIS).  It provides a fast, secure connection method for environments where Jet users have Excel installed locally and their Dynamics GP system is hosted on a different domain.


Detailed information on Features (Dynamics GP): 

Friendly names for tables and fields

In Dynamics GP, you may notice that the table and field names that are listed in the Designer window are somewhat cryptic. The design tools in Jet Essentials and Jet Express (e.g. Table Builder, Browser, Report Builder,Jfx, etc.) can display your table and field names in several easily readable formats, similar to the Smart List window in GP.

The friendly name feature requires three tables - JETFPG, JETTMAP, and JETFMAP.  The GP Update Utility adds these tables to your database and populates them with them with the Friendly Names provided by Dynamics GP.


Jet Views

Jet Views are SQL views which bring together information from one or more SQL tables into a view that is designed for reporting from.  The Jet views have been designed around common report writing areas to make it easier for report designers to create reports.  The GP Update Utility adds SQL views to the GP company database with the prefix "Jet”.  These views include:

  • Jet CustomerMaster
  • Jet CustomerOpen Application
  • Jet CustomerOpen Transactions
  • Jet CustomerPeriod Balance
  • Jet Date
  • Jet FiscalPeriod
  • Jet GL Account
  • Jet GLTransactions
  • Jet Item AllLocations
  • Jet Item byLocation
  • Jet PayrollTransactions
  • Jet ProjectAccounting
  • Jet PurchaseDetail
  • Jet PurchaseHeader
  • Jet SalesDetail
  • Jet SalesHeader
  • Jet VendorMaster
  • Jet VendorOpen Applications
  • Jet VendorPeriod Balance

(this list subject to change in future updates).


SQL Roles

This GP Utility feature takes advantage of the Role-based security model in Dynamics GP by offering the user access to certain tables and views.  Jet Reports has created their own User Roles as well.

The JetAllUsers role provides users with access to the following tables: 

  • SY01500 on the Dynamics database
  • JET_DATE, JETFMAP, JETFPG, JETTMAP, JETVMAP on the company database*


For more information, please contact



Samantha DeLaire, Client Engagement Manager

Office 469.351.2138 | Mobile 949.246.3884 | Email

7701 Las Colinas Ridge, Suite 100, Irving, TX 75063

Read More

Topics: jet reports, Microsoft Dynamics GP

Dynamics 2018 GP New Features Video Released

Posted by Samantha DeLaire

Mar 9, 2018

Microsoft has just released a new video showcasing new features in Dynamics GP 2018.

GP 2018 VIDEO has released           

Requested straight from customers, new features include:

Turning off garnishment reports

Purchase order number added to the purchase requisition navigation list for procurement

Ability to roll down from setup for Payroll and Human Resource

Print and email a single statement from the customer card

Print purchase requisition 

Save select payment settings

Copy user access across analytical accounting dimension codes

Once Check per invoice vendor setting

Reprint distribution detail and summary reports

Doc attach added to more areas:

  • Receivables transaction entry
  • General Ledger transaction entry
  • Employee Inquiry
  • I-9 Form
  • (Fixed Assets) Asset general information
  • And more!

OData Version 4

GP Power BI Content Pack

Additional sorting added to

Select Bank Transaction windows

Payables Transactions Inquiry windows

Receivables Transactions Inquiry windows

Renamed Payables windows from “Checks” to “Payments”

SmartList Password per SmartList

Wellness and Health Insurance Integration

Display Hold Status on Sales Transactions

Purchase Order (PO) Generator opens the Purchase Order List with New PO Filter

Exclude Inactive deduction code filters added to deduction lookup window

Once Click Access to SmartList in Web Client

Bank Reconciliation maximum window in Web Client

Autocomplete in Web Client

Update sample data date and documentation

General Ledger Account Approval Workflow

Purchasing Invoice Approval Workflow

Purchasing Invoice Approval Workflow

Copy Workflow Step

Payables transaction Workflow Additional Fields

Vendor Workflow Additional Fields for EFT/ Bank Information

Reporting for Workflow

Purchase Order Notification to Requisition Originator

Reminder Emails for Workflow

Purchase Order Workflow messages – additional field

HRMSS Employee Email Changes for Timecards

Project Time & Expense (PTE) Email Approval Functionality


Here is the Microsoft Dynamics GP blog series:




Read More

Topics: Dynamics GP, Microsoft Dynamics GP

Microsoft Dynamics GP 1099 Year-End Close Tutorial

Posted by Samantha DeLaire

Jan 9, 2018

Follow these simple steps to make your year-end close process go more smoothly.

When setting up a vendor, you need to make sure they are entered with 1099 information so that the 1099 income will be recorded.

To set up 1099 income for a vendor:

  1. Open the Vendor Maintenance Card: Purchasing >> Cards >> Vendor
    1. Select your vendor from the lookup icon.
    2. Click the OPTIONS button.
  1. When you are done selecting your 1099 options, click OK to close the window.

       3. Save then close your vendor file.



Look at the Payables Transaction Entry Window.  Note that when you are entering an amount in the purchases field for a 1099 vendor that the amount auto-populates the 1099 amount field.


When the blue arrow is selected next to the 1099 amount field a pop up window will open displaying the Tax Type and the 1099 Box number associated with the 1099 amount.


Close your A/P Year End

Make sure that you post all transactions for the year you intend to close before closing the year. And, be sure to back up your data before closing;


  1. Begin your A/P close: Microsoft Dynamics GP >> Tools >> Routines >> Purchasing >> Year End Close


1099 Edit Report


  1. Print Edit Report for 1099:  Routines >> Purchasing >> Print 1099


  1. Select your 1099 Type and Form Type.


  1. Click the PRINTER ICON to print an edit list for review. **Do not select Print Forms!!


  1. Review your edit list for any corrections needed and correctness.


How to compare your 1099 data to confirm it is correct:

There are a few different ways that you can review your 1099 data to determine that it is correct.

  3. Enter a vendor from your 1099 Edit Listing and pull up their history. You can add together the current year transactions showing in the listing and compare them to the 1099 Edit Listing.


Full Tutorial here with screenshots and tips and tricks:
1099 & PAYABLES Year-End Close


Read More

Topics: Microsoft Dynamics GP

Microsoft Dynamics GP Roadmap - GP 2018 to be released 2017 H2!

Posted by Samantha DeLaire

Sep 8, 2017

Microsoft announced that Dynamics GP 2018 will be released the second half of 2017!


Stay tuned for new updates… 


Dynamics GP 2018 New Features:

  • Power BI Suite
  • Workflow 4.0
  • Document Attach Functionality
  • Financial and HR Optimization
  • Top Features Requested by GP Customers
    • Integration Improvements
    • Power BI Enhancements


Read More

Topics: Dynamics Great Plains, Microsoft Dynamics GP, GP version updates

Mobile Access: Getting Data From Your Financial Accounting Software On The Go

Posted by Samantha DeLaire

May 15, 2017

Life for financial workers at start-ups and other small- and medium-sized businesses (SMBs) is already hectic. They’re overworked, overtired, overstressed and, well, you get the idea.

There simply isn’t enough time, staff or money to get everything done during normal working hours. (An 8-hour workday — what’s that?) It’s also not feasible to clock any additional time in the office. At some point, life outside of work must be lived.

This is why mobile access to the company’s financial accounting software is so critical for SMBs. By tapping into financial data on the go, financial workers have the freedom to leave the office and still take care of work when necessary.

Consider these two scenarios:

  1. You’re at your 9-year-old’s soccer game and you get an email that an expense report needs to be updated. No problem. Click a few keys on your smartphone and it’s done. You never left the bleachers.
  2. Say an invoice, check or payroll needs the go-ahead from the CFO. But he just left on his first vacation in months and the check can’t get cut unless he signs off. Again, that’s not a problem. Once the plane lands, the CFO gets notified on his iPad and takes care of the approvals before his luggage reaches the carousel.

What do these two scenarios demonstrate? Having the ability to allow tactical activity-based tasks in a mobile world is critical. You need to be able to do these tasks outside of the office. It’s essential to increasing productivity and giving you the freedom to leave the office.

Yet many companies don’t take the leap into allowing mobile access of their financial information. They’re afraid that the data will get lost, stolen or hacked. They ask, “Do I really want my financial data on smartphones? Am I putting my company at risk just for the sake of a little convenience?”

For those concerned about putting their information on their phone, it’s important to remember that data is just as safe on a mobile device as it is on a desktop computer.

Just because you can do your work on your phone and carry it around doesn’t make it any less secure than a desktop computer. Sure, it’s possible to accidently forget a tablet or smartphone at the park, but remote data wipes are simple and efficient. Besides, if you leave a desktop computer at work, what’s to keep someone from entering your office and turning it on? In reality security is not about where your device is located; it’s about protective passwords, firewalls and appropriate encryption.

Your company can control the data on any device — a smartphone, laptop or tablet — because you’re monitoring them as users access the financial systems. There is no security difference from device to device. Just because it’s easier for you to carry the data around with you doesn't mean it’s easier for someone to access it. It’s just as secure.

Your life is already busy, but business doesn’t stop for soccer games or beach vacations. Give yourself the freedom to leave the office and still access your financial accounting software on the go. The programs can be just as secure as they are on your desktop and you won’t miss dance recitals, dinner with the family or a little extra sunshine.

Read More

Topics: ERP in the Cloud, GP Cloud Subscription, Microsoft Dynamics GP, financial accounting software