Error message "Transaction contains intercompany distributions; mark as an IC transaction" when posting a financial batch in General Ledger using Microsoft Dynamics GP


Symptoms


When posting a batch in General Ledger, the error message below is listed on the General Posting Journal or Batch Edit List, but the customer does not have any intercompany relationships set up. 

Transaction contains intercompany distributions; mark as an IC transaction.



Cause


The transaction or distribution is marked as intercompany, but there are no intercompany relationships set up. 

Resolution


Follow these steps to resolve the issue:

1. Use the scripts below to help identify which transactions in the GL10000 Transaction Work table are incorrectly marked as intercompany. Open SQL Server Management Studio and copy these scripts into a query window. Execute against the company database.

Select ICDISTS, ICTRX, * from GL10000 where BACHNUMB = 'XXX'  
Note insert the batch number for the XXX placeholder

select * from GL10000 where ICDISTS <> 0 or ICTRX <> 0 

select * from GL10001 where INTERID <> DB_NAME()

2. Depending on the values you found using the scripts from the last step, update the fields as appropriate and test again:
  • If you find any transactions (ICTRX) or distributions (ICDISTS) marked with a value, you can update them to be '0' so they are not marked to be intercompany.
  • If you find any intercompany ID's (INTERID) incorrect, you can update them to be the correct database name. (To be valid, the database names listed need to match the INTERID column in the SY01500 Company Master table in the Dynamics database.)