Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Unable to add Billing Record 'Entered by' field in reports?

Avatar

Level 4

I'm setting up a report of 'Billing records' and am unable to find an 'Entered by' field. Does Workfront just not record which user entered a Billing Record? It's a field on every other object type that I'm aware, so was surprised to not see it in the list of available options.  If it's not something that's available, can we add this as a feature request for the product team?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

4 Replies

Avatar

Level 10

Hi,

 

I just checked the API-Explorer and you are right, the field is missing. The only user related field is lastUpdatedByID, which stores the user id after creating the billing record. Unfortunately this information will not be valid any more, as soon as another user edits the entry...

 

I would suggest creating a support case or an idea to ask for this field in one of the next API updates.

 

Regards

Lars

Avatar

Community Advisor

 

Hi @CR17506599,

 

Given the missing built in Entered By that @lgaertner confirmed, as a workaround (noting Billing Records now support custom forms), you could attach a custom form upon Billing Record creation with a custom calculated parameter called "Billing Record Entered By" to create your own "write once" proxy (e.g. using ID vs name):

 

IF(ISBLANK({DE:Billing Record Entered By}),{lastUpdatedBy}.{ID},{DE:Billing Record Entered By})

 

Regards,

Doug

 

Thanks Lars and Doug!

The custom field is a good idea! We already have a custom form attached to our billing records, so that might do the trick for now.

 

I did notice today that the name of the person who entered the billing record is recorded in the project's 'Updates' page, so the data exists, they just don't make it accessible via the API for some reason.  

Avatar

Level 9

If you see the information you want in the Updates feed, is there any chance it shows up in a Journal Entry report? I tried doing that in my instance, but I don't see my test billing record in the project Updates the way you described it. If it works that way for you, then you might not be able to get "Who created this billing record?" but you could get "Who created this Journal Entry, which logged the creation of the billing record?" as a proxy.