Welcome, Guest. Please Login.
05/10/25 at 15:06:08
News:
Home Help Search Login


Pages: 1
Send Topic Print
Work in Process (Read 558 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Work in Process
05/02/05 at 05:33:19
 
Is there any good way to find out what is actually in Work in Process? The numbers in my GL WIP account just don't seem reasonable. Is the relationship between the actual and GL something that should also be checked on a monthly basis and adjusted?
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Work in Process
Reply #1 - 05/02/05 at 07:14:10
 
The columns in the JC-M report are based on the transaction detail you can look at in JC-C, D, E and Q if you want to look at the transactions contributing to the net WIP and see where they may be coming from.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Work in Process
Reply #2 - 05/02/05 at 08:31:54
 
That's not really what I'm looking for. Maybe because what I'm looking for doesn't exist. When material/labor is issued in WO-G, is it just the costs that are put in WIP, or are the quantities/items put somewhere?
 
What I'm looking for is a report that says "143 BF of 4/4 Oak is in WIP, and 3.4 hrs of Labor". Otherwise, how do you reconcile it?
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Work in Process
Reply #3 - 05/02/05 at 09:12:08
 
And JC-P will list materials in WIP by part number or Work order.  Are you  looking for a combination of the two reports, JC-C and JC-P? I don't think that exists, but you could probably create it in Access  or maybe Crystal.
We dod check the WIP in GL and the number on the WIP summary and balance them every month.  The numbers for labor and materials on the WIP summary are for items both still in wip and also in finished production.  Only the total on the right is the one you should compare to your WIP in the GL.  If you are trying to get labor and materials totals from the wip summary and have unclosed finished or partially finished work orders, you need to do some math.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Work in Process
Reply #4 - 05/02/05 at 11:04:35
 
That's exactly what I was looking for. I guess if it were a bear it would have bit me. embarrassed
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Work in Process
Reply #5 - 05/03/05 at 06:09:21
 
I may be in the minority of DBA/EVA users, but every month I analyze WIP by components of labor, material and loads, for which separate GL accounts are maintained.
 
I use JC-P to reconcile WIP material only.
 
I use JC-C for monthly labor hours/$ which I import into an Excel spreadsheet anaylzing each work order and apportion WIP labor costs by percentage complete. (i.e. if a work order was completed/closed during the month all labor costs must be removed from WIP-Labor or if 5/10 units were completed during the month, 50% of labor costs are removed)  I use a beginning balance, add the current month labor, and determine those labor costs that should remain in WIP-Labor.
 
The fixed and variable loads are calculated based on monthend labor hours (determined by monthend WIP-Labor dollars divided by labor rate)
 
WIP Material and labor variations are recorded into one GL account which we call Inventory Shrinkage (RM & FG variations also use this account)
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
Pages: 1
Send Topic Print