Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Billing Record Report - How to create columns for each Expense Type and/or revenue by Job Role?

Avatar

Level 1

New to Workfront, so this may be easier than I'm finding it to be! We're needing to create a report for importing into another location, and running into trouble. The Billing Record for each project will have a combination of different types of Expenses (Travel, Vendor Costs, etc) and we need to be able to break out those $ amounts into separate columns in this report. Additionally, we send revenue to different accounts depending on what job role did the work, so we need to break that out as well, sort of a "Only show revenue in Column A if <Photographer> Job Role logged the hours, and only show revenue in Column B if <Designer> Job Role logged the hours" but all in the same row for the project.

 

Is there a Text Mode way of doing this?

2 Replies

Avatar

Level 1

Hoping to bump this topic again. Any ideas from the community?