web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Script help for Integr...
Microsoft Dynamics GP (Archived)

Script help for Integration Manager, concatenate fields for Reference field

(0) ShareShare
ReportReport
Posted on by ABrown 81

I am working on creating an IM and am trying to find my way through it, but have a couple of questions (posting separately). In the below sample code that is offered in the GP IM script library, how do I code for only the first character of one of the fields? For example, in Segment1 I only want the first character. Also, what if I want the first 5 of another segment? Would that be different than the first character? Is this sample they offer VB? It doesn’t appear to be VB I’m used to, but I am not a programmer and only have fundamental experience.

CurrentField = SourceFields("Accounts.Segment1") + SourceFields("Accounts.Segment2") + SourceFields("Accounts.Segment3")

Can someone please help me with modifying the sample for what I need? Thank you in advance!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mike Bufano Profile Picture
    Mike Bufano 1,484 on at

    Use the "Left" in your statement and at the end, indicate the number of characters.

    CurrentField = Left(SourceFields("Accounts.Segment1") ,1)

    You can use that same technique for the other fields.

  • ABrown Profile Picture
    ABrown 81 on at

    Thank you!!!  It worked.  What language or syntax is this?  I'd like to be able to find some resources.  Thanks again, I really appreciate it.

  • ABrown Profile Picture
    ABrown 81 on at

    Figured it out, VB Script, which is slightly different than VB.  Thank you again!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans