SQL Update intercompany transaction

(0) Share

Report

Posted on by Nhi Nguyen

Hi folks,

I am trying to post some Sales GL stucked in Financial module and got the error 'Transaction contains intercompany distributions; mark as an IC transaction". I ran this script "select * from GL10000 where ICDISTS <> 0 or ICTRX <> 0 " and found those invoices in question. Now I need to update their ICDISTS from 1 to 0 but cannot find a script. Could you please advise?

1385.Capture.JPG

Thank you in advance.

Nhi

*This post is locked for comments

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report

RE: SQL Update intercompany transaction

Anyone has the script to update the database? I do not have Intercompany setup in GP.

I have the same issue and updating GL10000 with ICDISTS = 0 and ICTRX = 0 did not help.
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: SQL Update intercompany transaction

Hi,

I think this is answered as a separate post, but I would look at the Administration | Setup | System | Intercompany to make sure you have an intercompany relationship setup between the companies where you are trying to post an intercompany transaction. I think the SQL table is IC40100.

Kind regards,

Leslie
Nhi Nguyen on at

Like (0)

Report

RE: SQL Update intercompany transaction

Nvm, I found a script to update it. But I am still getting the error when I post the GL. It says "An intercompany relationship does not exist with the originating company." Please help.

Regards,