Sorting Expenses by Year

Wouldn’t it be nice if in P6 you could add coding to expenses? Expense can become a jumbled mess in the Expense view. Being able to sort through the mess can be difficult because grouping and sorting are limited. Many times I have wanted to separate my expenses by year to bring some sort of order to the mess. Finally, I came across a work around that would help me through this issue.

Here is my solution:
Create a UDF (User Defined Field) for Expenses called Fiscal Year.
1. Select Enterprise, User Defined Fields…

2. Select Project Expenses from the drop down arrow

a. Click “Add” on the right hand side
b. Title the UDF “Fiscal Year”
c. Choose “Text” as the Data Type
d. Close the window

3. From the Expense view add a column:

4. Add the appropriate fiscal year designation for each expense.
5. Finally, to sort, click the column header titled Fiscal Year to sort your expenses.