Belinda Allen, Smith & Allen Consulting, Inc. (SACI) aka Belinda the GP CSI.  Microsoft Professional, MCT and MVP.describe the imagedescribe the image

Belinda supports lls.org

Follow Me

MICROSOFT DYNAMICS GP COMMUNITY

If you are not a member of the Microsoft Dynamics GP Community, you should be, I am a member.

There is loads of good information, including a forum that I actively answer.

Click on this link to go to the Microsoft Dynamics Community!

Search this Blog

Loading

Subscribe by Email

Your email:

Need Microsoft Dynamics GP Forms?

Purchase Deluxe Products

Click on the image above to find your compatible Microsoft Dynamics GP forms from Deluxe For Business.

Click HERE to download Brochure.

This is all about how I use GP, based on what I learned in my investigations with clients...

Current Articles | RSS Feed RSS Feed

Microsoft Dynamcis GP 2013 US Payroll Year End Update has RELEASED!!!

  
  
  
  
  

Email From: 

Terry Heley - Escalation Engineer - Microsoft Dynamics GP

Download W-2 Wage and Tax Statement and Data Source Guide HERE

 

Download U.S. 2013 Year-End Update guide HERE


GP 2013 year end is ready to release, yeah!

It will be on the site below in about an hour

Here is the direct link to get it now

MicrosoftDynamicsGP12-KB2897363-ENU.msp

https://mbs2.microsoft.com/fileexchange/?fileID=15d9edac-266c-48d8-95e2-37d68a1588dc

GP 2013 SP 2 Translations are ready to release for French and Spanish, I will get that notice out tomorrow.

We now need to work on Canadian Payroll releases in mid-December and the changes their agency provides (we are still waiting for notice)

Belinda, of Smith & Allen Consulting in New York, NY shares Year End payroll information for Microsoft Dynamics GP.

Happy to announce ahead of schedule the US Year-end changes have released for GP 2010 

Below are the sites that list all the changes, the pages below will synch shortly and you will see it listed.

This update is all inclusive of prior updates for Microsoft Dynamics GP 2010 and GP 2013.

You can start to install and get the MSP via the link below for 2010 now:

https://mbs2.microsoft.com/fileexchange/?fileID=d85e8ceb-e263-49ac-bd6a-39b08025ba1e

Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/taxupdates/usgpye2010

Once you install the update, your version for GP 2010 will be    11.00.2292

(Also changes to Project Accounting, Fixed Assets, Human Resource, Field Service, Payroll Extensions, Advanced HR)

Microsoft Dynamics GP 2013

https://mbs.microsoft.com/customersource/downloads/taxupdates/usgpye2013

Once you install the update, your version for GP 2013 will be    12.00.1538

(Also changes to Project Accounting, Fixed Assets, Manufacturing, Human Resource, Field Service, Cashbook, Analytical Accounting,
Payroll Extensions, Advanced HR)

2014 US Payroll Round 1 Tax Update (due to release week of 12/16)

Changes so far: (circular E not final)

FICA Social Security limit, California, Kansas, Maryland, North Carolina

Please Note: The 2013 Year-End Update and 2014 Tax Updates will not be available for Microsoft Dynamics GP 10.0 and prior versions.

IMPORTANT TO NOTE THIS YEAR IF YOU USE BUSINESS PORTAL HRMSS:

 

If you are using Microsoft Dynamics GP 2013 SP 2 or above AND you use Business Portal Human Resource Self Service Suite you will need to install the BP Hotfix.

There were table changes made in GP 2013 Service Pack 2 around Payroll Direct Deposit affected Business Portal Human Resource Self Service functionality.

Please refer to my blog 'Microsoft Dynamics GP 2013 Service Pack 2 does not seem to play NICE with Business Portal Human Resource Self Service Suite 6.0' for further details around this:

https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/11/05/microsoft-dynamics-gp-2013-service-pack-2-does-not-seem-to-play-nice-with-business-portal-human-resource-self-service-suite-6-0.aspx

If you have employees that make over $200.000 you should install the year end update, this is also noted in the changes section.

If you do not install the year end update, when the year end file is created, it will grab an incorrect Medicare limit in the year end file.

If the Year End Update is not installed prior to closing Payroll:

W2 Medicare Taxable Wages may be incorrect on printed W2's (Box 5) for employees making more than 200,000.
Workaround this by updating the FICAMWLM field in the UPR10100 table as follows:
UPDATE UPR10100 set FICAMWLM=' ' WHERE RPTNGYR ='2013'
If you install the year end update you will not have this issue, if you do not have employees that make over 200,000 you also will not see this issue.

The Connect has been changed for year-end and we have a blog featured each week for different modules, check it out!

https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/11/07/back-by-popular-demand-microsoft-dynamics-gp-year-end-closing-blog-series-for-2013.aspx

Once US is out the door, we will focus on Canadian Payroll 

We are currently waiting changes for Canadian Payroll
The recent change to the ROE file submission will be in the year end update when it releases.

****Translations for GP 2013 SP 2 should release this week as well for French and Spanish.*****

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070
Tags: 

Microsoft Dynamics GP 2013– New Lookup feature (video)

  
  
  
  
  

When looking up master records in Microsoft Dynamics GP 2013, you can save any custom sort order you create.   Watch this very short video on how to do it.

 

What are master records?

  • Inventory Items
  • Employees
  • Customers and Prospects
  • Salespeople
  • Vendors
Belinda, from Smith & Allen in New York, NY, shows a new feature in Microsoft Dynamics GP 2013.
Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

Microsoft Dynamics GP - Excel AR Trial Balance with SQL (with video)

  
  
  
  
  

In this video, I create a Summary Aged Trial Balance for Receivables Management using a custom SQL view created by Microsoft Dynamics GP MVP, Victoria Yudin.  The view can be located on her blog posting below:

 

http://victoriayudin.com/2012/01/25/sql-view-for-current-receivables-aging-in-dynamics-gp/

Dashboard for Distribution Series:

 

Part 1:  Microsoft Dynamics GP - Excel AR Trial Balance

 

http://saci.com/blogs/belinda-the-gp-csi/bid/154096/Microsoft-Dynamics-GP-Excel-AR-Trial-Balance-with-video

 

 

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

Microsoft Dynamics GP 2013– New Purchase Order (POP) feature (video)

  
  
  
  
  

In Microsoft Dynamics GP 2013 there is a little feature with a BIG benefit.  You can setup Purchase Order Processing or POP to warn you if you try to close a Purchase Order when there are remaining quantities received but not invoiced.  This can save you a BIG reconciliation headache.

 

You can even password this warning to prevent someone from just clicking on the warning without ready it.

Belinda of Smith & Allen Consulting, Inc. in New York, NY shows a new Microsoft Dynamics GP 2013 feature.

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

Microsoft Dynamics GP - Excel AR Trial Balance (with video)

  
  
  
  
  

This is part 1 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

 

In this video, I create a Summary Aged Trial Balance for Receivables Management with NO SQL work, No VBA’s, No Macros, No VLookups and No named ranges.

Belinda Allen of Smith & Allen Consulting, Inc. in New York, NY speaks at the Microsoft Dynamics GP User Group (GPUG) Summit in Tampa, FL 2013.

The formulas used in this video are:

  1. Amount:  =IF([@[Document Type]]="Payments                       ",-[@[Current Trx Amount]],IF([@[Document Type]]="Credit Memo                    ",-[@[Current Trx Amount]],IF([@[Document Type]]="Returns                        ",-[@[Current Trx Amount]],[@[Current Trx Amount]])))

  2. Days Due:  =IF([@[Document Type]]="Payments                       ",0,IF([@[Document Type]]="Credit Memo                    ",0,IF([@[Document Type]]="Returns                        ",0, DAYS(TODAY(),[@[Due Date]]))))
  3. Bucket: 

    =IF([@[Days Due]] <1,"Current", IF([@[Days Due]] <31,"0 - 30 Days",IF([@[Days Due]] <61,"30 - 60 Days",IF([@[Days Due]] <91,"60 - 90 Days","Over 90 Days"))))

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

Creating and receiving a Drop ship PO Microsoft Dynamics GP (with video)

  
  
  
  
  

One of my clients asked me about cleaning up Drop Ship Purchase Orders in Microsoft Dynamics GP.  This video covers the PO side of creating and receiving a Drop Ship PO, including moving the completed PO to history.

Belinda, from Smith & Allen Consulting, Inc. shows a customer how to create and receive a Drop Ship PO for Microsoft Dynamics GP.
Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

Overview of Landed Costs in Microsoft Dynamics GP (with video)

  
  
  
  
  

This video gives an overview of Microsoft Dynamics GP Landed Costs and their setup.  This includes both the Inventory Control and Purchase Order Processing modules.

This video gives an overview of Microsoft Dynamics GP Landed Costs and their setup.  Video by Belinda from Smith & Allen Consulting, Inc.

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

How to track changes in Payroll in Microsoft Dynamics GP (with video)

  
  
  
  
  

Every time I teach a GPUG (Microsoft Dynamics GP User Group) Payroll training class I am asked about how changes to payroll records can be tracked.  In this video, I show you how!

 

Belinda, from Smith & Allen Consulting, Inc. in New York City shows how to use a free utility to track all payroll changes.

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070
Tags: ,

Balancing Payables to General Ledger Microsoft Dynamics GP

  
  
  
  
  

In this video I walk through the steps I use when I start a project balancing Payables to the General Ledger in Microsoft Dynamics GP.

 

 

Below is the view I created and use when I balance Payables to the General Ledger:

 

SELECT OP.vendorid AS Vendor_ID,
       OP.docdate  AS Document_Date,
       CASE OP.doctype
         WHEN 1 THEN 'Invoice'
         WHEN 2 THEN 'Finance Charge'
         WHEN 3 THEN 'Misc Charge'
         WHEN 4 THEN 'Return'
         WHEN 5 THEN 'Credit Memo'
         WHEN 6 THEN 'Payment'
         ELSE ''
       END         AS Document_Type,
       OP.vchrnmbr AS Voucher,
       OP.docnumbr AS Document_Number,
       OP.docamnt  AS Document_Amount,
       GL.actnumst AS GL_Account,
       CASE OD.disttype
         WHEN 1 THEN 'Cash'
         WHEN 2 THEN 'Payable'
         WHEN 3 THEN 'Discount Available'
         WHEN 4 THEN 'Discount Taken'
         WHEN 5 THEN 'Finance Charge'
         WHEN 6 THEN 'Purchase'
         WHEN 7 THEN 'Trade Disc.'
         WHEN 8 THEN 'Misc. Charge'
         WHEN 9 THEN 'Freight'
         WHEN 10 THEN 'Taxes'
         WHEN 11 THEN 'Writeoffs'
         WHEN 12 THEN 'Other'
         WHEN 13 THEN 'GST Disc'
         WHEN 14 THEN 'PPS Amount'
         ELSE ''
       END         AS Distribution_Type,
       OD.debitamt AS Debit_Amount,
       OD.crdtamnt AS Credit_Amount,
       OP.ptdusrid AS Posted_By
FROM   dbo.pm20000 AS OP
       INNER JOIN dbo.pm10100 AS OD
               ON OP.vchrnmbr = OD.vchrnmbr
       INNER JOIN dbo.gl00105 AS GL
               ON OD.dstindx = GL.actindx
WHERE  ( OP.voided = 0 )
UNION
SELECT HP.vendorid AS Vendor_ID,
       HP.docdate  AS Document_Date,
       CASE HP.doctype
         WHEN 1 THEN 'Invoice'
         WHEN 2 THEN 'Finance Charge'
         WHEN 3 THEN 'Misc Charge'
         WHEN 4 THEN 'Return'
         WHEN 5 THEN 'Credit Memo'
         WHEN 6 THEN 'Payment'
         ELSE ''
       END         AS Document_Type,
       HP.vchrnmbr AS Voucher,
       HP.docnumbr AS Document_Number,
       HP.docamnt  AS Document_Amount,
       GL.actnumst AS GL_Account,
       CASE HD.disttype
         WHEN 1 THEN 'Cash'
         WHEN 2 THEN 'Payable'
         WHEN 3 THEN 'Discount Available'
         WHEN 4 THEN 'Discount Taken'
         WHEN 5 THEN 'Finance Charge'
         WHEN 6 THEN 'Purchase'
         WHEN 7 THEN 'Trade Disc.'
         WHEN 8 THEN 'Misc. Charge'
         WHEN 9 THEN 'Freight'
         WHEN 10 THEN 'Taxes'
         WHEN 11 THEN 'Writeoffs'
         WHEN 12 THEN 'Other'
         WHEN 13 THEN 'GST Disc'
         WHEN 14 THEN 'PPS Amount'
         ELSE ''
       END         AS Distribution_Type,
       HD.debitamt AS Debit_Amount,
       HD.crdtamnt AS Credit_Amount,
       HP.ptdusrid AS Posted_By
FROM   dbo.pm20000 AS HP
       INNER JOIN dbo.pm10100 AS HD
               ON HP.vchrnmbr = HD.vchrnmbr
       INNER JOIN dbo.gl00105 AS GL
               ON HD.dstindx = GL.actindx
WHERE  ( HP.voided = 0 )
Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070

Transfer Inventory to Fixed Assets in Microsoft Dynamics GP

  
  
  
  
  

A Microsoft GP User sent me an email asking about how they can consume inventory items for use and how they can transfer inventory items to Fixed Assets.  For the second part, I found a fabulous blog posting from my friend and fellow Microsoft MVP, Mariano Gomez (the link is below).

This video is simply putting Mariano’s blog posting into action.  Thanks Mariano for this great answer to Jeanne’s question.

Mariano Gomez and Belinda Allen attending a Microsoft Dynamics GP technical conference.

See Mariano's Post here!

http://dynamicsgpblogster.blogspot.com/2010/03/moving-items-out-of-inventory-and-into.html

Belinda (the GP CSI) Allen
Belinda@saci.com
917-445-9070
All Posts