Our contracting companies submit invoices monthly, and the invoice dates reflect the actual calendar dates worked.
However, in Resource Management (RM) and Advanced Reporting, time data is aggregated by week. When I filter for January 1–January 31, the system returns data based on the week-ending date. As a result, December 29–31 are included in “January” because they fall within a week that ends in January. This happens regardless of how the report is filtered and appears to be intentional behavior in RM.
The challenge is that I need to reconcile invoices that reflect true January calendar days with RM hours that include days outside of January due to weekly aggregation.
Has anyone found a reliable way to handle this reconciliation?
