Hi Amorton,

It sounds like your totals may be out of balance.  You can verify the total by following the instructions here, starting with step 3:

https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=222924250018005

Thanks!

Hi Amorton,

It sounds like your totals may be out of balance.  You can verify the total by following the instructions here, starting with step 3:

https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=222924250018005

Thanks!

Hey Jesse.  So if I run the Close Month Validation report, it shows just like the Job Cost Report.  JTD Cost for the specific job, Cost Code 16-908 is not correct, off by that one invoice.  It says if a job record is out of balance, to go to Job Cost/Setup/Jobs.  But I don't have that option.  I got to Job Cost/Setup/Jobs and it brings up our screen where we enter new jobs.   Please advise.

The transaction total on the far right is the amount that all the other columns need to match - so you check that total against the category total, cost code total, and job total.

Whichever are wrong, you would log in as an admin, turn on Audit Setup Activity and then correct the total in the setup. 

So in your example, you would go to Setup, Jobs, enter your job, Click on Cost Totals, and update the JTD Cost.

This can be tricky, so you may want to reach out to Sage Support for assistance.

But when I go to Cost Totals, the JTD Cost is correct.  It includes the missing amount.  That's what's weird, the missing amount is only an issue on some Job Cost reports, not all.