Query Manager Finance users need to use CHARTFIELD1 to include the Resource field in queries

posted Jan 3, 2018, 9:25 AM by Peyri Herrera
For Query Manager Finance users

Following the Project Costing Maintenance on December 27, 2017, Query Manager Finance users will find the Resource ChartField in the CHARTFIELD1 field rather than the PROJECT_ID field.

Example: When creating a query using the LEDGER record (table), select the CHARTFIELD1 field to include the Resource (not PROJECT_ID).
Query Manager Ledger

On the Fields tab, Query Manager users will also notice the Resource is associated with the CHARTFIELD1 field.
Query Manager Fields Tab

You should not need to update any existing Private queries that previously used the PROJECT_ID field; they have all been updated to point to CHARTFIELD1.