Inventory in QC causes numerous reporting problems; is there a fix to this or an alternate way to get receipt travelers to be created for EVERY receipt?
A few instances:
 
MR-F/MR-H MRP properly shows requirements UNTIL material is received into QC, at which point MRP ignores what's in QC and tells you to order it
 
IN-F with "Include Items in QC" doesn't work, yet at receipt the material value is posted into the inventory GL account
 
PO-J-B selecting a time in the past, if an item has no prior costing activity and has been released since the requested report date, no data prints
 
NOTE: - We have yet to find an accurate way to value inventory at a date in the past, thus we cann only reconcile our inventory on-hand values with the GL account real-time.
 
PI-A selecting a freeze date in the past; doesn't make ANY difference what date you put in; it freezes information real-time only
 
IN-J doesn't account for inventory in QC, but of course if your try and do an adjustment you need to subtract out what was in QC at the time of running IN-J or you'll adjust out that qty
 
And of course the most obvious ones where you have to release material to invoice irregardless that the material hasn't been QC'd yet

1. Actually what's occurring is a "Buy" requirement shows up matching the qty "UNRECEIVED" on an open PO with a partial receipt that has occurred. i.e. 2 POs are open, 1 for 100 with 97 parts received and still in QC, with 3 parts remaining to be received on that same PO; the second PO is open for 50 more parts and have yet to be received. MRP shows 3 parts required to be bought.
 
2. IN-F does NOT include items in QC that have never had average cost data built; i.e. 1st receipts of materials; the qty still shows as zero even though there is an actual qty in QC; I understand your recommendation not to try and value inventory this way, but the real problem looks to be in the fact that at material receipt actual dollars go into the inventory GL account, but the average cost of an item stays ZERO until QC release; we have at any one time $250K-$400K in incoming QC; our accountants don't like that my inventory valuation reports are off by $100K's easily especially at times we are releasing new products lines.
 
3. PO-J-B correctly shows UNLESS the item has been invoiced through AP-C; i.e. receive into QC on 6/30, release on 7/4, invoice on 7/5, PO-J-B no longer shows that part in QC when selecting 6/30 as the report date
 
4. ok; what's the "Freeze Date" field for then?
 
5. The problem here is that I can't use that option (IN-J) to run a cycle count
 
6. And lastly, I believe this is the missing/faulty logic; I have yet to have a supplier that doesn't invoice for material at the point of "shipment" (not at receipt/release into my warehouse); if I do in fact receive bad parts, I still have to input the invoice they send; I then do a negative receipt and they issue a credit. If I reject the parts at QC, I still have to "accept" them in PO-J-C so I can input the supplier's invoice. More typically our incoming QC gets backlogged yet our invoice payment to the supplier is coming due, or I'm holding material in QC pending documentation release.
 
Due to this and the above problems, we are looking at alternate methods to handle our incoming QC in DBA; the best solution we can come up with at this point is to receive into QC and immediately release ALL items after we print the traveler. We've tried using the BIN locations to control that but that;s another story. This then leaves us with not knowing what is in fact in QC but that is almost acceptable to fix the numerous accounting problems caused by this. I'm definitely open to other ideas if they are out there though.