Hey there,
Does anyone have a cheat sheet of the relationships among JobHead, JobOper, LaborDtl, TranGLC, etc?
I’m not needing the table joins, but how Epicor calculates the variance and WIP lines on the Work In Process Report and Inventory WIP Recon.
Here’s a sample from the recon for two jobs:
Account : 12200-0000-000-00 \ Inventory-Work in Process
Apply Date System Date Type Posted? Job/Call Num Part Number Debit Credit Reference
8/11/2017 8/11/2017 Labor Y 201477-3-1 XXX-000 3.45 0 Emp: 000 XXXX
8/11/2017 8/11/2017 Labor Y 201477-3-1 XXX-000 0.79 0 Emp: 000 XXXX
8/12/2017 8/12/2017 Labor Y 201477-3-1 XXX-000 1.38 0 Emp: 000 XXXX
8/12/2017 8/12/2017 Labor Y 201480-2-1 XXX-000 27.6 0 Emp: 000 XXXX
8/12/2017 8/12/2017 Labor Y 201480-2-1 XXX-000 1.78 0 Emp: 000 XXXX
8/17/2017 8/17/2017 Labor Y 201480-2-1 XXX-000 4.83 0 Emp: 000 XXXX
8/17/2017 8/17/2017 Labor Y 201480-2-1 XXX-000 0.4 0 Emp: 000 XXXX
8/28/2017 8/28/2017 MFG-CUS N 201477-3-1 XXX-000 0 4.83 Cust:06188 PS:2432
8/28/2017 8/28/2017 MFG-CUS N 201477-3-1 XXX-000 0 0.79 Cust:06188 PS:2432
10/28/2017 10/23/2017 MFG-VAR N 201480-2-1 XXX-000 0 32.43 Phantom Purge WIP to Variance
10/28/2017 10/23/2017 MFG-VAR N 201480-2-1 XXX-000 0 2.18 Phantom Purge WIP to Variance
How does Epicor decide between MFG-CUS vs. MFG-VAR, for example? Or a split between the two?
Job 201477-3-1 had a production quantity of 1, and completed 1. Job 201480-2-1 was production qty 0, completed 0, but a completed, closed job.
Others split 50/50 or in uneven amounts. Just trying to get a handle on it.
I’m looking specifically for the W.I.P. line on the Work In Process Report.
Thanks,
Joe