Skip to main content

Notifications

Announcements

No record found.

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

Integration with some reversing JEs

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello,

We currently have an integration of GL transactions using one source file, however it doesn't do reversing entries.  Would it be possible to modify this to handle a source file where some JEs are reversing, and some are not?  For example, could I add a "Reversing Date" column to the source file, and if that field is empty, then the JE is not reversing.  If it has a date, then that becomes the reversing date.  I'm thinking this might require a VB script in the Destination Mapping, which is a little beyond me.  Would appreciate any advice.

Thanks,

Joe

*This post is locked for comments

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: Integration with some reversing JEs

    Thanks Joe - can you mark it is the answer that worked for you.  It helps others that come and look to see which of the many responses you get to questions have answered the issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration with some reversing JEs

    Yes, Heather's suggestion worked great.

    Thanks!

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Integration with some reversing JEs

    Joe, did Heathers suggestion work for you?  Just interested as I dont have one to work out right now, just want it for future reference.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration with some reversing JEs

    Agree!  I've been using this type file for years.  Works like a charm!  :-)

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Integration with some reversing JEs

    Heather, that is a very good solution - I will see that I try that the next time we have to design a new integration to the GL with the potential for Reversing entries.

  • Verified answer
    Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: Integration with some reversing JEs

    Hi

    I do Standard and Reversing journals in the same file quite happily.

    In my file, I have a column for Std or Rev.  For Std Journals, I have a 1 and for Reversing a 2.  In the destination mapping I use translation field to map the 1 to standard and the 2 to reversing.

    Then I have two columns for date - one for journal date and one for reversing.  I just map the reversing date and it is only needed for reversing transactions.

    Hope that helps.

    Cheers

    Heather

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Integration with some reversing JEs

    Joe, did you get a chance to test this - if so, mark this as closed.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration with some reversing JEs

    Thanks.  Sounds like a good work around.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Integration with some reversing JEs

    You might make life simple by creating two separate integrations - still using the single file.

    Use the Reverse Date as the filter - excluded in one pass and included in a second pass.

    Then make the two separate integrations into a group and pow you have one button integration and don't need to do any coding.

    My thoughts anyway - let us know if 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

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans