Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Integration Manager, Receivables Transaction with Specific Apply To

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:

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

Product updates

Dynamics 365 release plans