Question regarding changing GL accts on Product Groups (v6.1)

Mike wrote:
> If I undertstand correctly, Sales Orders and Jobs only store the Product
> Group ID. So, when a transaction relating to these orders or jobs
> (STK-CUS, STK-MTL, etc.) the transactions looks at the order header or
> the job header to obtain the Product Group ID and then from there
> obtains the GL accounts for the costing transaction. Am I missing
> something here? Is there another table that holds the ORIGINAL GLs from
> the Product Group when the order or job was created? I don't think
> so...but maybe I'm wrong?
>
> Sign me...confused.

You are not wrong and not confused. I did a quick test (in 8.03) and you're
not missing anything. I created a part and assigned it a product code with WIP
acct number 1232. I picked the parts (STK-MTL) and 1232 was debited for the
standard cost of the materials. I changed the material WIP account to 1230 and
then did a Job Receipt to Inventory (MFG-STK). I looked at the postings and
the WIP account credited was 1230, so it does NOT remember the ORIGINAL GLs.
In the real world, my 1232 account will be under-relieved and my 1230 account
will be over relieved. Here's the Recap from the Inventory WIP Account
Reconciliation Report:

Account Debit Credit Description
---------- ----------- ------------ ------------------------
01-00-1200 0.00 1.45 Inventory
01-00-1230 0.00 1.45 WIP-2
01-00-1232 1.45 0.00 WIP-1
01-00-9999 1.45 0.00 Variance Account
Grand Total : 2.90 2.90

I'm sure that Epicor doesn't consider this a bug but it is certainly poor
design. Frankly, I wouldn't use Product Type to determine the WIP accounts. I
would create a new WIP code that holds all of the WIP accounts and the code
could be picked or defaulted from Part Class or Product Type but certainly
give users the choice. More importantly, I would capture the WIP account
numbers (not the code) when the order is released and save them in JOBHEAD and
use those accounts for the life of the Job. That would prevent the WIP
reconciliation issue that one will face when one changes the WIP accounts
numbers on Product Groups. For completeness sake, I would also consider
creating a WIP-WIP transaction that would move WIP values from one set of WIP
accounts to another.

Mark W.
I am currently in the process of changing WIP and COS GL accounts in
Product Group Maintenance. I called support yesterday regarding a bug
in Product Group maintenance (unrelated to this email) and I was told by
support to remember that any open Sales Orders or Jobs referencing these
changed Product Groups will post to the original GL. I'm trying to
understand this statement.

If I undertstand correctly, Sales Orders and Jobs only store the Product
Group ID. So, when a transaction relating to these orders or jobs
(STK-CUS, STK-MTL, etc.) the transactions looks at the order header or
the job header to obtain the Product Group ID and then from there
obtains the GL accounts for the costing transaction. Am I missing
something here? Is there another table that holds the ORIGINAL GLs from
the Product Group when the order or job was created? I don't think
so...but maybe I'm wrong?

Sign me...confused.

Mike Lowe
Connor Manufacturing






[Non-text portions of this message have been removed]