ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Trying to understand job costing
http://www.istechforum.com/YaBB.pl?num=1151596656

Message started by stl3370 on 06/29/06 at 07:57:36

Title: Trying to understand job costing
Post by stl3370 on 06/29/06 at 07:57:36

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