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'
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.)
Article ID: 2414963 - Last Review: Aug 5, 2011 - Revision: 1