We always struggle with what to provide to our auditors for backup for how the system arrived at the costs on our stock status reports for manufactured parts. We’re actual costing, Lot FIFO. What do others provide to their auditors for backup for actual costing?
Job Costing - Audits
A
Userlevel 2
We are Average Costing, which equals actual costing from a job standpoint. Therefore, we normally print out a full Production Detail Report for them to audit the cost against. They normally ask for supporting documentation; Invoices, Time Entries, other lower lever Production detail reports, etc...
Userlevel 1
We are Average Costing, which equals actual costing from a job standpoint. Therefore, we normally print out a full Production Detail Report for them to audit the cost against. They normally ask for supporting documentation; Invoices, Time Entries, other lower lever Production detail reports, etc...
Thank you sir!
I have been looking for a planned to actual report for job costing. Hoping this ties to the Inventory/WIP Reconciliation and GLJrnDtls table.
Looks like this report even does summaries.
Do you use a BAQ to limit the Summary to the jobs closed in the particular fiscal period?
Thanks,
Anthony
Userlevel 2
The production detail should match the WIP report on open jobs.
Not sure I follow your question...
Are you trying to run a Production Detail Report for all jobs closed within a period?
Userlevel 3
If you are looking for a summary of jobs which are completed or closed within a date range, you need a BAQ which uses the following tables:
JobAsmbl - this is where the costs live for manufacturing jobs
JobHead - this will provide you with your date range for either completed or closed jobs
PartCost - this will provide the standard cost of the manufactured item, for comparison to the JobAsmbl costs captured during the actual build.
This BAQ can then be used to run the Production Detail report for specific transactions which occurred on the job from Labor, Material, or ReWork to cause a variance between the Standard and Actual.
Hi! We are on FIFO too. Part FIFO Cost Tracker is what I usually show them. You willl need to click on inactive. Use FIFO DATE >= a date older than the end of year. & then use production detail from there.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.