In Precoro, you can quickly and effectively gather the necessary data for analyses using the custom reports functionality. Read this article to learn how to use custom reports to your maximum benefit.
Please note: Invoice type of Custom Report is available only for users with active Report and Invoice roles.
Invoice Custom Report allows you to generate any data set describing all Invoices you have access to in Precoro. After running, the Invoice Custom Report can be downloaded in XLSX format. Thus, you can gather, filter, process, analyze, and use any information about Invoices.
Generally, there are two ways you can build an Invoice Custom Report:
- By documents, using only General, Supplier, and/or Company data
- By items, using Items (and other) data.
You can filter the Invoice Custom Report by Items and Documents Custom Fields.
Please make sure you have activated Items Custom Fields for the Invoices to see them in the Reports filters.
Find detailed instructions on how to activate Items Custom Fields for documents here.
Let’s consider an example of an Invoice Custom Report by Documents. This reporting type is applicable when you need to generally analyze your invoices and cluster documents by specific features without diving into items.
Let’s say you want to create a payment calendar for your Accountant based on Invoices created in Precoro. To do this, you need a list of Invoices filtered by status (we need only approved and partly paid documents) with the following indicated parameters:
- Invoice Due Date — to understand when you should pay.
- To Pay — to know how much you should pay.
- Budget Name and Parent Budget — to be aware of the payment money source.
- Supplier — to see the payees.
Here is a guide on how to create such a report: