Users with the setting Report production can generate reports over the current state. Go to Reports, select Current state under Category and click Filtering:
Below you can find a description of some of the current state reports.
Invoice
Invoices in process
This report provides an overview of all invoices being processed and indicates where in the organisation the various invoice items are currently located. You can restrict the report to display only invoices which are past due, or which have fewer than a specific number of days before they fall due.
Invoices in process CSV
This report shows the original data that provided the basis for the invoices due to be processed. The data are presented in a flat table and have to be imported into Excel for pivoting, filtering and sorting by the chosen criteria. You can sort, for example, by due date, time since last action, group by supplier, coding, etc.The report displays up to 5 coding dimensions.The following data are included: Invoice ID, Invoice line ID, Invoice no., Invoice line amount, Currency, Invoice line amount local currency, Local currency, Invoice date, Due date, Processor, Processor office, Invoice type, Supplier number, Supplier name, Invoice line description, Invoice type value, Invoice line last action, Invoice line last action date, Last action performed by processor, Last action performed by processor office, Period, Account value, Account name, + up to 5 dimensions with names and values.
Create a pivot table in MS Excel:If you want to create a pivot table in MS Excel, you first need to run the report and save it locally on the PC. You then import it into Excel by opening the file in Excel, or by selecting Import External Data on the Data menu in an Excel worksheet. Then highlight all the imported cells and select PivotTable and PivotChart Report... on the Data menu. Follow the instructions and create the pivot table in a new worksheet. You can now drag a field from the field box into the pivot table and it will be sorted and grouped while you work. You can download an Excel Pivot Template which automatically imports the downloaded report and displays a standard pivot like the one displayed in the Invoices for processing report.For more information about pivot tables in MS Excel, please visit http://www.microsoft.com/BusinessSolutions/excel_pivot_tables_collins.mspx.
Expense
Travel/expenses documents for processing
This report shows a list of travel and expense documents currently for processing. It shows type of expenses, employee, expense no., date of creation, total amount and the status of the document.
Administration
Active delegations
Shows a list of users who are currently set up with deputies, who the deputies are and when they were activated.
Authorised amounts
Lists all users and offices that are set up with authorised amounts. The list shows the authorised amount as well as the dimension and the dimension value it applies for.
Duplicate suppliers in the chart of accounts
Provides an overview of suppliers who have been recorded more than once in the chart of accounts which is imported from the accounting system. There will be two records for a supplier if suppliers have been recorded with the same organisation numbers or the same bank account numbers. This report should be run at regular intervals for review and follow-up as this will make for more efficient invoice processing and prevent failed supplier matching due to the existence of multiple suppliers with the same organisation or bank account numbers.
Filters on offices and users
Shows a list of all filters applied to offices and users.
Offices and users
This report provides an overview of all users and offices recorded in the system. It also shows the users' functions and registered e-mail addresses. Authorised amounts are shown for both offices and individuals. If authorised amounts associated with specific coding have been set up for an office or a user, or authorised amounts in a foreign currency have been set up, this will be indicated by an exclamation mark.
Offices and Users - HR Key
This table shows a list of all users, which office they are located in and their HR key.
Routing on action
Shows a list of the different types of routing of documents, the dimension, the dimension value range and which users are set up with this routing.
Routing to user
Shows a list of users that are set up with routing of documents, the type of routing, the dimension and the dimension value range.
User details
Alphabetic list of all users. Shows among other the HR key, username, email and the users identities in other sites in the portal.
User settings
Table showing which users that are set up with the different settings.
Comments