# WIP Report - Variance vs WIP Lines. How calculated?

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

Best bet is to download the relevant (to your version) copy of the Job Costing Technical Reference Manual from EpicWeb… depending on how your parts are costed, your mileage may vary.

Cool. Thanks for the tip.

I care only about the labor for this project.

Thanks,

Joe

HI Ernie,

where can I locate this manual now?

Thanks

Sorry - ignore that!