Welcome, Guest. Please Login.
05/09/25 at 16:51:58
News:
Home Help Search Login


Pages: 1
Send Topic Print
Work in Process Summary Report (Read 769 times)
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Work in Process Summary Report
03/11/04 at 13:44:28
 
Hi,
 
On the Work in Process Summary Report there is a column called “Net Wip”
 
Could anyone tell me what these amounts showing under this column stand for?
 
Thank You,
 
Kelloggs  
 ???
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Work in Process Summary Report
Reply #1 - 03/11/04 at 17:10:20
 
It is the net balance in WIP for each work order - total cost into the work order minus finished production and WIP Variance coming out.  For Closed Work Orders, it should be 0.
Back to top
 
 

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


Ain't life grand!?!

Posts: 728
Gender: female
Re: Work in Process Summary Report
Reply #2 - 03/15/04 at 15:15:11
 
...although many of my work orders do not close properly and the net amount in the work order does not zero out when closing work orders where inventory is at zero.
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Work in Process Summary Report
Reply #3 - 03/17/04 at 06:58:17
 
What method of inventory are you using?  Average or FIFO?  We use FIFO, and when the last entry is made to finished production for the work  order, it is very important to answer "Y" to the DBA prompt "Is this the final entry to finished goods?"  Because it is at this point that DBA no longer uses standard cost for valuing these items, but recalculates the value of these items to be the difference between Total Actual Cost in the work order and previous entries made at standard cost to date.  This ensures that WIP variance is minimal, $0 or sometimes a penny or two when the work order is closed .  Hope this helps.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Work in Process Summary Report
Reply #4 - 03/17/04 at 07:44:46
 
That is important regardless of whether you are on FIFO or Average cost if you want the inventory to carry the actual WO cost.  But even if you take all the finished goods out of the WO at standard cost, the WIP Variance posting should net the WIP to $0 when the WO is closed.
 
It is important, at least on the final receipt or in WO-J when closing the work order, to answer Y to the wuestion about rebuilding the summarized costs from the transaction detail to be sure the closing entry nets the WO to $0 WIP.
Back to top
 
 

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


Ain't life grand!?!

Posts: 728
Gender: female
Re: Work in Process Summary Report
Reply #5 - 03/17/04 at 10:52:39
 
1) We are on average cost method
2) We always answer yes to rebuild summarized costs
3) Only the Work orders with -0- in inventory are the ones that the amounts don't close properly.
4) We are not talking pennies here.  Each month I have a few thousand dollars to adjust because of this problem.
5) The WIP variance posting just does not happen when closing a work order that has no inventory to post against.
 
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
Pages: 1
Send Topic Print