Dynamics GP: Adding Contacts and E-mail Addresses to a 1096 Form

Well, it’s that time of the year again.

1096 Modification requests should start any day from our clients. The IRS has decided to change their 1096 form adding requirements. The most common request from our clients is adding the Contact Name and E-mail Address to the 1096 form.

Contact name is relatively easy. If you’re already in the Print 1099 screen just click on the Address ID you have selected for the 1099.

  • This will open the Company Address Setup screen.
  • Scroll down to the Contact line and input the appropriate Name or Title in the available space.

Now that you are in the Company Address Setup screen scan to the right of the Address ID and you will see a small globe. This represents internet information.

  • Click on the globe
  • The internet information setup screen will appear.
  • The select information for: should default in as Company.
  • Confirm the Address ID you want to modify.
  • In the E-mail Address information area, select To: and input the e-mail address you want to assign.
    • This will trigger Exchange to try and Validate the email address, just click Cancel
  • Save the changes

You are now done with the Setup Changes. Test print your 1096 Form, your Contact name and E-mail address will print on the appropriate line.

This article was written by Dean Anderson, Senior Dynamics GP Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics provider.

 

Dynamics GP Year-End Close Webinar

Join Tridea for our annual Dynamics GP year-end close webinar! We will share best practices related to year-end processes for your Microsoft Dynamics GP system. We will cover the top three modules General Ledger, Accounts Payable and Accounts Receivable.

register here

Event Details: Wednesday: December 14, 2016 at 11:00 AM – 12:00 PM (PST)

Presenter: Kaydee Baker – Tridea Partners

This is one of our most popular webinar. Don’t miss it!

Microsoft Dynamics GP: Analytical Accounting and Integration Manager

One of the downfalls of Dynamics GP Analytical Accounting, is the ability to use existing Integrations through integration manager. There are many articles that contain information on how to update the integration so that AA does not interfere, however, until recently, I have not been able to accomplish this.

One difference is that the integration manager node needs to be the eConnect destination – not the standard destination. You will see that the fields are available for the Transaction Dimension, Transaction Dimension Code, and Dimension Code Amount. When mapping to these fields, however, errors are often encountered.

I was able to narrow down one of the causes of the error message I received. It had to do with the Journal Entry field being set to Use Default. eConnect requires a value to be supplied for the journal entry.

In order to resolve, there are two options. Note the next Journal entry number and populate the data within the source file of the integration, and change the Rule for the Journal Entry Number to Use the Source File. The other option is to add a couple scripts to the Integration. One script will be added to the Before Document event script within the Integration manager properties. The other is to set the field to retrieve that number.

Please find the scripts below – Now you can finally take advantage of uploading Journal Entries with Analytical Accounting Information!

Before Integration Script:

Const adCmdStoredProc = 4
Const adParamInput = 1
Const adParamOutput = 2
Const adParamInputOutput = 3
Const adInteger = 3
Const adVarchar = 200
Const adBoolean = 11
Const adChar = 129
Const adDate = 7
Const adNumeric = 131


Dim SqlStmt
Dim objConnection, objCommand, NextJournal


Set objConnection = CreateObject("ADODB.Connection")
Set objCommand = CreateObject("ADODB.Command")



objConnection.Open _
   "Provider= SQLOLEDB;Server=MGB001\GP11;Database=TWO; Trusted_Connection=yes;"



With objCommand
.ActiveConnection = objConnection
.CommandType = adCmdStoredProc
.CommandText = "glGetNextJEWrapper" 'our wrapper stored proc

.Parameters.Append .CreateParameter ("@IO_iOUTJournalEntry", adInteger, adParamOutput, 4)
.Parameters.Append .CreateParameter ("@O_iErrorState", adInteger, adParamOutput, 4)

.Execute
NextJournal = objCommand.Parameters("@IO_iOUTJournalEntry").Value
End With

SetVariable "gblJounal", NextJournal

Set objCommand = Nothing
Set objConnection = Nothing



Journal Entry field Script:
CurrentField.Value = GetVariable("gblJournal")

 

This article was written by Kaydee Baker, Practice Manager for Tridea Partners. Tridea is a leading Microsoft Dynamics provider.

 

 

 

 

Microsoft Dynamics GP 2016 Feature of the Day – OData Service

Enjoy your Microsoft Dynamics GP 2016 Feature of the Day!

OData Service

GP 2016

Are you a Tridea client interested in installing Microsoft Dynamics GP 2016?

Contact us first!  Tridea Partners 858.755.3700 or info@trideapartners.com

By Tridea Partners, Microsoft Dynamics Partner www.trideapartners.com

Read original post at: http://community.dynamics.com/gp/b/gpteamblog/default.aspx