Display Transaction ID on Entry Form & Report

[cbernard]

We are trying to export line item level transactions with a unique ID listed for each entry - we do this using the Entry Key (we could use the Legacy Entry Key if needed.).   

As part of the review process, we want to display the Entry Key (or Legacy Key) on the Expense Entry Form but can't find a way to add this value to the form.   We noticed that when you open an item there is a unique ID displayed in the URL (like D7076BE996B2A......), but this does not match the IDs mentioned above.

So, a few questions:

1.  Is there a way to get the unique ID that shows up at the top of the screen to display on a Cognos BI report?    

2,  Is there a way to display the Entry or Legacy Item Key on the expense item form?

Other suggestions on how we can match a line item on an exported form to a field we can export as part of a report?

[KevinD]

@cbernard Cognos does have the Entry Key as an available data item, so the answer to this is a definite yes. :-). When you have started a new Report in Cognos, you can use the Search field by entering Entry Key. It will show you where the item can be found.

As for showing this on the Expense Report, from what I see this is not possible. 

[cbernard]

Thanks Kevin - that seems to be the problem - there are fields you can display on the Cognos reports, but nothing you can match/display on screen.   Also seems like the API does not have access to the Entry Key fields.   Looking like I may have to write a script to update a Custom field via the API as a possible solution.

Any way to set the value of a custom field to the Entry Key value?