If we need to remove some subsidiaries in netsuite, we will have to delete and update transactions, entities, and general ledger (GL) accounts related to those subsidiaries. Deletion of these items can be done, but there may be customers who have connections with multiple subsidiaries. In such cases, updating these customers individually will be time-consuming. For example, if we edit and update each customer, it will take a considerable amount of time. How can we efficiently update these customers?

The subsidiaries that you need to delete must be replaced by others in the transactions? If so, it's not really possible to update the subsidiary. For me, the simplest would be to isolate the transactions and entities linked to these subsidiaries to be deleted. Then export the data with all the information in CSV format and reimport the transactions in creation mode (add) with the correct subsidiaries. Once everything matches up, you launch a mass delete on the transactions in question. Then for the entities, once the transactions have been deleted, you can check if you can modify the primary sub if it was one of the subsidiaries to be deleted. Otherwise, you create the same entities and merge your old entities with the new ones, which will only indicate the active subsidiaries.

I need to remove certain subsidiaries along with their related entities, transactions, and chart of accounts from NetSuite. The challenge is that some customers are associated with multiple subsidiaries, and these specific subsidiaries need to be removed from those customers as well. What would be the best approach to address this situation?

OK if you need just to delete related transactions and entities First delete the related transaction ( like payment…) and after the source transactions ( isolate them by saved search) . Best would be to use a mass delete or map reduce to delete transactions. Once you have removed this you need to isolate the entities using this subsidiary. If the subsidiary to be deleted is not main sub then you can make an update by csv or by script to delete only this subsidiary. On the other hand, if the subsidiary is the main sub then completely delete the entity. Then you isolate the accounts and you update by csv the subsidiaries on which it is defined or you use a script to delete only the subsidiary to delete I advise you to make a sandbox’s refresh then you can have the same data like your production account and so to test

for example I have the below scenario, so how can I update customer subsidiaries?

The main subsidiary don’t change ? If it does not change you can as I explained, either update by csv the customer or delete the subsidiaries by a mass update script but only after having deleted all the transactions concerning the customer on this subsidiary

The main subsidiary will not be changed.

ok so delete all transactions first. Then once you are sure that you have deleted absolutely everything on the subsidiaries I can help you with a mass update script that will save you time rather than doing update csv it will simply be enough to isolate the customers using a mass update and the script will take care of deleting only the subsidiaries specified in the script while keeping the others