We are experiencing a suddenly new problem wherein materials previously issued to Work Orders are "disappearing".  Example - all the materials and associated costs are in a given Work Order and all are correct. Then, without warning, about half the materials suddenly show 0% issued and no cost for that particular item. The costs also leave the WIP reports. However, on JC-A Job Cost, the total material costs at the bottom of the report are still correct. In other words, the 'actual' cost column does not add up to the total shown at the bottom.
Checking the inventory files (such as IN-A), the "disappeared" materials do not show up in on-hand, but are also no longer in WIP. They are simply gone. The materials also do not show any additional or new movement when looking at transactions in IN-E.  
We are unable to reproduce this,  and it does not happen on every job, but it's happened 4 times in the last month. We don't know what's causing it, nor where the materials and $$ go.
HELP!!!

Have you guys looked at WO-O to see if the materials are in the temp file because of a record lock? Just a thought.
 
John

What version?  If you rebuild the WO, do they come back?  Are the issues listed in JC-E?

Lynn,
This is the same problem I am having. I posted a forum on 7/31/2006 WO-A OR DC-I NOT SHOWING ALL ISSUES
I guess I did not explain myself very clear.  Issues only start disappearing after I installed the IS Tech Updates.
Issues do show in JC-E and in inventory transactions. But does not show up in work orders. Does not happen to all work orders. Does not happen to all components.
Does not fix if I run BKREBWO in UT-A or if I answer yes in WO-A to Do you want the Estimated costs recalculated?  
I hope you can help. At each month end I need to issue a report by customer to management advising dollar value of material  in  WIP (work orders). I generate a report in Access using the data from WOBOM and WORKORD, but since all the issues aren't there. I have to go back and check material issues and inventory transactions for each work order ...which is causing a one hour job to take many, many hours.
 
Version we are using is DBA Classic, Version 2004.1 with IS Tech Support Update 05/08/2006
 
Thank you
Your help is greatly appreciated.
Doreen
 
 

If the JC-E shows the issues and rebuilding the work order fixes it, then I don't think it is indexing or file size, although archiving old work orders then and reindexing the files can't hurt and will speed up day to day processing and reporting.
 
The problem with sporadic errors like this is trying to find the common thread.  It doesn't "just happen" even though it may seem like it.  If the original issue did in fact post properly and the % issue and JC reporting was at one time correct, then the key is to identify what was subsequently done to these work orders that was not done to others.  Issue additional material?  Finished Production?  Scrap Reporting?  Lot or Serial Control?  Multiple Locations?  Bin COntrol?  SOMETHING is different.

We just discovered this same issue on only one of our work orders.  We did three different issues to the work order on different days. The first date we issued material is showing on the Material in WIP report. However the other issue dates are not showing on the report. A Work Order Pick List was ran on 1-2-07 and it showed all the material issued to the WO.
 When we ran the WO Pick List report yesterday afternoon, it is showing only the items issued from the first date, but IN-A has the correct on hand quantities and the issues show in Transactions.
There is nothing in WO-O and JC-E shows only the items issued on the first date, the second & third issues are not there, so JC-E is showing the same thing the Material in WIP Report is.  
 The only thing that we know that we have done to the system was the year end and begin 2007. Maybe there is a common link between the processes that can be looked at.  
 
Angelle Ostarly
Windward, Inc.  
EVO-ERP V2006.1 08/11/06
Build 07/21/06

Hi,
 
We are having the same problem now. We are on DBA 2004.1 ISTECH Update 10-31-06. I issue the material see it in the transactions but a while after it just disappears and the UOH does not change. Any fix was made to this error..
 
HELP please,.. I cant even think of checking other WO.. its going to mess all our inventory and WIP.
 
Diala

We have been experiencing this problem for some time now (my original post dates back to August), with no change. It seems to happen randomly, and we have not been able to find a connection to anything that we do. We can't make it happen either. 15 or 20 Work Orders will go through just fine, then one or two will hiccup. When we notice it happens, we just routinely rebuild work order costs under WO-K-H
We just installed all the updates, up to and including 2/14. Since we just did this over the weekend, I don't know if this problem is fixed or not now. I'll keep you posted.