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.
@jrmered Which reporting offering are you using? Are you using Analytics or Analysis/Intelligence? If you log into SAP Concur, you should see an option at the top of the screen that says Reporting. What do you see when you mouse over that? This will help me help you.
@jrmered Okay, go in using the Analysis option, not the BI Manager option. From the Public Folders area you should see one folder named Analysis - Standard Reports. Click this to drill into that folder. You will see some sub-folders. Look for one named Invoice and click on it to drill into this folder. You will see a list of reports. There should be one named Request Accrual. This should show you all Payment Requests based on the date range you select that are outstanding, meaning haven't been fully approved yet.
Now, this next part is very important. Do not run the report from this location. You want to copy the report and paste it into your My Folders. To do this check the little checkbox next to the report name (see screenshot). Next, click the Copy icon (see second screenshot). Then, click the My Folders tab and use the paste icon (see third screenshot) to paste a copy of the report. Once pasted, you can run the report by using the little blue triangle (looks like a play button) under the Actions column. When you run the report you should see a couple of date fields to enter the From and To dates. To see all of October, leave the To field as is (it will show today's date) and change the From field to October 1st. This will show all Invoices not yet fully approved for the month.
That is really helpful, thank you.
However, one thing missing from that report is the expense categories (GL codes). To book an accrual at month-end, I need to know which GL code(s) to book it to. Is there a way to add that in?
Thanks again for your help so far.
@jrmered With Analysis only, you not be able to edit this report. Also, if Invoice acts like Concur Expense, GL codes won't be visible until the Invoice is fully approved.
I have the same question but I have the Intelligence Reporting package. Can I still not edit to include GL #s that were coded to these unsubmitted invoices to assist in building my monthly accrual entry?
@maryeriker I haven't tested this for Invoice, but if it works like Expense, GL codes for expense types won't be visible in Cognos until the Invoice is fully approved. I've posted your question internally, to see if it is different for Invoice or not. I'll let you know if I hear something different.
@Summeryshine SAP Concur doesn't post the month end accrual, but you can certainly schedule a report to run on the first day of every month to show the previous month's accrual. As part of the schedule, you can tell Cognos to email a copy to yourself.