We have reports ready in our existing ERP tool – but they are not that perfect. Written by programmers, not by users – and the latter were not involved… The lists are incomplete, the reports cannot be accurately filtered, they are hard to load into Excel. We face this situation many times.
Frequent problems of lists or reports
If a certain data is available in the ERP system, but the available report does not contain it, then with the creation of custom-made reports it is possible that the necessary set of information which is used day by day, be available at your disposal with a press of a button.
This has 2 prerequisites:
- We know the authentication data to the core database
- We know or get know the structure of the database
Usually the first point is harder to obtain, the IT staff is sometimes not willing to give out this information. But in cases when the ERP system itself is custom-made or hosted locally by the company, it’s far from being impossible.
Plan to accelerate admin work?
Get in touch with us!
Custom-made report in Excel, sourced from an external system
With modern data connections, it is possible to download the necessary data directly into Excel from a system, be it on our own server or a remote server, without manual import of any kind.
When the points above are fulfilled, the next step is the creation of the report. In this step we identify the followings:
- What is the target area of the custom report: shop floor data, outstanding orders, outbound invoices, accounting?
- What filter, sorting should be applied on the report: by date, supplier, material number?
- What columns should be present in the report: it can be a basic set of columns with only the summary of the data or can be a detailed, verbose list containing as many data as possible.
As an outcome, we can use this custom report any time in our daily work: we supply the filter parameters into Excel (as of today, only the last week, custom time period, given material number of material group, anything), press the button and
Uses of the custom-made report or list
Many times the task does not end when the list is created – who likes to browse a long report day by day? Excel was designed to help such a work too.
As soon as the report arrives to Excel with a press of a button, even its automatic analysis can be created: which invoices, which materials, which suppliers shall we put extra care on? Which are the articles that are in shortage? Is there a late truck that risks the production flow? Is there an inbound material that was accidentally not put on stock? Is the scrap cost of certain products too high?
The possibilities are endless, more precisely determined by the task at hand.
We provide a free consultation, where we assess the task in advance and give an overview on whether it is feasible with the existing tools and, if so, how much resources it requires.