Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

VB Scripting for Integration Manager

(0) ShareShare
ReportReport
Posted on by 3,484

Hello:

I need to compose VB scripting for Integration Manager for GP 2015.

Specifically, I need to write a script that will pull all lines of detail into the Note field--not just one line of detail.

This is not the standard "CurrentField", "SourceField" scripting. I need scripting that will directly update the SY03900 table in SQL.

Any help would be much appreciated!

Thanks!

John

*This post is locked for comments

  • john.ellis Profile Picture
    john.ellis 3,484 on at
    RE: VB Scripting for Integration Manager

    Thank you!

    John

  • Verified answer
    Maria Carrero Profile Picture
    Maria Carrero 150 on at
    RE: VB Scripting for Integration Manager

    Hi Jonh,

    You can add information on the note field by Journal Entry, you cannot do it by detail line. If you want make an update or insert by tables, or execute a Stored Procedure, you can do adding the script After Document using the current Journal Entry and the Current note field.

    Mary

  • john.ellis Profile Picture
    john.ellis 3,484 on at
    RE: VB Scripting for Integration Manager

    Sure.

    Each detail record for a journal entry contains such data as account, amount, and Distribution Reference.  

    I'd like for all detail records for the journal entry to be imported into the "Note" field.  Right now, I can only get one line to import.

    Thanks!

    John

  • Vikas Gupta Profile Picture
    Vikas Gupta 2,622 on at
    RE: VB Scripting for Integration Manager

    Hi John,

    Can you please elaborate your requirement bit more?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,401 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans