I am looking for a way to capture the cost of materials (as opposed to the cost of goods sold which includes labor) at the end of each month.  So far I have looked at the inventory reports and the shipments costing is in standard, the closed WO costing is good but doesn't separate finished goods from shipped items, and the month end summary for shipments appears to be average cost where it says actual, and it is a total for labor and materials.  In short, I can't find any numbers that agree!  Is any one else capturing this kind of information? Any suggestions? Thanks!

Thanks for your reply, Lynn.  Yes I am looking for the cost of materials for items shipped only and I would really like it if I could use standard cost in IN-N-B but unfortunately with some of our higher priced materials and inacurate (still!) bills the standard is often different from the actual. WE are largely a job shop and most of the time there is no way to get the standard cost completely in sync with the actual.  If I could find a report that extracts the actual labor from the total actual cost on shipped items I could at least have a number for materials and then I could make a journal entry every month to move materials to a different account.  I think I can do this with an export of the CGS account to excel but I was looking for an easier solution.

I have the 12/31/03 update installed (we haven't done the latest two because we are in the process of getting a new server and I decided to wait to load these updates in case I had to start from scratch with DBA)  but I don't have JC-R in the menu.  It looks like from the update list that this was done in the 12/1 update.  What do I need to do to have this report show up in the menu list?