Welcome, Guest. Please Login.
05/15/25 at 23:02:37
News:
Home Help Search Login


Pages: 1
Send Topic Print
Closed work orders posting as negitive WIP (Read 577 times)
fash
Browser
*


I love YaBB 1G -
SP1!

Posts: 4
Closed work orders posting as negitive WIP
06/01/06 at 07:20:02
 
I am the new Controller for Innovative Components Inc. in Schaumburg Il. During my first close May 31, I have noticed that Inventory WIP is showing as a credit balance balance on the GL.  After exploring and downloading all of the WO, creating a pivot table I have determined that 3-4% of all of the workorders for 2006 ytd are closing with a negitive balance. These balances range from -.01 ( which I do not care about to -$1800.00 on some W/O which I am curious about). Does anyone have experience with this type of problem and/or reasons why this may be happening??
 
Thanks for your help.
 
Good to meet all of you.
Back to top
 
 
  IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Closed work orders posting as negitive WIP
Reply #1 - 06/01/06 at 12:32:49
 
When work orders close with a negative variation, that means that transfers to finished production out of work in process, exceeded the dollar value of work in process for that job.  
 
Are you responding "YES" to the question "Is this the final quantity for this work order" when the last entry to finished goods is made?  
 
By answering YES, EVO will true up the dollars to finished production to equal total dollar job costs on the last transfer to finished goods.
 
The $.01 entries are just rounding differences.
 
If you run EVO report JC-M, you can readily see the total job cost of a work order, the dollar value of transfers to finished goods to date, and the last column represents the difference, whether positive or negative.  If you see a negative in the last column, you may consider overriding EVO average cost calculation when entering transfers to finished production.  
 
Hope this helps, neighbor.
 
Bensenville, IL
Back to top
 
 

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


I love YaBB 1G -
SP1!

Posts: 4
Re: Closed work orders posting as negitive WIP
Reply #2 - 06/02/06 at 05:05:22
 
Is there a way of determining if yes was selected at the final stage? Ie: is there a way of looking at the end result of those transactions and determining if the proper processes where followed? I would like to determine if it a human/training error, and if so who is making the errors??
Back to top
 
 
  IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Closed work orders posting as negitive WIP
Reply #3 - 06/02/06 at 12:12:42
 
Not knowing if you are using Average or Standard costing methods -  
 
If you are using standard cost method for entering partial transfers to finished goods, the last transfer to finished goods entry should be coded as "N" (partials should be coded as "Y").  You can check this by going to WO-I, enter finished production, and click on the bottom button called LOOKUP.  Under the top column labeled "S" for standard, there should be a "N" for last entry in order for the system to true up to actual costs.
 
If you are using the Average Cost method, all transfers to finished production are coded as "N" so I do not know of any way of knowing for sure if the data input clerk selected "Y" for final transfer to finished goods.
 
However, you also can look up the part number in IN-E, and subtotal all transactions to finiished goods for that work order.  If this total is different from the total job costs, that indicates a problem with the last entry to finished goods.
Back to top
 
 

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