Subject: Request to Add New Subsidiary to COA Accounts Without Removing Existing Subsidiaries

Question

Hi friends ,

I need assistance with updating our Chart of Accounts (COA) in NetSuite OneWorld. The goal is to add a new subsidiary to certain accounts without removing the existing subsidiaries.

Example:

* Account: 1234
* Current subsidiaries: ABCD, XYZ
* New subsidiary to add: LMN
* Expected result after update: ABCD, XYZ, LMN

Currently, when I try to update via CSV, the existing subsidiaries get overwritten and only the new subsidiary remains.

Could you please advise on the best approach to safely append a new subsidiary to accounts without affecting existing subsidiaries?

Thank you for your help.

Angela Bayliss · Accepted Answer

https://community.oracle.com/netsuite/english/discussion/4511903/subject-request-to-add-new-subsidiary-to-coa-accounts-without-removing-existing-subsidiaries

To update the subsidiaries, you will have to list each subsidiary in your import so that you don't overwrite what is already there.  The system wouldn't let you overwrite the subsidiaries if the account has been used by those subsidiaries already.

So in your import file, under subsidiary, you will have to list ALL the subsidiaries you want to have access to that account.

Make sense?

Aly Magpantay-Oracle · Accepted Answer

Hi @User_S69WX, Angela is correct. You will have to list all the subsidiaries when trying to update via CSV import. In your case, the subsidiaries that should be included in the CSV file when importing should be ABCD, XYZ, and LMN. Hope this clarifies!