Microsoft Dynamics Corner

Record a vendor rebate in Dynamics-GP

I found this post on recording a vendor rebate or refund in Dynamics-GP

http://community.dynamics.com/product/gp/gptechnical/b/gplesliev/archive/2011/08/04/recording-a-rebate-from-a-vendor.aspx

Add drill down to your SRS Reports back to Dynamics-GP

Did you know that in GP2010 Microsoft added the ability to add drill down capabilities to your SRS reports?  This adds a seamless integration from SRS reports back to the Dynamics transaction.  To look at this capability go to your Metrics page and you will see an Edit button.  Click the metric or report and click the edit button.  The report builder will launch that will allow you to create the hyper links back to Dynamics from the report. 

For more information about this feature review the User Guides and Help Menus.

 

GP2010 R2 Additional SQL Reporting Services Metrics Feature

This feature will add additional out of the box dashboard pages in Business Portal and additional SQL Reporting Services metrics to display on these pages. The new metrics are also reusable in the Business Analyzer and Dynamics GP home page as well.  For more information about this feature visit this link click here.

SQL Server Versions

Anyone needing a reference to the SQL Server versions inlcuding hotfixes and the related tech document from Microsoft this is a great web site to keep up to date.  They are pretty good at keeping current.

http://sqlserverbuilds.blogspot.com/

KTL Solutions is a provider of .Net development services, Microsoft Dynamics implementation and training, business process review.  Dynamics-GP, Dynamics-CRM, and Dynamics-SL sales, service and support.

Dynamics-GP Long Integer Out of Range

A client recently called because they could not post a check batch because of the following error message "Long Integer Out of Range".  The user could print the checks but could not post the checks and the batch was stuck in batch recovery.  The client is currently using Dynamics-GP v10.

After doing a little research I found that the document date they entered for a credit and a voucher that was being paid by a check had a date in the future that was an invalid date.  The year entered was actually 3028.  If you are wondering how it got posted, they post using the GL date from the batch, so the document date is more or less irrelevant until the check posting.

What I did to solve it was update transactions in the PM10300, PM20100, PM20000, PM10200 tables where the DOCDATE was incorrect.

Configuring SQL Server 2008 on Hyper V

I found a good white paper regarding setting up SQL Server 2008 for Hyper V.  It provides some detail information that I think anyone that is considering virtualizing their SQL Server to take a look at this.  I am sure there is a ton of information out there but I found this information very good.

Download SQL2008inHyperV2008

2011 W-2 and Benefit Reporting for Dynamics-GP Payroll

WASHINGTON — The Internal Revenue Service today issued interim guidance to employers on informational reporting on each employee's annual Form W-2 of the cost of the health insurance coverage they sponsor for employees. The IRS is also requesting comments on this interim guidance. The IRS emphasized that this new reporting to employees is for their information only, to inform them of the cost of their health coverage, and does not cause excludable employer-provided health coverage to become taxable; employer-provided health coverage continues to be excludable from an employee's income, and is not taxable.

The Affordable Care Act provides that employers are required to report the cost of employer-provided health care coverage on the Form W-2. Notice 2010-69, issued last fall, made this requirement optional for all employers for the 2011 Forms W-2 (generally furnished to employees in January 2012). In today's guidance, the IRS provided further relief for smaller employers (those filing fewer than 250 W-2 forms) by making this requirement optional for them at least for 2012 (i.e., for 2012 Forms W-2 that generally would be furnished to employees in January 2013) and continuing this optional treatment for smaller employers until further guidance is issued.

Using a question-and-answer format, Notice 2011-28 also provides guidance for employers that are subject to this requirement for the 2012 Forms W-2 and those that choose to voluntarily comply with it for either 2011 or 2012. The notice includes information on how to report, what coverage to include and how to determine the cost of the coverage.

The 2011 Form W-2, prior IRS Notice 2010-69deferring the reporting requirement for 2011, and Notice 2011-28containing the new guidance are available on IRS.gov.

SQL Server 2008 Tip for Parsing Delimited Strings

I recently had a project where I needed to migrate data from a source system to Dynamics-GP.  For the most part it was fairly straight forward with the exception that this source system stored it's period data in a delimited string in a field.  I needed an easy way to get the data out so that I can store the period data in separate records and fields.  I came across a script that got me part of the way there and I turned it into a SQL Server 2008 function that I thought may help others.  Here it is, basically the function takes two parameters, the string and what the delimiter is. It then parses the string and returns it as a table for you to work with.

CREATE

 FUNCTION[dbo].fnParseString (@string NVARCHAR(4000),@separator NCHAR(1))

RETURNS

@parsedString TABLE (string NVARCHAR(80))

AS

 

BEGIN
DECLARE @position int 

 

SET @position = 1

 SET @string = @string + @separator

WHILE charindex(@separator,@string,@position) <> 0  

 

BEGIN 

 

INSERT into@parsedString

 

SELECT substring(@string, @position, charindex(@separator,@string,@position) - @position) 

 

SET @position = charindex(@separator,@string,@position) + 1

 

END

 

RETURN

END

/*Example of how to execute the function*/

select * fromdbo.fnParseString('17;0;0;0;0;0;0;0;0;0;0;0;0',';'

 

)

 

Updated Payroll Reports

Microsoft release some modified payroll reports that will break out the Employer FICA and Medicare taxes to easier reporting.  The following reports were modified:

1. Reprint check register

2. Manual check register

3. Direct deposit check register (used when you have direct deposit active)

4. Check Register (used when you do not have direct deposit)

 

You can download the modified reports here, they work for GP10 and GP2010

Download PRCKRegisters

Problem with Dynamics FICA 2011 Update

FICA Issue with Payroll

For those of you that recently applied the payroll tax update for 2011 you have noticed the new FICA 4.2% employee share change.  However due to a an issue with Dynamics GP the employer portion of FICA is also being calculated at 4.2% when posting the employer portion to the general ledger and printing on payroll reports.  This problem is expected to be corrected in the round two tax update to be released around 1/24/2011.  Microsoft said that this update will correct the payroll reports but it will not correct the general ledger postings.