Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Integration Manager Question

Posted on by 1,440

I am creating a GL integration that pulls from a csv file.  The account number in the source file has an extra two zeros in the field.  Is there a way to drop them off or to say left(myfield, 7)?

 

Thanks!

Ryan

*This post is locked for comments

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Integration Manager Question

    [quote user="Ryan McBee"]

    I am creating a GL integration that pulls from a csv file.  The account number in the source file has an extra two zeros in the field.  Is there a way to drop them off or to say left(myfield, 7)?

     

    Thanks!

    Ryan

    [/quote]

    You can add the following script to your Account Number field:

    CurrentField.Value = Left(SourceFields("sourceQueryName.YourField"), 7)

  • Ryan D McBee Profile Picture
    Ryan D McBee 1,440 on at
    Re: Re: Integration Manager Question

    We are doing that now, but end users are complaining about the extra step:)

     

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: Integration Manager Question

    Ryan,

    Why don't you do use Left function in Excel-CSV file thats easy / your CSV file must be in proper format before importing.

     

    Thanks

    Sandip

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans