Ok situation…have a new Org unit thus new Segment to the GL Accounts…we need to switch a bunch of current open Sales Orders/Jobs/Parts/etc. to this new segment code (GL wise) so that they are pointing to the correct GL accounting. Is there an easy way to do this, or do we need to close all SO’s/Jobs/etc. and re-enter each using the new “point” to GL? I’m hoping for an easy correction to each otherwise ALOT of work to close/cancel all and re-enter them to reflect the new org unit/GL accounting. Forgot to mention that some of the SO’s/Jobs have tons of activity against them already. Thanks in advance.
The GL’s referenced by those items (SO. Jobs, Parts, etc…) all have multiple contexts, controlled from various things.
Is there an easy way to define this new Org Unit? Is it a new locations, product classification, etc…?
Adding a new segment value is pretty straightforward. Next comes creating the GL Accts that use that new segment value. Finally, creating GL controls to direct the posting engine to use those new accounts.
Everything that hits the GL is controlled by GL Control Codes. You should be able to alter the GL Control Codes causing everything from this point forward to post into the correct Segment value.
SO’s post to the GL when the AR Invoice is posted or when a Cash Receipt is posted.
Inventory(and material transactions for jobs) posts with Cost/Wip is Posted. I think Jobs/Labor detail is posted with Cos/Wip too.
So changing the Control code now should point everything to the new segment value - even inventory/labor transaction that have already happened but have not been posted via Cos/Wip - however everything that has already been posted to the GL will have to have a manual journal entry created to ‘move’ them to the correct segment value.
I’m pretty sure that is all correct - bets to do a little more research with the Epicor Technical References that can be found on EpicWeb under “Documentation”.
We have the GL accounts ready - I think just need to do new Part Class and Product Group - I believe the GL Controls are set too - I’m not handling that end of it…the new GL accounts are 000000-HD-00000, the old accounts were 000000-MD-00000, we need “transfer” the current SOs, Jobs, Parts sitting in MD that need to be switched to new HD accounts - how can it be done without re-creating everything? Thanks
Thanks I’ll let my boss know…I’ll do some testing too in our test environment as well…
I assume that the xxxxx-MD-xxxxx accounts will still be used for something, and that you’ll need to define what things happen for the new org, and what still goes to the old one.
If a part XYZ-123 was in xx-HD-xx, and is now exclusively part of xx-MD-xx, then the PartClass and ProdGrp GL controls will need to be created/modified, and then that part updated.
One thing that E10 doesn’t do is warn you that a GL Control (GLC) change can leave orphaned amounts in GL accts.
For example, if inventory for part XYZ-123 has a PartClass GLC, specifying that Inventory uses acct 1234-MD-5678, then any QOH of the part is what contributes to the balance in that account. Say there are 100 pc’s at $1.23 each. $123 of the GL Acct’s balance is from those 100 pc’s.
If you just change the GLC to use 1234-HD5678, then any future trans would use that new acct. the costs in the old GL acct would not get credited.
The best way is to:
- Do Qty Adj’s to get the QOH to zero. This will move all the cost from the Inv acct to a Variance acct (or whatever your reason code is tied to)
- Update the GLCs
- Do Qty Adj’s to get the QOH back to the original value (using the same reason code). This will move all the cost from the Variance acct (or whatever your reason code is tied to), to the new Inventory acct.