GPUG thread on time entry solutions

Great customer feed back on GPUG thread for time entry solutions:

http://www.gpug.com/communities/community-home/digestviewer/viewthread?GroupId=247&MID=13883&tab=digestviewer&CommunityKey=4754a624-39c5-4458-8105-02b65a7e929e

How can I setup an accrual and a once a year lump sum in Comprehensive Leave Manager on the same leave code?

How can I setup an accrual and a once a year lump sum in Comprehensive Leave Manager on the same leave code?

http://www.integrity-data.com/kb-can-setup-accrual-year-lump-sum-comprehensive-leave-manager-leave-code/

5 New Features of Dynamics GP 2015 from the ERP Blog

5 New Features of Dynamics GP 2015 from the ERP Blog

http://www.erpsoftwareblog.com/2015/03/5-new-features-dynamics-gp-2015/

From Christina Phillips: Updating Payroll Transactions for FUTA and SUTA

Check out the following on Updating Payroll Transactions for FUTA and SUTA from Christina Phillips:

http://dynamicsgpland.blogspot.com/2015/03/updating-payroll-transactions-for-futa.html

Negative Payroll Transactions 2013 and Integration Manager 12.0

In order to get Integration Manager to import Negative Pay Code Hourly Transactions in Dynamics GP 2013, a few changes must be made to the integration.

A script must be placed on the “Amount” field in Destination Mapping:

SourceField = SourceFields("PR Trx Temp.Units")

SetVariable "Units", CStr(SourceField * 100)

If SourceField  < 0 Then

            SetVariable "NegativeTRX", "TRUE"

            CurrentField.Value = 9999.99

Else

            CurrentField.Value = SourceField

End If

This script sets the value of the hours for the imported transaction to 9999.99 and saves the original value in a variable.

NOTE: “PR Trx Temp.Units” will need to be set to the Source Field name from your integration.

Next a script must be placed on the “After Document” event within the Integration Properties:

 

NegativeTrx = GetVariable("NegativeTrx")

Units = GetVariable("Units")

 

If NegativeTrx = "TRUE" then

            UpdateStatement = "UPDATE " + GPConnection.GPConnInterCompanyID + ".dbo.UPR10302 SET TRXHRUNT = '" + Units + "' WHERE TRXHRUNT = '999999' AND BACHNUMB = '" + SourceFields("BatchID") + "' "

            Set MyCon = CreateObject("ADODB.Connection")

            MyCon.ConnectionString = "database=" &     GPConnection.GPConnInterCompanyID

            GPConnection.Open(MyCon)

            Call MyCon.Execute(UpdateStatement)

            Call MyCon.Close

            Set MyCon = nothing

End If

 

ClearVariables

This script checks to see if the current record being imported was a negative hours transaction.  If so, it sets the hours back to the original negative amount from the amount previously stored in a variable.

Meet me at Convergence 2013 in New Orleans!

Wish you could determine the next big Dynamics feature?  Here is your chance! 

Integrity Data’s Product Manager, that's me by the way, is hosting a Partner/Customer Advisory Luncheon at Convergence for the sole purpose of hearing your ideas.  We want to hear what YOU want to see in the product and how YOU believe the product can be improved.  Do NOT miss this opportunity to have direct input and influence into the future of Dynamics software! Contact me (tfranz@integrity-data.com) for an official invite – space is limited - you won't regret it!

Convergence 2013

Just got the word ... heading to Convergence 2013 in New Orleans in March!  Looking forward to meeting up with our Partners and Customers and meeting new ones!  #CONV13