We find ourselves in a position where the subaccount structure that we have is very unhandy to modify or extend. Yes it can be done but it’s cumbersome and will make reporting look very messy as subaccounts will overflow all standard text fields.
Acumatica has virtually 0 flexibility to change anything with an existing subaccount structure. How do companies that are growing, adding new regions, new business divisions etc do this? A 20MM business does not have the same reporting needs as a 50MM/100MM/300MM business.
You can’t plan the future perfectly and it feels like there’s no flexibility in Acumatica’s subaccount structure for this change and growth. Does any one have suggestions for how to handle this?
Specifically: There are two entire segments of our subaccount structure that I would like to eliminate, and insert another segment between two existing ones.
Coming from QB, we fundamentally misunderstood the term “subaccounts” to mean something similar to what QB means. I wish Acumatica didn’t use that term. “Segments” is the term Netsuite/Oracle etc use and it’s much clearer.
The only clean option that I’m aware of at the moment is a complete ERP re-implementation which is kind of the nuclear option. This is a big enough issue for the future that I’m considering it(how hard can it be to export and reimport all data in the same format I wonder….?) but there is a lot lost doing that. Notes, attachments, transaction history etc. Not to mention the cost, just for the sake of reporting.
I vaguely remember someone somewhere mentioning that if you could come up with a way to recalculate the subaccount mask for every transaction in the system you could possibly make subaccount changes, but I can’t find that post.