Explaining the mismatch between the widget and the persisted grid for profit per labor hour

Explaining the mismatch between the widget and the persisted grid for profit per labor hour

Anterra has built a new SM widget called 'Profit Per Labor Hour'. This widget allows users to see the profit they can make per labor hour in a specific month.


When the user clicks on the highlighted dot on the line graph (see above pic for reference), it will drill through to Work Order Profitability persisted grid.


We recognize there is a mismatch between the number on the widget and that on the grid. The mismatch is caused by some of the work orders being excluding from the persisted grid due to their accounting date keys being out of the filtered date range. Specifically, the work orders that have been closed at the end of May but their accounting dates are after May, 31st. Therefore, those work orders cannot be counted on the persisted grid. 

The below image is a query to demonstrate what the issue is.



 


    • Related Articles

    • Persisted Grids

      Persisted Grids   Steps to create and save a Persisted Grid: Select your Parameters Apply Filters and Sorting Adding and Removing Columns on a Persisted Grid Moving columns Grouping/Pivoting Columns Sorting Columns Exporting a grid to Excel Saving a ...
    • Anterra Pivot Grids

      Contents Overview of Anterra Pivot Grids Steps to create and save a Anterra PivotGrid 1. Select your Parameters 2. Apply Filters and Sorting 3. Adding and Removing Columns on a Anterra PivotGrid 4. Moving columns 5. Grouping / Pivoting Columns 6. ...
    • Entering Estimated Labor Hours in Sage 300 CRE

      Calculating  KPIs for Labor Having estimated hours in Sage will let Anterra calculate several key performance indicators including: Estimated vs Actual Labor Rate Remaining Estimate Hours  Entry for new jobs Manual entry or import – fill in the Units ...
    • Anterra Widget Dashboards

      Overview of Widgets – Build Your Own Dashboards Widgets allow you to build your own dashboards from a selection of pre-built and self-built widgets (built-in Widget Builder).  You can build as many dashboards as you like using any combination of ...
    • Anterra Version v25 Release Notes

      New Features AR Collections:  Finance / Construction / Service Management 7013:  Accounts Receivable Customer Collection Hub Anterra has released a major enhancement with an AR Customer Collection Hub. The customer hub allows collectors to update or ...