Report Generator is a powerful tool that allows customised, detailed reporting on areas that are not covered by the pre-designed reports that are already in the system. The reports can be quite detailed to extrapolate vital business statistics or they can be basic, like tallying the Stock on Hand of a particular product group, which can also be quite vital at times.
When considering how to create a report in Report Generator, it is ultimately made up of 3 parts:
- PRINT LIST – What content, or information to PRINT on the report.
- SORT LIST – How to SORT the information that is to be displayed.
- QUALIFY LIST – What information to INCLUDE or EXCLUDE from the report.
The information that is used to create the reports come from the many tables within the ACR database. Here is the list of tables users can obtain information from:
- Product
- Customer
- Supplier
- Stock Movement
- FOB (Overseas Ordering)
- Pricing Module
- Promo Module
- Specials
- Orders
- Backorders
- Despatch
- Asset Register
- Contracts
- Repair
- Transfer
- Bill of Materials
- Serial Recording
- Functions…
- Variables
Also, if the user has the security to do so, they also have access to:
- GL Accounts
- Pay Allocation
Using Report Generator to create a wide range of unique reports, with the ability to rely on a large range of data from over potentially 20 different tables, the reports that can be generated and the insights that can be gleaned from the information provided by those reports can help to improve management and increase efficiency along with your understanding of the inner workings of the business you already know and love.