VBA Customisation To Microsoft Dynamics GP 2013 Login Window To Display Desktop Alert If Caps Lock On

Microsoft Dynamics GPIn 2009 Patrick Roth, on the Developing for Dynamics GP blog, posted a customisation for the Microsoft Dynamics GP login window which displays a message box if the caps lock is on when the user goes to enter their password.

Then, back in July, Aaron Berquist on his blog High Dynamic Range, posted an article on using VBA to create a desktop alert to users which doesn’t take focus away from the application.

I decided to take a look and see if I could combine these two ideas into one and have a desktop alert displayed when the user has caps lock on when logging in, which is far less intrusive than the message box approach by Patrick.

The result is a customisation of the login window (which you can download at the end of the post) to display an alert if the user has the Caps Lock on using the desktop alert code Aaron posted.

The code displays a message to the user if they have Caps Lock on when the login window displays, or when they tab into the Password field if they haven’t already seen the message;

Desktop Alert

The customisation was created in GP 2013 and has only been tested in this version of GP but has been tested on Windows Server 2008 R2 and Windows 8. As with everything I post here, it is supplied entirely without warranty and you use it at your own risk.

However, if you do have problems let me know and I’ll see what I can do to fix them.

[wpdm_file id=2]

MDGP 2013 Feature of the Day: Search by Contract in Revenue Recognition

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The sixtieth feature they’ve announced is Search by Contract in Revenue Recognition.

In Dynamics GP 2013, a new filter by Contract Number field is added to the Contract Revenue Recognition window. You can select a single contract number and view only the un-posted revenue entries for that contract for all periods up to and including the fiscal year and period selected. You can then post the revenue for the single contract.

Contract Revenue Recognition

This new feature is targeted at the following roles:

  • Accounting Manager
  • Controller
  • CFO
  • Customer Service Manager
  • Customer Service Rep

MDGP 2013 Feature of the Day: RMA Sales Order Consolidate

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifty ninth feature they’ve announced is RMA Sales Order Consolidate.

In Dynamics GP, the creation of the cross ship order is per RMA line. If there are multiple lines on an RMA, each line generates a new SOP order.

Now with Dynamics GP 2013, you can optionally consolidate multiple cross shipped lines on an RMA onto a single SOP order document. As long as the SOP order is open, any additional lines cross shipped for that same RMA will be added to the same sales order.

Service Setup Returns

Continue reading “MDGP 2013 Feature of the Day: RMA Sales Order Consolidate”

MDGP 2013 Feature of the Day: Reprint Payables Management Remittance

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifty eighth feature they’ve announced is Reprint Payables Management Remittance.

Now, in Microsoft Dynamics GP 2013, you can reprint the vendor check stub or remittance form after you’ve processed the payment. You can see invoices that were paid, credits that were applied and other information that displays on the check stub or remittance.

Re-create Check Stub is available on the Payables Payments Zoom window;

Payables Payments Zoom

Check Remittance

This new feature is targeted at the following roles:

  • Accounts Payable
  • Bookkeeper
  • Certified Accountant
  • Accounting Manager

MDGP 2013 Feature of the Day: Consolidate Revenue Recognition to Single GL Entry

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifty seventh feature they’ve announced is Consolidate Revenue Recognition to Single GL Entry.

The contract revenue recognition process creates a General Ledger batch named LIABI which contains the account information from all marked contracts to be posted. Prior to this change, a journal entry was created for each unique contract number. Now, this batch will contain one journal entry consolidating the account information by fiscal period and year, and you will still be able to see the account detail for each contract line within the single transaction.

Continue reading “MDGP 2013 Feature of the Day: Consolidate Revenue Recognition to Single GL Entry”

MDGP 2013 Feature of the Day: Item Description From RMA

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifty sixth feature they’ve announced is Item Description from RMA.

In prior versions of Microsoft Dynamics GP, the SOP document that was generated from an RMA had an item description that was a concatenation of the return item, RMA number and RMA type. Most customers would have to edit each line. Now the item description will contain the actual returned item’s description. This will happen for any SOP Return document generated from RMAs. Also, a SOP invoice generated from RMA closing for any final charges will now use the invoice item’s description.

Continue reading “MDGP 2013 Feature of the Day: Item Description From RMA”

MDGP 2013 Feature of the Day: RMA And SOP Consolidation

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifty fifth feature they’ve announced is RMA and SOP Consolidation.

In Microsoft Dynamics GP, the creation of the cross ship order is per RMA line. If there are multiple lines on an RMA, each line generates a new SOP order.

Now with Dynamics GP 2013, you can optionally consolidate multiple cross shipped lines on an RMA onto a single SOP order document. As long as the SOP order is open, any additional lines cross shipped for that same RMA will be added to the same sales order.

Continue reading “MDGP 2013 Feature of the Day: RMA And SOP Consolidation”

MDGP 2013 Feature of the Day: Hotline Notes Re-Sorted

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifty fourth feature they’ve announced is Hotline Notes Re-Sorted.

Currently in Service Call Management, the hotline notes are appended to the bottom of the text rather than inserting the latest notes at the top of the stack.

With Microsoft Dynamics GP 2013, notes entered in the Hotline Entry window are displayed in the Call Number Note window newest first. You will always have the most recently entered information at the top of the window. Any additional notes you enter in the Note window will remain where you entered them.

Service Call Entry/Update

This new feature is targeted at the following roles:

  • Dispatcher
  • Customer Service Manager
  • Customer Service Rep
  • Outbound Technician
  • Account Manager
  • Sales Manager
  • Dedicated Sales Rep

MDGP 2013 Feature of the Day: US HR Year End Age – Life Insurance

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifty third feature they’ve announced is US HR Year End Age – Life Insurance.

Microsoft Dynamics GP 2013 now supports an “End of Year” method for calculating life insurance premiums determined by age based tables.

End of year will set the record age to the age which the employee will be at the end of the current calendar year. This age will be used to determine premium amounts.

Life Insurance Setup

This new feature is targeted at the following roles:

  • HR Assistant
  • Compensation and Benefits
  • HR Generalist

MDGP 2013 Feature of the Day: Build Check Exception Report

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifty second feature they’ve announced is Build Check Exception Report.

Microsoft Dynamics GP 2013 US Payroll now includes a Build Check File Exception report as part of the payroll build reports.

The Build Check File Exception report contains only build errors and warnings. This allows the user to easily identify and focus on any issues in a payrun.

Posting Setup

Continue reading “MDGP 2013 Feature of the Day: Build Check Exception Report”