Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Integration Manager Question

(0) ShareShare
ReportReport
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

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans