Job Exceptions widget

This widget displays job transactions with exceptions that occurred in the date range. The job, item, plan cost, actual cost, and the variance amount and percentage are shown.

Filter: Allows you to select the starting and ending transaction date range and Job orders transaction number range and after applying the filter displays the data in the selected ranges.

The widget can have the option to search with job number, item and sorting option based on the job number ascending or descending. When you place the cursor on the percentage, it displays the calculation formula for the percentage.

Calculation (The percentages are show in two colors >100 shown as ‘Red’, <100 ‘Green’):
  • Formula Used-(Actual Cost/Planned cost * 100)

Drillback: Job Orders form.