Evo with 5/8 update
 
We have had some discrepancies between our WIP GL account and the WIP summary report and I've been doing some digging to try and understand where they are coming from.
 
We do a lot of PO's where purchasing puts the work order on the PO line.  All of our parts also have the freight markup % entered in IN-B.  While the GL transactions are being done correctly when the part is received (I can see the debit to WIP for the cost of the part and freight %, and a credit to RNI and the freight clearing account), the job cost reports don't agree.  JC-A appears to be correct, but when I compare that line item to JC-F, the cost doesn't match.  Below is a sample from JC-F--the qty multiplied by unit cost doesn't match and the difference is the freight markup.  Additionally, if I rebuild the work order costs, then JC-A and JC-F now match, but it appears the absorbed freight costs have disappeared from the detail!
 
 
Date     Work Order S Vendor     Name                 PO#    T Part Number     Description       Qty Received  Unit Cost   Extension
-------- ---------- - ---------- -------------------- ------ - --------------- ----------------- ------------ ---------- -----------
02/28/06    111-  1 R LEYOPT     LEYBOLD OPTICS GmbH  300129 P 10014148        CONNECTION, WATER         2.00   302.3050     559.82
02/28/06    111-  1 R LEYOPT     LEYBOLD OPTICS GmbH  300129 P 10014148        CONNECTION, WATER         0.00    -3.0000      -6.00
 
                                                                                                                     --------------
                                                                                                        Grand Total:        553.82
 
Does anyone know if there is a report that includes the absorbed freight cost that I can tie to?
 
Thanks,
Sean
Leybold Optics