Reconciling Job Cost Material Cost Code to General Ledger

Question

Good afternoon, 
 We are struggling to find a good report to reconcile the differences between Job Cost Code "Materials" and GL transactions posted to the materials account. There is a variance and we would like to get to what transactions were posted to the GL and not the JC module? Also is there a way to change what description is posted to the JC reports, i.e. it would be much easier if it referenced the same field as in the GL (PO, Vendor Name, Inv#, etc.). 
 Any help would be appreciated. 
 Thank you, 
 Doug

ksmcwhir · Answer

I recommend running the Job Cost Job Transaction Detail Report for Cost Type 'M'. This will list transactions for all Cost Codes with Cost Type 'M' including the Transaction Date. You can then compare that to your G/L Materials Account or the General Ledger Posting Recap on the Job Cost Reports menu. 
 There is not an option is Job Cost Options to customize the Description posted to the Job Cost reports. 
 If this answers your question, please mark as a verified answer.

Sage 100

Reconciling Job Cost Material Cost Code to General Ledger

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING