We’re in the process of implementing Multi-Site, as a single company with multiple sites (plants). Accounting wants to use different Departments for the different sites, instead of different divisions.
Is this possible?
And by possible, I mean without jumping through hoops with either customizations or complex custom GL Controls.
FWIW -
Created new GL Accts to be used for the other site’s inventory
I added the “Plant” and “Plant Config” business entities to the “Inventory COS & WIP” GL Control Type
I Setup a GL Control code for each site, to specify the Inventory account it will use
In Site Maintenance, I added a “Inventory COS and WIP” GL Control Type (with the Control code for the site). Repeating for each site
In Site Configuration, I added an Inventory GL Control Type similar to the step above (but for the Plant Config business entity)
Testing with a Transfer order does not give the expected results. The same GL is used for Inventory, by all sites. I expected the receipts to Site B to go to the GL acct specified by the GL Control controls I configured.
We went through the same thing. Accounting was using the division for the Products. Multi-site organically uses the division for the site. Accounting had to re-structure all the accounts to use the department for the products and the division for the sites.
It was a hard sell for us, but we got it done. Our situation was a bit different from yours, though. However, Accounting still had to change.
I’m sure you could pull it off with posting rules, but you would be fighting the system.
How do you set things up to have each site use a specific Div?
Does that segment need to be setup special (like “Use Business Entity”, or be dynamic)? I hope not, because those options are grayed out (probably because GL Accts exist).
Is the following the basic setup?
Create the Segment values for the division segment.
Create the required GL Accts with the new divisons.
Create GL Controls of Type “Division” for each division. Set the GL Acct to one with the correct Div segment. For example: 1000-01-01, 1000-02-01, 1000-02-01, etc… (assuming middle segment is Div)
Add a GL Control of type Division in Site Maintenance, to each site, using the controls created in step 3.
Are GL controls required to be setup in the Site Configuration program too?
I have “Inv COS and WIP” GL control setup in the Company Configuration. Are these overridden by GL controls in the Site configurations? Or do GL Controls setup at in the Company Config always supersede similar GL controls setup at lover levels?
And in the other GL Controls (like “Inv COS and WIP”) do I leave the div segment blank in those?
Control Type: “Inv COS and WIP”
ID: ‘Default’
Name: “Default Inv, COS & WIP Accts”
Accounts (not all shown):
AP Clearing: 3324--01
AR Clearing: 1127--01
Inventory: 1151--01
Inventory Adj: 6303--01
etc…
For the Divison GL Control, you are correct that you only populate the Division segment.
For your other GL Controls, you will populate the full account and the division segment will be replaced with the appropriate division segment.
You will want to make sure you are using the “Standard” GL Posting rules since they include the division substitution. You will also want to test this through thoroughly. The Division segment does not get substituted on all transactions so need to understand where it does and where it doesn’t and make sure your accounting people are happy with it.
The Epicor Transaction Hierarchies are excellent tools for showing you which transactions will substitute the division and/or department segments.
Quick question, since the substitution happens during posting, what shows on the WIP Recon report of unposted items? The pre-substitution acct or the post-sub acct?
I ask because i’m doing tests by just doing a Qty Adjustment (in a site other than the main one), then running the WIP/Recon report to see if the Inventory acct used has the Div substituted. Which it is not.
I’ve verified the Standard posting rules are in use.
I’m certain that I don’t have the GL Controls set up properly.
The Company Config screen allows adding a “Inventory COS and WIP” GL Control. We setup a GL Control Code (named ‘Default’) for the “Inv COS & WIP” type, and set GL accts in there. That’s working as expected in our live company (which just has one site)
The documentation infers that I can add GL Controls in the Site Config screen. but when I try, there are no GL Control Types available. I can make the “Inv Cos & WIP” and “Division” GL Types available by adding “Plant Config” to as a Business entity in GL Control Type maintenance.
You need to assign the division GLC to the site in Site Maintenance, not Site Configuration.
Adding the Division will not really hurt anything. When Epicor goes to post, it first checks to see if the GL account with the division in place exists. If it does not, it defaults to what is setup in the GLC (say product group).
Note that by adding division to site, you are only effecting inventory, WIP, Revenue and COS transactions. It does not affect AR or AP.
Hello all, I’m new in EPICOR (10), I’m currently doing some tests for COS and WIP.
We have multi-site with multi-warehouse, finacial need to have the COS and WIP kind of:
(where the second segment is the site and the third segment is the warehouse)
1104-01-0001
1104-01-0002
1104-02-0001
1104-02-0001
Until now I can have the second segment substitution but not the third one, someone can help me on how I must configure the GLC to have the third segment substitution? has to be in the warehouse GLC?
Create a GLC Code for each Warehouse (like you did for each Site/Plant). But GLC Type will be “Department”, not “Division”. Set the GL acct with blanks for the first two segments (like you did for Div, but this time only the Dept segment is populated)
Then in the Warehouse Maintenance, add a GLC (type = “Department”), and select the GLC Code you created above. Repeat for each warehouse…
I’m sure I’ve made it sound simpler than it is (and probably missed some important step). I really struggled getting the Div segment to be site specific, when we went to Multi-Site.
Hopefully that gets you going in the right direction.
P.S. I can’t stress enough how much this should be done in a test company first. Even then, when you go to repeat it in the live company, you’ll probably miss a step and struggle. These are the types of things Epicor really needs to provide step-by-step instructions for.
One thing to keep in mind, is that the GL Control is applied at the time of transaction. So you have to make a test transaction AFTER the GLC is updated.
What exactly is your situation? Just Multi-Site? And you want the Div segment of the GL account to be substituted based on the Site?
Added the new Div Segments. Our original (single site) Div was -00-. We added 4 more: 11, 16, 17, and 18.
Created the GL accounts that will use the Div field. Originally, we only had 1151-00-01 for our inventory, So accts 1151-11-01, 1151-16-01, 1151-17-01, & 1151-18-01 were created.
Created 4 new GLC’s of type Division. With GLC Codes 11, 16, 17, & 18. Setting the Account like:
(that’s for Div 11)
In Site Maintenance, add the GLC to each Site:
If the GL account defrived by the GLC, doesn’t exist, the original GL Account will be used. For example, If we had a GL Acct 1153-00-01 for our Finished Goods Invnetory, but forgot to create 1153-11-01. Any transactaions that should use 1153-11-01 will fall back to use 1153-00-01 (because 1153-11-01 doesn’t exist)
i’m already linked in Site maintenance division wise but, i’m not added “Inventory COS and WIP” GL Control need to update this and also site configuration Inventory gl controls need to update or not .
Based on your info. I’m trying from this site _-010- Division also linked but after posting the invoice, we are getting the default what we selected in inventory cos wip .
After Posting AR Invoice GL hitting _-000- default site. not a correct division site.
Are you using Dynamic GL Accts? Because the 2nd screen shot shows that the GL Acct structure has many more fields than you entered:
Maybe the Division GLC doesn’t work right with those?
Also, the GLC is used when the PartTran happens (or earlier), not when it is posted.
For example, The GL Account used for a PO Receipt, comes from the PO Release. The Acct set at the time the PO is created. Adding or changing a GLC after the release is created, won’t change which Acct is used upon receipt. So that acct will be used when posted. The posting process does not re-calc GL accts based on GLC’s
