Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager PM...
Microsoft Dynamics GP (Archived)

Integration Manager PM Transaction

(0) ShareShare
ReportReport
Posted on by joseytang 1,800

We are using GP 2013 R2 version.  We would like to use the existing PM Transaction Template in Integration Manage Tool to upload all the PM transaction data.

In the PM Transaction Template, they have 2 sources.  One is the "PM Header" and the other is "PM Distributions" .   In our Upload Excel format, we have prepared all the data that match with the fields names in PM Header.  Same as we did in "PM Distributions".  However, we clicked the "Preview our source file" in PM Distribution.  We couldn't see our source data there.  The one (PM header) seems to be fin.

Do you know how I can trouble-shooting?  I have checked "Mapping" button, it seems to be fine.

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Integration Manager PM Transaction

    Great !

  • joseytang Profile Picture
    joseytang 1,800 on at
    RE: Integration Manager PM Transaction

    I think I know what is going on there.  I should not separated 2 files.  I have put all the files into ONE SOURCE file, the preview displays all the fields now.  Problem is resolved.

    Thanks,

  • joseytang Profile Picture
    joseytang 1,800 on at
    RE: Integration Manager PM Transaction

    Hi Mahmoud,  

    Thanks for the Youtube video.  In fact, I followed the same thing as the video does.  All the fields have been included in PM header and PM distributions. However, when I licked the "Preview the file data" in PM distribution.  All the values such as Account, Dist Type, Debit, Credit are empty (but my source files have the values in these 4 fields).

    I have no idea why my values in my SOURCE file do not display in PM Distribution preview.

    Please advise

    Thanks,

    Josey

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Integration Manager PM Transaction

    Have you checked the options for the PM transaction integration ? For each field, you should set a rule to use the data from source.

    Check this video for a quick review of the steps to follow, Integration Manager PM Transaction

    Your feedback is highly appreciated,

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

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans