We are able to move job costs through a journal entry (1-3). However, we are only able to move the costs and not the actual labor hours as there is not a field in the job cost portion of the journal entry. This will have an affect on the labor reports and the overall average hourly rate on both jobs being affected. On one job, it will increase the average hourly rate while decreasing the average hourly rate on the other job. Oftentimes, these errors may not be discovered until several weekly payrolls have been processed. Rather than trying to make numerous adjustments using the payroll module, is there another solution in which to transfer job costs INCLUDING labor hours. Has Sage considered an adjustments program within the Project Management module and still provide an audit trail without having to go through the general ledger?
by: Jeff R. | over a year ago | Project Management
Comments
1st run report: 6-1-3-29 using the wrong job# where hours were recorded.
When you are creating the JE in 1-3, use an entry with a Direct expense acct such as Materials. (EX: 5001-Materials Debit $1.00
5001-Materials Credit $1.00 SAVE; "do you want to post job costs? YES
In the job cost grid enter:
the WRONG JOB# on the first line and the original cost code and cost type Labor enter a NEGATIVE amount from the 6-1-3-29 report and a note in the grid "incorrect job# entered on timecard (or whatever)
on the 2nd line of the grid, enter the CORRECT job# and enter the same info but use a POSITIVE amount. SAVE > RECALL> COSTS> Job Costs 6-3 click on the correct record# for the correct Job# DRILL DOWN then in the employee/Vendor tab at bottom: enter the employee# whose hours were adjusted, pay type, then total hours. SAVE
Verify corrections by running a 6-1-3-24 report checking the hours were removed from the wrong job and added to the correct job. Costs will be correct, and job#'s will be correct.
Works like a charm! Hope this info helps you!
Delivered in version# 23.2.