Businesses today face complicated financial reporting and consolidation requirements. With Abel, you receive over 500 standard reports and a comprehensive toolset for custom reporting. Abel has been engineered for real time, fast reporting so you can get the information you need quickly and easily.
- Enquiry Screens
- Configurable Reports
- Report Writer
- SQL Export
- Ad-Hoc Reporting
- Real Time Trading Data
- Budgets and Forecasts
Abel offers a rich toolkit of specialized reporting tools coupled with several handy reporting features throughout, so you can find the information you need quickly and easily.
We aim to meet many of your regular day to day reporting requirements with real time enquiry screens that give you the information you need at a glance and also allow you to drill down to the lowest level of data. With Abel, you can either run a report or use our enquiry screens to find out the state of your business, or to investigate the unexpected.
Enquiry screens span all of Abel’s functionality including :
- Financials and Account Reconciliation
- Debtors and Creditors
- Trade Profitability
- Inventory Levels, Reordering
- Manufacturing Scheduling and Loading
- MRP Requirements
We also offer standard dashboards capable of interfacing to the Microsoft Charts API. Your Abel installer can configure Abel’s dashboards to your requirements.
Businesses today face complicated financial reporting and consolidation requirements. With Abel, you receive over 500 standard reports covering all of Abel’s functionality that can be used ‘out of the box’ or configured to suit your needs.
Both standard reports and custom reports developed with the Abel Report Writer are fully integrated into Abel and their placement is fully configurable to suit your business processes. The Report Favorites feature enables you to save your favorite reports and also save the filters that you normally use to run them. This makes it quick and easy to find and run the reports you use most often. Report Favorites can be for one user, shared by a group of users or made public to all users.
Abel’s reports can be:
- Grouped under configurable menu items
- Attached to relevant screens
- Saved into your Abel Report Favorites and made available to selected users
- Have security settings applied
- Previewed before printing
- Output to printers or PDF documents or as delimited text files
- Output in xlsx format for Microsoft® Excel®
- Grouped for output as a multi tabbed Excel workbook
- Sent as an email attachment
- Scheduled to run at a later date or at a specified frequency
Abel was designed at the outset to be used internationally, so date formats and currency formats are flexible. e.g. A user in the United States and a user in the United Kingdom can run the same report and each user will get their preferred date format and specified currency.
You can use Abel’s built in report writer to define additional reports if required. You can use one of the many templates provided within Abel or you can ‘start from scratch’.
With Abel’s report writer you can:
- Create a ‘first cut’ using Abel’s automatic report builder
- Create calculated fields
- Create custom report filters
- Have full control over page formatting with multi-level totalling and sorting
- Change the format of groups, lines or fields depending on the value in a field to highlight data according to your KPIs
- Define a “benchmark line” that prints a line across the report at a value that you specify to highlight data that is above or below expectations
Underneath the report writer is a powerful engine that selects the data, calculates fields, sorts the data, computes totals, and then formats the report to your own design.
Abel’s Report Writer includes the Statistics Framework that enables you to analyze your data using statistics important to your business e.g. $ per kilometer, $ per kilogram, $ per barrel etc. You can:
- View meaningful trends by tracking and comparing key statistics over time ($ per unit of product or service consumed or delivered etc).
- Compare key statistics between different branches.
- Report statistical data from a single Abel database or from multiple Abel databases.
Abel includes specific capability for exporting data to MySQL™, Microsoft® SQL Server and Azure® SQL for use with external reporting and Business Intelligence (BI) tools.
We provide a data dictionary that allows you to choose what tables and fields you want to export. You can also name them to suit your requirements.
Abel’s SQL Export supports both incremental export and full export. The incremental export only extracts changes since the last export, is faster than the full export and can be run as often as you like, including during the business day.
With Abel’s SQL export you can:
- Choose which tables to export and name them to suit
- Choose which fields to export from each table in the data dictionary
- Export to MySQL™, Microsoft® SQL Server or Azure® SQL as the database type
- Configure the export to run stored procedures before or after a table load
- Run a full export or an incremental export
- Schedule the export for a particular time and frequency
Abel’s SQL export runs as a Scheduled Report which is included in your Abel Base Kit license.
Many of the standard Abel screens offer the ability to report, email or produce file output of their content. You can print a screen or capture the contents of table data from your screen direct to print, email or delimited file for use in Microsoft® Excel (not just the visible data, but the entire table). So when you need to capture transaction detail or list data, this is very easily done using our standard Abel screens.
Also, many of Abel’s screens offer drill down to the detail ‘under the covers’, right down to the transactions with their foreign and local currency values and General Ledger postings from each line of a document (such as a customer invoice) and other document details, such as who opened, posted and closed the document. Screens that are part of a workflow also offer links backward and forward between related documents in the workflow (e.g customer invoice, customer dispatch, customer order). This is configurable to match your workflow.
All major screens have a button for reporting and you can configure the reports that you want to quickly access when using the screen. The reports can include standard reports, or reports you have created using the report writer.
Real Time Trading Data
Real Time Trading Data
Abel can be configured to capture the Sales, Cost of Sales, Quantities and Purchases automatically every time a transaction is posted. Because Abel tracks the cost of sales along with other sale data, your Profitability Analysis is accurate and up to the minute. This approach makes sure your crucial reporting and enquiry screens are fast and real time.
Your Abel installer can configure how Abel captures the sale and purchase data to suit the requirements of your business. This can be set up to track sales and purchases by any or all of:
- Client (Customer or Supplier)
- Employee (Sales Account Manager or Purchasing Officer)
Similarly Sales Budgets can be set up for these same groupings to provide you with budget v actual comparisons that are meaningful to your business.
Budgets and Forecasts
Budgets and Forecasts
Abel’s budget and forecast functionality compliments the reporting area and enables you to compare actual results with budgets or forecasts in your reports. You can create multiple budgets and forecasts as required to capture projections for changing conditions. Budgeting screens within Abel are configurable to capture the budgets and forecasts required for your business:
- General Ledger Budgets
- Department Budgets
- Customer Budgets
- Employee Budgets
- Product / Inventory Budgets
- Project Budgets
What our customers say:
co-founder - Deep Creek Brewing Company
"“Working with Abel went as well as I could expect. We changed from three different software systems to one integrated system and it was working perfectly within a month.”"
Chief Executive Officer - Dairy Technology Services
"We couldn’t be happier with Abel,” he says. “Automating our processes has made us so much more efficient. We have fewer people working on manual tasks, we’ve cut costs and we now have the traceability and visibility we needed across our business. That’s making it easier for the whole organization to succeed."
Director - NZ Drinks
"For NZ Drinks, automation was a great decision, and Abel’s robustness and flexibility provides us with a great foundation for growth,” Kyle says. “If we wanted to quadruple our business tomorrow, we wouldn’t have to change anything."
General Manager - Disc Brakes Australia
"Once you configure Abel to suit your business processes, it just delivers. You get a system that can handle a very high level of complexity which would cost a lot more if you went anywhere else. I hate to think where we might have been today without Abel."
Director of Information Technology - Alsco
"Abel spent time getting to know how our business works and how to make us better. Our accountants are all amazingly surprised how much the new system has simplified their lives. We’ve already reduced the time for closing our monthly reports from nine or ten business days to four."
Latest Abel News
Construction Contracts Act Claims and Retentions with Abel ERP
June 8, 2021
Work done within the framework of the NZ Construction Contracts Act requires careful management of the Payment Claims and sub-contractor Retentions – often over a long time period depending on the contract conditions. Many businesses manage their payment claims and… Read more »... Read More >