Integration with some reversing JEs

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Bill Campbell 12 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Integration with some reversing JEs

Thanks. Sounds like a good work around.

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

RE: Integration with some reversing JEs

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

Was this reply helpful? Yes No
Verified answer

Heather Roggeveen 9,146 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Integration with some reversing JEs

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

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Integration with some reversing JEs

Yes, Heather's suggestion worked great.

Thanks!

Was this reply helpful? Yes No
Heather Roggeveen 9,146 on at

Like (0)

Report

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.

Was this reply helpful? Yes No