web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Integration Manager, Receivables Transaction with Specific Apply To

(0) ShareShare
ReportReport
Posted on by 10

Hello All,
I have been working on this for a while and wondering if anyone has any direct info that would help.  We have a particular customer who sends us a statement in which they take different discounts and rebates which will apply to different GL accounts as well as specific invoices.  I am trying to build out an Integration to import this and save the valuable time of our office staff as these statements could have hundreds of lines.  I am handling the data preparation in excel with VBA but I am a bit confused with respect to IM, especially as the field mapping names do not 100% coincide with the naming conventions inside GP.  I have found this thread and read through it several times, however after further examination have found that it seems to really only apply to cash receipts.  Because we have more than cash receipts being captured in this situation, I feel that the Receivables Transaction integration is closer to what we need but I am not sure how to set this up.  If anyone could give me an example of the mappings required to accomplish this I would be forever grateful.  I assume at a minimum we will need a header source and a distribution body source file.  Thanks

Categories:
I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 663

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 439 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 337 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans