Cognos reporting - Cash Advance Approver/Issuer

[Lisboa]

Hello,

We need help creating cognos reports for cash advance, the problem is we can't seem to find who issued/approved the cash advance (or who sent back to the employee).

We need this kind of info to be able to control effectively which account payables employees are approving which reports, but in Cognos we are not finding the correct column for this info. We only have the default approver for each employee.

Thanks in advance!

[PoojaKumatkar]

Hi @Lisboa ,

I tried creating sample report and seems its feasible to get cash advance approver and issuer details. You can drag and drop below columns and validate the report details with your cash advance workflow like below:

If this answers your query then please mark solution as accepted.

[jlozano79]

Hello Pooja,

Is this a standard report available in COGNOS? Or is this a customized report? Our company would benefit from having a report same as this CAsh Adv approver/issuer to monitor these requests.

thank you,

Joanne

[PoojaKumatkar]

Hi @jlozano79 ,

This is a custom report i tried creating for this community post. 

There is a standard report also available but that doesn't include workflow information. Hence you need create custom report using columns shown in my previous response screenshot.