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.
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?
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.
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.