Integration Mgr - source document problem

(0) Share

Report

Posted on by Community Member

Hello,

I am working on an integration to import a GP intercompany JE. For mapping the Source Document field, I selected "Use Constant," with a constant value of "ICTRX." This worked fine in the Originating company, but in the Destination company the Source Document comes through as "GJ." I verified that the Source Document "ICTRX" exists in the Destination company. Would like to have both parts of the entry show "ICTRX." Would appreciate any advice.

Thanks!

Joe

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Jonathan Fear on at

Like (0)

Report

Hi Joe,

When integrating in a IC journal entry...the entry only goes into the originating company as work...then when it's posted that's when the entry gets posted to the other company

So, this is not import behavior this is posting behavior.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Jonathan. Can the posting behavior be modified so that the entry in the destination company has the same Source Document as the entry in the Originating Company? I would think that this would happen by default, but apparently not the case. But perhaps there's some setting somewhere that would make this happen?

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

Almost anything can be done with the right Dex customization. I am not aware of an existing customization like this. You would want to reach out to your partner and ask them if they could do this.

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (0)

Report

Go to Destination Company and open Audit Trail Code setup window(Tools-->Setup-->Posting-->Audit Trail Codes) ans change the source document number for the below marked line and click OK to accept the change then try again.

Hope this helps!!!

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hang on Soma,

Whoa! That will then be the default Source Document for ALL entries in the General Entry window. I don't think this is a good idea at all. The ICTRX prefix is used in the batch ID, which then becomes the Audit Trail Code for the GL transaction.

The intercompany module will use whatever you have set up as the default. If what you want to do is change the GL Transaction Source ID for these intercompany transactions, that cannot be done using Integration Manager. Remember, the intercompany entry is not created in the other company until the source company's GJ is posted. That's why integration manager can't handle it. There's no entry there to manage.

In order to accomplish the objective, some script will need to run on those transactions whose batch number starts ICTRX. The script could then change the Source Document on those unposted GL entries.

Kind regards,

Leslie

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

What if I just change the entry for the ICTRX prefix in the Audit Trail Codes Setup (see below)?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

FWIW - this seems to work.

Thanks to all who responded!

Was this reply helpful? Yes No