An Intercompany record isn't created when a company is added in Company Maintenance (98.280.00)

  • Article

This article provides a solution to an issue where an Intercompany record isn't created when a company is added in Company Maintenance (98.280.00).

Applies to:   Microsoft Dynamics SL 2011, Microsoft Dynamics SL 2011 Service Pack 1, Microsoft Dynamics SL 2011 Service Pack 2
Original KB number:   3047613

Symptoms

When you add a company in Company Maintenance (98.280.00), an Intercompany record isn't created.

Cause

Enter a company in Company Maintenance (98.280.00) without a Company ID and then select Save.

When you receive System Message 6118, select No:

Do you want to abandon changes to this row

When you receive System Message 2, enter a Company ID and then select Save.

Data must be entered in this field

It deletes the database name for this company.

Resolution

Insert a record into the intercompany table in SQL Server Management Studio.

INSERT into INTERCOMPANY (FromAcct,FromCompany,FromSub,Module,Screen,ToAcct,ToCompany,ToSub,User1,User2,User3,User4) Values('','XXXX','','ZZ','','','YYYY','','','','0.0','0.0')

Note

Where XXXX = CpnyID for the FromCompany and YYYY = CpnyID for the ToCompany

You'll also have to update the Company.cpnycoa, Company.cpnysub fields, and Company.basecuryid.