Hi, we are currently a 1 company, 2 site set up. We acquired another company in another company and have set up a second company, a consolidations company, and an eliminations company. Our current GL set up is xxxx-xx-xx with Natural-division-department. We also have a 4th dynamic segment we use for projects. We know we need to change our account string. Anyone have any recommendations for what segments we should add and if they recommend any specific order.
@TMSHarding This is a complicated topic - which is why I assume no one has jumped right in on the topic
What you are asking has far reaching effects in the GL and all financial modules (and reporting) but can also directly affect intercompany trading and all the GL Controls set up for everything from Sales to Inventory. Not trying to teach anything here, just pointing out that it’s a big deal.
We are 28 companies - 5 operational, 7 consolidation, 5 eliminations and a handful of ‘closed’ companies. Our chart is similar to yours, except that we have a Company segment. Our chart is the same in every company so that makes things very easy in all the other areas, plus it’s easy on our accounting team not having to mentally switch between charts.
In the end I’d suggest you get an Epicor consultant familiar with the multi-company setup and functionality that you want and have them help you decide which way to go.
Hi Mike, thanks for the input. We have a consultant scheduled for 3/27, our goal was to be as far along as possible at that point in time. We want to keep it as streamlined as possible but also allow for future growth. Do you have 2 company segments in your GL, one for the Co you are entering the transactions and the 2nd for the other company? Such as 00 for Company A, 01 for company B - 00-natural-division-department-project-01
No, we don’t. We do have a set of Intercompany accounts that ‘equal’ the other companies. The way Epicor’s internal intercompany processing works is like a three-step process. I’m not an accountant but I keep going back to my T’s and keeping everything balanced. Each company has to have an inbound and outbound intercompany account if I’m not mistaken and that allows the transactions in each company to balance against an intercompany account - and then Epicor’s processing creates the ‘other side’ automatically. It’s hard to explain here succinctly, but there is a great Technical Reference for intercompany if you’ve not found it yet. It’s called Multi-Site Company Technical Reference (or something like that). It explains it all.