Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager Pa...
Microsoft Dynamics GP (Archived)

Integration Manager Payroll Transaction Before Integration Script

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I would like to create a Before Integration Script that will change the State Code if the Pay Code is a specific code.

For example, if Pay Code = 1102, set State Code to NM

Does someone have an example or has done this before?

 

Thanks.

*This post is locked for comments

  • Jeff Rowles Profile Picture
    Jeff Rowles 500 on at
    RE: Integration Manager Payroll Transaction Before Integration Script

    Hi Tom,

    I have done a similar translation but not as a "before script"....I just changed the Rule on the state code field in Entries mapping to be "Use Script" then the script would need to be something like this:

    If SourceFields("PR-Detail.PayCode")=1102 then CurrentField="NM"

    ElseIf SourceFields("PR-Detail.PayCode")=1103 then CurrentField="TX"

    Else CurrentField="PR-Detail.StateCode"

    End if

    Note/key:

    • replace PR-Detail to be whatever the name of your detail source is.
    • replace PayCode to be the column name for the Pay Code field from your source.
    • replace StateCode to be the column name for the State Code field from your source.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager Payroll Transaction Before Integration Script

    Which integration tool you are using?

    Please drop me an email with details at tejas.patel@flovianit.com, so i can provide you best solution.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans