JCMGT110 - Job Cost Actuals vs Budget Variance is not reporting actuals for creditor materials

Problem

Actual data was not being returned to the report for creditor materials

Solution

SQL skills are required

A working knowledge of SQL Management Studio is required to complete this task



Stored procedure for the report has been corrected.  Download the attachment and apply to the relevant database(s).