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) / Integration Manager PM...
Microsoft Dynamics GP (Archived)

Integration Manager PM Distributions

(0) ShareShare
ReportReport
Posted on by Community Member

I'm creating an integration with a SQL data source to populate a PM transaction.  Using a VB field script, I'm specifying a certain distribution account, and is working.  My problem is populating the second pay type distribution which will always be the checkbook account.

I've watched examples of creating a header source, and a detail source which makes sense to me, but my data source is only one line per transaction.  I'd like to somehow hardcode the second distribution account into every transaction.

Any ideas?

*This post is locked for comments

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Integration Manager PM Distributions

    Furthermore, you don't need the field script with the Select...Case statements in VBScript. There's a field mapping capability in IM which I highly encourage you to explore. It's easier to map a new value than to have to change the script each time.

    Also, as a courtesy to the folks who help you out, if their response proved to be the answer to your question, please mark it as such.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Integration Manager PM Distributions

    That did it.  Thank you for sharing your expertise.

  • Verified answer
    26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: Integration Manager PM Distributions

    Hello - Under destination mapping, What do you have for the distribution type? Can you try switching it to say constantant and pick "PURCH". 

    Make sure your rule is default-nonimported.

    Regards

  • Community Member Profile Picture
    Community Member on at
    RE: Integration Manager PM Distributions

    This sounds like it should work but doesn't.  

    I'll try to be a bit more clear:

    I am always specifying (1) distribution account based on another field of data in a VB script which looks like this:

    sShopID = Left(SourceFields("shopID"),8)

    Select Case sShopID

    Case "ACT-BXTR"

    sAcct = "5405023130000"

    Case "ACT-BKTR"

    sAcct = "5405023230000"

    Case "ACT-OPTM", "ACT-CASM"

    sAcct = "5405023040000"

    Case else

    sAcct = "None"

    end Select

    CurrentField.Value = sAcct

     The problem is, the balancing distribution line item, which will always be the default checkbook account is missing from the transaction so the line is imported with warnings.

  • Suggested answer
    26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: Integration Manager PM Distributions

    Hello GoBrien11

    Under the mapping for distributions |Options make sure your choice is default-nonimported for the rule as illustrated below

    default_5F00_non_5F00_imported.png

    The rule should read Default-nonimported.

    Hope this helps

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

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,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans