ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> negative material cost on work orders
http://www.istechforum.com/YaBB.pl?num=1237306221

Message started by NESTOR on 03/17/09 at 09:10:21

Title: negative material cost on work orders
Post by NESTOR on 03/17/09 at 09:10:21

Some of our work orders are showing negative material cost. Some don't even have material issued to them. How do we fix this. I think we need to go behind the scenes, but where do we go to do this.

Thanks

Title: Re: negative material cost on work orders
Post by Dawn on 03/18/09 at 10:38:07

I would start by looking at how your inventory component parts on the BOM are classified. I have had production put an item I deemed as N- Non Inventory and classified as such in a BOM then they changed it to a P-Purchased Part. Or vice versa a P changed to an N but not taken of the BOM. The timing is important here because if they changed it half way thru production not at the beginning. If that is the case be sure to look at your COGS as well to make sure exactly where it is being expensed to. In order to fix I believe (its been awhile since I had to fix this issue) you need to correct the N or P issue, check the correct pricing, check the BOM (I can't remember if I did a rollup on this before the next step or not), and then run WO-K-H to Rebuild the work order costs. I also limited who has access to the IN-E after that. Haven't had a problem since. ;)

Title: Re: negative material cost on work orders
Post by Lynn_Pantic on 03/18/09 at 11:01:46

The net total cost of material should agree with the JC-E report total for the work order. If they do not, you can use WO-K-H to recalculate the work order total.

Title: Re: negative material cost on work orders
Post by NESTOR on 06/12/09 at 07:39:29

The cost in JC-E is showing negative cost. How do I fix that.

Title: Re: negative material cost on work orders
Post by cathyh on 06/12/09 at 08:24:34

What in the list of material issues on the JC-E report is making the total negative? Did someone back out of an issue by entering a negative issue in WO-G and use the incorrect work order number?

Title: Re: negative material cost on work orders
Post by NESTOR on 08/04/09 at 14:54:36

I'm not sure if that what happened but what can I do to fix this? The material is negative and on some of them there is not even any material showing it was issued to the job on the workorder.