Recent ISC Software Webinar: Year-End Best Practice in Microsoft Dynamics GP

ISC Software SolutionsIn our most recent webinar, we took a look at Year-End Best Practice in Microsoft Dynamics GP. In this webinar, we covered how some key points to action or consider before starting, the order in which the year end should be run before running through the closing process in each of the standard modules in Microsoft Dynamics GP covering not only what to do. but also what the year-end closing process does. If you want to catch up on this, or any other, webinar, you can do so here.

In this blog post, I am going to recap the webinar and include some links to documentation from Microsoft which will expand on some areas with more detail. The topics I’ll cover are:

  1. Key Points
  2. Year-End Processing Order
  3. Year-End Closing steps by module
  4. Conclusion

Key Points ^

There are five key points I always stress when discussing year-end closes with clients:

  1. Always have a good backup before starting a year-end close and take another after the year-end close has completed – a good backup is defined as one which you know will successfully restore; unfortunately I’ve worked with more than one client over the years who created a maintenance plan to take backups, but then, when the need came, found that the backups were not valid and could not be restored.
    Taking a backup before starting means you can easily revert back should there be a problem in the close; taking a backup after the close completes, means that if problems encountered later in the day that you can revert back to after the close has completed instead of having to repeat the close.
  2. Make sure all users log out of the company in which the year-end is being processed.
  3. Make sure there is sufficient space for database files to double in size; one significant cause of this is that the GL year-end close will copy data from Year-to-Date Transaction Open (GL20000) to Account Transaction History (GL30000) and during this process the data will exist in two places causing the database to grow.
  4. Perform a trial year-end close on a copy of live in test before closing the year-end on live; this will allow you to verify that there are no issues which might require a roll-back.
  5. Once one of the Year-End Closes has been started, be patient and allow it to run to completion. When processing, the close might cause Dynamics GP to white-screen, but this is just a sign that there is a lot of server-side processing underway and not that there is a problem.

Continue reading “Recent ISC Software Webinar: Year-End Best Practice in Microsoft Dynamics GP”

Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Show Check Number in Apply Sales Document window

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements series where I am going hands on with the financial enhancements of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

The seventh, and last, financial enhancement is the display of the check or card number in the Apply Sales Document window (Sales area page » Transactions » Apply Sales Document) which was was entered on the payment at the time of entry:

Apply Sales Document

The addition of the field has meant a little shuffling of existing fields on the window, but the addition of this field improves visibility and allow users to be sure they are applying the correct payment.

Hands On with Microsoft Dynamics GP October 2019 Release New Features

Hands On with Microsoft Dynamics GP October 2019 Release New Features
Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Sort companies in User Access Setup
Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: Filter inactive users in User Access Setup
Hands On with Microsoft Dynamics GP October 2019 Release New Features – System Enhancements: More than 32 report options in Report Group
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Long description for payables transaction entries
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Expand the view of fiscal periods
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Show user who posted for Journal Entry Inquiry
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Add Class ID to Fixed Assets Transfer
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Document Attach available in Bank Reconciliation
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Visual Cue for EFT Vendor on Edit Payment Batch
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements: Show Check Number in Apply Sales Document window
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: User Workflow
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: User Security Workflow
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: Security Roles Workflow
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: Security Tasks Workflow
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: Export and import workflows
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: Change approver for active workflow tasks
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Workflow Enhancements: Vendor approval enhancements
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Copy Report Option
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Filter Item Stock Inquiry by Date
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Exclude Inactive Items on Item Price List Report
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Minimize transaction when Go To is selected for PO that exists
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Save setting for how to show new POs
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Inactive field added to Item SmartList
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Show the User ID in the Items SmartList
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Paste from Excel in Web Client
Hands On with Microsoft Dynamics GP October 2019 Release New Features – Financial Enhancements
Long description for payables transaction entries
Expand the view of fiscal periods
Show user who posted for Journal Entry Inquiry
Add Class ID to Fixed Assets Transfer
Document Attach available in Bank Reconciliation
Visual Cue for EFT Vendor on Edit Payment Batch
Show Check Number in Apply Sales Document window

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Ship To Address Retained by Customer Combiner

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The twenty-first new feature is Ship To Address Retained by Customer Combiner. This feature will retain the ship to address when customers are merged using the Customer Combiner tool:

Customer Combiner and Modifier

I’ve tested this feature and compared it to the functionality in 2018 RTM, and I can’t tell the difference. The Ship To address of the destination customer, does not change in either version and the ship to address from both the source and destination customers are both available after the combine.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Email Customer Statements

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The thirteenth new feature is Email Customer Statements. This feature of the day allows a single statement to be emailed to a customer direct from the Customer Maintenance window (Sales area page » Cards » Customer) using the Email button on the action pane:

Customer Maintenance

Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Email Customer Statements”

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Transaction Level Post Through General Ledger

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The seventh new feature is .When transaction posting is enabled, this feature allows users to perform posting through the General Ledger at a transaction level. The following is a list of supported transactions for this feature:

  • Invoice Entry
  • Receivables Apply Doc.
  • Receivables Cash Receipts
  • Receivables Sales Entry
  • Sales Deposits
  • Sales Trx Entry
  • Voided Trx Maintenance (Sales)
  • Payables Trx Entry
  • Payment Entry
  • Purchasing Invoice Entry
  • Purchasing Prepayments
  • Receivings Trx Entry
  • Returns Trx Entry
  • Assembly Entry
  • Transaction Entry (Inventory)
  • Transfer Entry
  • Manual Checks (Payroll)
  • Project Accounting Transaction windows except Project Closing

To enable post through for transactions, open the Posting Setup window (Administration area page » Setup » Posting » Posting), and mark the Post Through General Ledger checkbox below the Allow Transaction Posting one:

Posting Setup

In theory this is a great addition to Dynamics GP, as many clients want to do transaction level posting, although more these days are wanting to use workflow for approvals which still requires batches.

However, in my testing so far, all Sales transactions which I post using post through work fine, but nothing on Payables posts through at transaction level regardless of the settings.

I need to do additional testing, but so far this feature isn’t looking good.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Monthly Recurring Batches

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The first new feature is Monthly Recurring Batches. This feature allows a recurring batch to be created in Payables Management, Receivables Management and Inventory Control.

When creating the batch, after selecting a Frequency of Monthly, mark the new Use last day of the month; this will change the Posting Date to the last day of the month:

Payables Batch Entry

Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Monthly Recurring Batches”

MDGP 2018 R2 Feature of the Day: Ship To Address Retained by Customer Combiner

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The twenty-fourth Feature of the Day is Ship To address retained by Customer Combiner.

When using the Customer Combiner tool to combine two customer records the ship to address will now be retained:

Customer Combiner and Modifier

While Customer Combiner isn’t generally used that much (at least by my clients), keeping the ship to address could potentially be very useful.

Click to show/hide the MDGP 2018 R2 Feature of the Day Series Index

MDGP 2018 R2 Feature of the Day: Email Customer Statements

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The thirteenth Feature of the Day is Email Customer Statements.

This Feature of the Day is all about convenience of sending customer statements. In Dynamics GP 2018 R2 users can email customer statements directly from a button on the action pane in the Customer Maintenance window (Sales area page » Cards » Customer). This new E-mail option will automatically send the statement to the email address setup for the customer:

Customer Maintenance

This feature builds on the Single Customer Statement new feature from Dynamics GP 2018 RTM; the original feature of the day post from Microsoft said “print”, but the linked PowerPoint dsaid “email”.

I believed the email part and when I got hands on with the feature was disappointed to find it was only a print.

I’m assuming this feature for 2018 R2 is in response to my, and others, feedback on the print option. I’m very happy to see this has been expanded to an email option now as this will make this feature usable to quite a few of my clients.

Click to show/hide the MDGP 2018 R2 Feature of the Day Series Index

MDGP 2018 R2 Feature of the Day: Monthly Recurring Batches

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The first Feature of the Day is monthly recurring batches. This new feature allows ou to, on both Monthly and Bi-monthly batches to mark a Use last day of month checkbox which will update the Posting Date to the last day of the month.

This functionality has been added to Receivables Management, Payables Management and Inventory Control:

Receivables Batch Entry

The example above, shows a receivabled batch dates 30/04/2027 which, with the new checkbox marked, will automatically set the posting date to the last day of the month. So, when the batch is posted the next posting date would be set to May 31.

My initial impression was that this would be a good addition, until I realised that it did not include the General Ledger Financial Batches. I can’t think of a single client who uses recurring batches in any of Receivables, Payables or Inventory.

Click to show/hide the MDGP 2018 R2 Feature of the Day Series Index

Enabling Email for All Master Records

Microsoft Dynamics GPIf when Microsoft Dynamics GP is implemented, you know that email documents is going to be used, the functionality can be enabled alongside the rest of the system, but for clients who were not, for example, using Purchase Order Processing from the start it needs to be switched on after the fact.

When first discussing it with the client, my initial thoughts were to use a macro to enable merged from the supplier list to step through the vendors/creditors and enable that way.

However, just before I started to explain this, I remembered a feature tucked away on the Vendors/Creditors navigation list. If you click the button, in the Modify section of the area pane, of two chevrons pointing to the right you get a pop-up menu containing an Email Settings option:

Creditors navigation list

Continue reading “Enabling Email for All Master Records”