GL configuration when you have multiple companies and multiple sites within these companies

in the early stages of EPICOR configuration. We have multiple companies and multiple sites within these companies but require site P&L, BS, along with corresponding AR, AP and their inventory. We also have quite a bit of interco trading activity. Account structure so far is core account, with site and then if applicable the department. Where do I incorporate the trading partner to allow for eliminations for consolidations? Have not discussed that portion yet but just want to ensure I incorporate any requirement when we are modifying our account numbers.

thanks

thanks

Usually we add an account segment for the company ID. This eases the approach for eliminations and consolidations.
Each GL account would have that segment included within each company.

So you would end up with 4 segments (Account, Division, Dept, company). Also, make company a mandatory segment

But I have sites with interco trade activity that from a site reporting, they need to know who that trading partner is, who might be in their same company or even one of the different companies.

Could I have that company segment be the trading partner – who the interco sales was with?

thanks

image003.png

if you do that, that would be a dynamic, or optional, segment in additional to the current company segment. You can set that as part of the intercompany gl control code on the customer, or supplier, who is the trading partner.

Okay that makes sense –

So for my initial set-up I can leave it at Account, Division, Dept

And the trading partner will be a dynamic segment that is adding when we do the control codes for interco to account for the trading partner?

Had experience with Oracle and the inventory site and the trading partner was in the GL account # set-up.

I can finalize my account numbers now then.

Thanks so much

image003.png

that is correct. I would, however, suggest adding the 4th segment for the local company id. That will help with the multi-company reporting in the future…especially if you are going to use the same COA for all companies.

Yes, for sure. Anyways need to understand what will be easier as we move along and grow as a company.

Thanks for all your help.

image003.png