Microsoft Dynamics GP Fall 2020 Release New Features: Automate full General Ledger Reconcile

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Automate full General Ledger Reconcile Financial enhancement.

This feature means you can now select All to have Dynamics GP reconcile through the years in order from oldest to newest.

In the Reconcile Financial Information window (Financial area page » Utilities » Reconcile), users can now select All for all years to be reconciled in order from the oldest year to newest year. This is a change from the previous functionality where users had to run the reconcile process for each year in turn:

Reconcile Financial Information

Continue reading “Microsoft Dynamics GP Fall 2020 Release New Features: Automate full General Ledger Reconcile”

Microsoft Dynamics GP Fall 2020 Release New Features: 1099-MISC Updates

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the 1099-MISC Updates Financial enhancement.

The 1099-MISC form has been revised to meet the IRS regulatory changes for the 2020 tax year. In the Vendor Card point to Options, point to Tax Type: Miscellaneous, point to 1099 Box, click the drop-down menu.
Box 9: Crop insurance proceeds are reported in.
Box 10: Gross proceeds to an attorney are reported in.
Box 12: Section 409A deferrals are reported.
Box 14: Nonqualified deferred compensation income is reported.
Boxes 15, and 17 report state taxes withheld, and amount of income earned in the state, respectively.
Box 7 was moved to the 1099 NEC form as a checkbox Payer made Direct Sales of $5,000 or more, etc.
Box 16 the state number is not a currency field and it is available at the header level of the 1099 details window. Therefore, the data entered in the header will be shown in the form.

1099 Details

Click to show/hide the Microsoft Dynamics GP Fall 2020 Release New Features Series Index

A re-evaluation of categories and tags in my ClassicPress blog

ClassicPressI started this blog way back in June 2011 and have ended up writing far more blog posts than I ever imagined; this year alone I have written more than 350 posts and this isn’t even my highest post count.

Over the years, I’ve covered a number of subjects for which I have created categories and tags; in fact far, far too many of each have been created. I’ve been meaning to take a look at them for quite a while (I’m now actively planning what to do).

One of my fellow ClassicPress plugin authors, CodePotent/John Alarcon did a blog post on ClassicPress Categories and Tags Demystified where he takes a thorough look at categories and tags in ClassicPress and how they can best be structured, as well as some of the pitfalls and mistakes to avoid (many of which I have not avoided).

I’m going to take a good read of John’s post and finalise my plan for restructuring this site to reduce the number of categories and tags in use, which will hopefully simplify navigation and make things easier to find.

With over 2,300 posts, and several hundred new ones being added every year, I’m not sure how much I can simplify things, but I’m still pretty sure I can make some substantial improvements.

azurecurve ClassicPress Plugins: Events

ClassicPress PluginsThis is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress.

The plugin I am going to cover in this post, is a brand new one written for ClassicPress; Events.

Functionality

Events allows events such as webinars or conferences to be created via a custom post type; categories, excerpt, details, start and end dates and times and a featured image are all supported.

In the options set defaults for the widget and shortcode.

Multiple widgets can be created, each assigned to display a category; settings for title, image size and limit for number of events to list can be set per widget.

The event shortcode accepts three parameters:
* slug to select specific event.
* width to set the size of the featured image.
* height to set the size of the featured image.

Shortcode usage is [event slug=”december-2021″ width=150 height=150]; all parameters are optional and will use the defaults set via the settings page.

The events shortcode accepts four parameters:
* category to restrict the output to the selected category.
* width to set the size of the featured image.
* height to set the size of the featured image.
* limit to restrict the number of events to display.

Shortcode usage is [events category=”webinars” width=150 height=150 limit=5]; all parameters are optional and will use the defaults set via the settings page.

Download

The plugin can be downloaded via my Development site.

Click to show/hide the azurecurve ClassicPress Plugins Series Index

Upcoming Microsoft Dynamics GP Webinars from ISC Software

ISC Software SolutionsI’ve been quite busy both in and out of work recently and have lagged in the writing of blog posts, so I thought I’d let you know of the three upcoming monthly webinars I’ll be delivering for ISC Software.

We run these webinars on a monthly basis, with occasional extra webinars added to the schedule so it is worth checking the Webinar Schedule page every so often.

The upcoming webinars are:

Year End Best Practice in Microsoft Dynamics GP
In December is Year End Best Practice in Microsoft Dynamics GP; learn best practice on performing the year end close on the different modules in Microsoft Dynamics GP, from the General Ledger and Analytical Accounting, to Fixed Asset Management and Inventory Control, to Payables and Receivables Management.

Tue, December 15th, 2020 4:00 PM – 4:45 PM BST

Register Here

​What's New in Microsoft Dynamics GP Fall 2020 ​Release
In January is ​What’s New in Microsoft Dynamics GP Fall 2020 ​Release; see the new features available in the new Fall 2020 Release of Microsoft Dynamics GP.

Tue, January 19th, 2021 4:00 PM – 4:45 PM BST

Register Here

Automation in Dynamics GP
In February is Automation in Dynamics GP; discover how to improve efficiencies in Microsoft Dynamics GP through the use of automation.

Tue, February 16th, 2021 4:00 PM – 4:45 PM BST

Register Here

Microsoft Dynamics GP Fall 2020 Release New Features: Add DBA Name field on Vendor Maintenance window for 1099 Vendors

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Add DBA Name field on Vendor Maintenance window for 1099 Vendors Financial enhancement.

When a business is created in the United States or Canada, they have the option of using a DBA, or “Doing Business As” name, in addition to the legal entity name; the DBA name is the operating name of the business, or how the business is known to customers, or operating name, as opposed to the legal name of the business. Vendors that have a DBA name, in addition to the legal company name, and want to have the DBA name appear on the 1099 that is issued to them, can now do so.

Add DBA (Doing Business As) field to the Vendor maintenance window, reporting and 1099s. It is common for companies to have a legal name registered but do business under another name, the name customers see. The feature enables the user of both the legal name of a company and DBA. From the Purchasing home page under Cards, choose Vendor and click Options.

Go into Purchasing, point to Cards, click on Vendor, select the Vendor ID, click on Options, enter the DBA name in the field, click OK:

Vendor Maintenance Options

Continue reading “Microsoft Dynamics GP Fall 2020 Release New Features: Add DBA Name field on Vendor Maintenance window for 1099 Vendors”

Recent ISC Software Webinar: Prepayments and Accruals

ISC Software SolutionsIn our most recent webinar, we took a look at Prepayments & Accruals in Microsoft Dynamics GP and how both can be processed using standard functionality, before then taking a look at some of the ways in which accruals can be automated. If you want to catch up on this, or any other, webinar, you can do so here.

There are three main parts to the webinar (plus the references):

  1. Prepayments
  2. Accruals
  3. Automating Accruals
  4. Add-ons referenced in the webinar

Continue reading “Recent ISC Software Webinar: Prepayments and Accruals”

Microsoft Dynamics GP Fall 2020 Release New Features: Non-Employee Compensation (NEC) for 1099 form

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Non-Employee Compensation (NEC) for 1099 form Financial enhancement.

The IRS is releasing a new 1099 NEC form for the 2020 tax year; Non-Employee Compensation, which had been included in the 1099 MISC form, has been moved to its own form.

In the Vendor Card in Options, you now have the option of selecting Non-employee Compensation as a 1099 tax type. The Utility “Update 1099 Information” also includes selecting Non-employee Compensation.

To access the Non-employee Compensation tax type, choose Purchasing select Cards and then choose Vendor, once you choose a vendor click Options. In the Tax Type drop down menu, select Non-employee Compensation.

To make a Mass Update go to the Purchasing, choose Utilities and select Update 1099 Information, make the selections in this window for Tax Type From and To.

Vendor Maintenance Options

Continue reading “Microsoft Dynamics GP Fall 2020 Release New Features: Non-Employee Compensation (NEC) for 1099 form”

Microsoft Dynamics GP Fall 2020 Release New Features: Enable Self Service user type to access User Preferences

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Enable Self Service user type to access User Preferences System enhancement.

This feature means Self Service users will now have access to the Workflow Delegation window within User Preferences, allowing them to set their own delegations up when they know they will be unavailable:

Workflow User Delegation

This is a nice addition which will make it a lot easier for clients to properly manage delegations.

Click to show/hide the Microsoft Dynamics GP Fall 2020 Release New Features Series Index

Microsoft Dynamics GP Fall 2020 Release New Features: Save per user column layouts on Home Page

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Save per user column layouts on Home Page System enhancement.

this new feature will allow users to customize and save the layout of their Home Page through the Customize this page… in the upper-right corner of the Home Page.

They can then use the bottom section of the Customize Home Page window to select the Column Layouts and how they stack when a section is maximised:

Customise Home Page

The column number setting is held in the syHomePageLayout (SY08100) table in the system database; the SectionID column will contain the following values:
1 = To Do
3 = Business Analyzer
4 = My Reports
5 = Quick Links
6 = Connect
7 = Time Management
8 = Procurement
9 = Project Time and Expense
10 = PowerBI

The Column Stack setting is held in the syHomePage (SY08000) table, the ColumnStackPosition column will contain the following values:
0 = Top
1 = Bottom
2 = Right
3 = Left

I’m surprised this is a new feature as I thought all of the settings on this page were already per user.

Click to show/hide the Microsoft Dynamics GP Fall 2020 Release New Features Series Index