Reporting from invoice for month-end accruals

[jrmered]

Hello

We are on standard configuration for Expense, and in the process of launching Invoice.

The way that our Invoice set up will be working is that we go through all of the invoice coding and approval in Concur then, once that is all complete, we run an extract file which posts into our accounting system (SAP).

However, we also need to record in SAP at month-end ALL of the invoices that are currently in processing (ie. not yet approved). Does anyone know of a report that will extract (with account code, cost centre etc. detail) a report of invoices in processing so that we can book a month-end accrual in SAP. I haven't managed to find one so far, but can't believe that we are the only company wanting to do this.

Thanks.

[richcaldecott]

Hi @KevinD thanks for your quick help here. We're using Analysis, and I see from one of your responses on another thread in the Expense forums that Analysis access doesn't have the ability to edit reports. Is that still true, and applies to Invoice too?

If so, do you know of a workaround that won't involve paying someone at Concur to create a custom report for us?

Many thanks

Richard

[KevinD]

@richcaldecott Analysis doesn't allow for editing any of the Standard reports. However, you can create your own custom reports. If you haven't taken our free webinar on Cognos reporting, I would highly suggest it. If you are interested, reply here and I'll send you a link to see the upcoming class schedule.

[AndreaHoelscher]

I am running into a similar situation.  Accounting needs a report that contains invoices not yet paid (in process) at each month end.  However, the Request Accrual report does not give us the information we really need (GL Account, Cost Center, Status, and Business Unit, at a minimum).  How do I actually edit the report or create a new one to include these additional fields?  Can you please show the steps? Training for Cognos is rather lenghty and complicated and we need an immediate solution.  Thank you.

[KevinD]

@AndreaHoelscher to better assist you, I would need to know what you feel your level of Cognos report building is. Let's say on a scale of 1-10 with 1 being I've heard of Cognos to 10 being, I can create a report easily with minimal instruction. 

I'm asking because for me to type out how to build this report, would take me quite a while if you don't have much Cognos experience at all. 

[KevinD]

@AndreaHoelscher What you are asking for is possible. Here is a screenshot taken from your site showing the data items needed. Your site doesn't have a Cost Center field, so I took that to mean Department ID. The Custom 2 item is Business Unit and Custom 3 is Department ID. You would need to create a filter on the Paid Status data item and tell it to only include Not Paid. This should give you the blueprint to create what you need. I think I captured everything you mentioned.