Creating a List of Unreconciled Bank Transactions in Dynamics GP?

Here is an easy way to create a SmartList of unreconciled Bank Transactions. Go to Microsoft Dynamics GP > SmartList. In SmartList, navigate to Financial > Bank Transactions. Select the option with the asterisk.

Click on Columns and then the add button to add the columns that you would like to appear in the SmartList. Click OK when you are finished.

Next, click on the Search icon. Add the restrictions to the SmartList. Set the checkbook ID equal to your checkbook ID, set Voided equal to no and set Reconciled equal to No. Then click OK.

This will give you the list of unreconciled transactions. Click on Favorites and give your report a name. Then click Add > Add Favorite.

Contact CSSI for GP Technical Support and Training

For GP help and training, please contact CSSI. Our team of experts stand by to assist!

Have you ever had the need to print a trial balance containing non-sequential account numbers?  Say you would like to see a GL Trial Balance detail for just a couple of main segment account numbers, but do not want to see all the accounts in between. 

Here is an example.  We need to see GL detail for accounts containing 6100 and 6520 as their main segments.  But we do not want to see any other accounts on our report. 

You can create this custom report using the GL Trial Balance and GL Navigation Lists!

1. Go to the Financial page

2. Click on Accounts in the Navigation pane and wait for your accounts to list

3. Click on Add Filter

4. Enter your first filter then click on the down arrow to the right of the second Add Filter and select the “Or” condition

5. Add your second filter then click on the arrow circled below to Apply Filter

6. The filtered account list will appear

7. Select the accounts to be included on the report. Select all reports by checking the checkbox on the header row.

8. Click on the down arrow under Reports and select Print Trial Balance

9. Choose whether you want to Include Details. Select the Year then click on Print.

10. You can save the filter list for future use. Click on Accounts (read only) at the top of the screen and select Save As

11. Type in a name and click on OK

12. The new list will now on the Financial Navigation pane under Accounts

Note: Navigation lists are available for all GP modules.

That’s it!

Need GP Training or Support?

CSSI offers experienced GP experts who are available for training, technical support, and upgrades. Please contact CSSI to discuss your GP needs.

Printing Separate Checks to Vendors, One Check Per Invoice

Have you ever had the need to print separate checks to one vendor, one check per invoice?  GP provides three different options for doing this.

1. If you want to always print one check per invoice for this vendor, go to Vendor Maintenance, select the Vendor, click on Options, and changed the setting highlighted below.

2. If you use the Build Payment Batch window, there is a “One Payment Per” option.  You can select Use Vendor Option, which will look at each vendor’s option shown in method # 1 above.  Or you can select “Invoice”, which will create one payment per invoice (for all vendors in this “Build”).

3. Use different Remit To address IDs in AP invoices.  When you enter an invoice in Payables Transaction Entry, you can change the Remit-To ID.  Each Remit-To ID will receive a separate check.  For example, if you enter three AP invoices for the same vendor, with each invoice containing a different Remit-To ID, then that vendor will receive three checks.

That’s it!

Need Dynamics GP Support?

Do you need technical support or training with Dynamics GP? Contact the GP experts at CSSI for help.

2024 General Ledger Year-End Closing

Have you run your GL year-end closing routine yet?  Here is a refresher on what this process does.

• Closes all Profit and Loss (P/L) account balances into Retained Earnings account(s)
• Balance Sheet account balances are rolled forward to the new year by having Balance Brought Forward (BBF) entries created.
• All open General Ledger records (GL20000) are moved to the historical table (GL30000).
• Inactive General Ledger accounts without a balance and no historical transactions are removed if you are not ‘maintaining’ inactive accounts.
• The Year that was just closed is marked as historical.

Even though you have closed the year, you can still post to that year.  GP allows you to post back to the last closed year.  Just be sure your Financial module is open in Fiscal Periods Setup (Microsoft Dynamics GP > Tools > Setup > Company > Fiscal Periods).

GP also allows you to reverse a year-end closing.  When you reverse a historical year, the original Balance Brought Forward (BBF) journal entry gets removed from the system.  Then when the year is re-closed, a new BBF entry is created.  Once the year is re-opened, this allows you to post adjustments in the GL and when ready, you can re-close the year.

Need GP Support?

The GP experts at CSSI are available if you need support or training. Please contact us to discuss.

GP Tip: Dynamics GP Posting Setup

Did you ever wonder why you sometimes have batches that need to be posted in the General Ledger even when your posting setup is set to “Post Through General Ledger Files”? The first “Post Through General Ledger Files” checkbox setting will automatically post transactions assigned to a batch through the General Ledger. The second “Post Through General Ledger Files” checkbox will automatically post transactions through the General Ledger at the transaction level, meaning transactions will be posted to the GL even if they are not assigned to a batch.

The transaction level Post Through General Ledger Files setting is available on the following posting setup windows:

Need Dynamics GP Support?

Need more GP support? Our experienced team of GP consultants is standing by to help. Please contact us to discuss your GP support needs.

GP Tip: How to make customer or vendor info a GL Transaction Smartlist favorite

You can take advantage of Dynamics GP’s Smartlist feature in many ways to save time. Here’s how you can make customer and vendor information a favorite in the GL Transaction Smartlist….

Go to Microsoft Dynamics GP > Smartlist and open Smartlist. Then click on Account Transactions.

Click on Columns.

Click Add.

Scroll to Originating Master ID. Hold down CTRL and select Originating Master ID and Originating Master Name.

Then click Ok.

You will then see the Originating Master Id and Originating Master Name displayed on the smartlist.

Save the smartlist by clicking Favorites. On the Add or Remove Favorites Window give the smartlist a Name and click Add, Add Favorite.

That’s it! Hope this helps.

We Provide GP Technical Support

You should have a GP partner who is responsive and helpful to your needs. Our team of experienced GP experts are ready to provide fast and friendly service when you need it. Contact CSSI for GP support or help?

GP Tip: How to bring back the navigation pane

Have you ever had the Navigation Pane disappear while using GP? Here’s how you can bring it back yourself!

The solution is to click the Layout Button in the top right corner of Microsoft Dynamics GP. Unselect and then re-select the Navigation Pane option.

When you select the Navigation Pane option the Navigation Pane will then be displayed in GP.

That’s it!

Need GP Technical Support

If you would like GP help, training, or upgrade support, the team of GP experts at CSSI would be glad to help. Please contact us for GP help.

Microsoft GP Support Ending in 2031

October 2024 – After selling and supporting Microsoft Dynamics GP for over 25 years, we at CSSI Technologies are saddened to report that Microsoft has just announced a multi-year timeline for ending its support of GP in 2031. Let us begin by saying that CSSI remains committed to supporting our Dynamics GP customers. The same is true for the industry partners and add-on developers who make GP such a great product.

The most important message is: Don’t panic! There is plenty of time to think about any ‘next steps’, and we must also note that Microsoft has repeatedly tried to end GP in the past, only to fail because the 40,000+ companies (in the US alone!) which use GP refused to move to what they perceived as substandard products. This history may again repeat itself.

Microsoft’s Timeline for Ending GP Security Updates

Below is Microsoft’s official timeline for the sunsetting of Dynamics GP:

• April 1, 2025: No new sales of Perpetual licenses. New Subscription licenses continue for 1 more year.
• April 1, 2026: No new customer sales for any type of license (Perpetual or Subscription).
• September 30, 2029: End of product enhancements, regulatory (tax) updates, service packs and technical support.
• April 30, 2031: End of security updates.

What to expect in the leadup to 2029?

Microsoft’s development and support of GP will continue through Sept. 2029.

GP remains business-as-usual until then. You can still submit and vote for product suggestions for features you would like to see added in the next few years. There are hundreds of ideas here, grouped into 30 categories.  Vote on existing suggestions and/or submit your own.

What happens in Sept. 2029 and beyond?

After product support and enhancement stops in September 2029, the only Microsoft support available with be specifically for security updates and hotfixes. Microsoft will end security updates and fixes in April 2031.

But wait… that doesn’t necessarily mean the end.

GP is very mature and stable. Even after Microsoft’s technical support ceases, GP will continue to be a very functional system for those customers who wish to keep using it.

As time goes on after 2031, it is possible that changes in the Windows and Windows Server operating systems, SQL Server, Exchange Server and Microsoft Office platforms may cause problems. However, we are seeing some early indications that members of the GP ecosystem may step in to play a role and resolve these problems. We will keep you posted as we learn more.

What are Microsoft’s intentions?

Microsoft has made announcements like this before, and each time, the Dynamics GP community has continued to thrive.  CSSI uses Dynamics GP itself, so we understand its importance to you.  Your GP system is more than just software—it’s the backbone of your business.  It’s where your finances, operations, and decision-making converge. We know that many of you rely on a mix of third-party add-ons and customizations to run your business.

Microsoft is going to try to convince GP users to quickly ‘migrate’ to Business Central, its newer subscription-only product. Microsoft loves the subscription model, since once your business is committed to Business Central, you will be defenseless against any and all future subscription price increases.

We advise caution for now, for these reasons:

1. Business Central is hard-pressed to replace the stability and deep, vertical functionality that GP and its community of ISV Solutions has come to offer over years of maturation. If GP is working well for you, be cautious about moving to software which may not work as well for your business.
2. We are concerned that Microsoft is downplaying the complexity and expense of a Business Central implementation, particularly for heavily-customized GP users. The time and expense of moving should be closely examined and reality-checked by anyone considering a move.
3. Be aware that Microsoft has a history of attracting users to new software platforms with low pricing, and then increasing the price once customers face barriers to exit. Once you are locked into the subscription model, you will largely be at Microsoft’s pricing mercy.

CSSI Technologies will continue to support GP

If you’re worried that this announcement marks the definitive end of GP, don’t panic.  We’ve been through these waves of uncertainty before when Microsoft tried to convince GP users to migrate to other systems. However, GP customers have continued to use and depend on their systems for 5, 10, even 15 years after Microsoft’s previous “end-of-life” dates.  It is possible that this pattern may continue well past 2031.

CSSI remains committed to supporting Dynamics GP.

With a runway of 7 years, you don’t need to feel pressure to take hasty action. As we learn more about this developing situation, we will keep you informed. So please watch our monthly GP newsletters for updates.

Please let the team at CSSI Technologies know if you have questions!

GP Tip – Excluding Inactive Customers/Vendors from GP Lookups

Here’s a time-saving GP for you. Do you have many inactive customers and vendors the clutter up your lookup windows? You can easily exclude them by following these steps:

1. In the lookup window, click on the drop-down to the left of View
2. Select “Exclude Inactive Customers” (or Vendors)
3. Click on the drop-down again
4. Select “Set as Default View”

Need GP Support?

If you need GP training or GP technical support, please contact CSSI for help!

GP Tip: Wondering How To Reset Your Next Check #?

When printing checks, is your starting check number always wrong? To reset the Next Check Number, go to Financial > Cards > Checkbook. Select the Checkbook ID. Change the Next Check Number field then click on Save.

Need GP Training or Support?

CSSI offers friendly GP support. Please contact us if you have a need!