Is anyone out here not multi-company and consolidating financials for multiple sites on the same version but different servers/instances? Right now we do a manual consolidation and want to do it automatically in Epicor at our HQ site
My thought process is going in the direction of creating the individual financials in each site instance and then maybe dumping them into an external table that we would then access by HQ and construct the financial statements there with the data?
What do you mean by “site instance”? In a multi-site setup you should have a single GL, and GLC’s just dictate the GL account to be used by site specific accounts (like Inventory, FG, etc…). And if you follow the multi-site basics (where the Div segment of the GL account is site dependent), then Financials would just be ignoring the Div segment.
For example, we have sites A, B, C & D. With Div segments 00, 11, 16, & 17 (respectively). Our Inventory GL acct is 1151-00-01. If inventory transactions happen in Site B, then the div segment substitutes 11 for the 00. In other words, acct 1151-11-01 is used for Site B, instead of the default 1151-00-01.
So in the financials, the sum of 1151-00-01, 1151-11-01, 1151-16-01, & 1151-17-01 is the inventory value for the whole company.
Hi Calvin, We did not setup properly using multi site functionality. We have 4 different servers with stand alone sites on them that need consolidation. We have the chart of account set up with the first segment the account and the second segment as the site, no other segments used at this time. Our New Finance person is looking to make changes to the chart of account and was curious how other users set theirs up and want to see examples. Her end goal is consolidate financials run in Epicor and I am thinking we are going to need an external table to collect the month end data to then roll into the forms