3ex.net Transaction Reporting enables you to perform reports based on the transactional information contained within the 3ex.net standard system. 3ex.net Transactional Reporting uses a series of Transaction Reporting Rules. Transaction Reporting Templates are then created against each Transaction Reporting Rule. This flexibility means that multiple reporting templates can be created from the same basic set of information specified against the Transaction Reporting Rule. The use of Transaction Reporting Templates means that the criteria for a report can very quickly be entered, thus saving time for the end user.
3ex.net Transaction Reporting rules essentially define the usages of categories, groups, workflows etc for which the Transaction Reporting templates are based on. As per the screen shot below, the rules are simply setup from a variety of drop down menus for the user to select the appropriate default usage they require. In this example; the Ad Hoc Reporting Rules are setup to cover the vast majority of transactional reporting requirements. These include:
In all of the selections the user is able to determine the sequence order in which the usages should be utilised by the Transaction Reporting Templates by using the highlighted icons to move a usage up or down.
The last step of the Transaction Rules step is to define how the 3ex.net system should generate the reporting information and then subsequently how the transactional data can be displayed. The user is able to define whether or not the reporting information is generated based on transaction header details, transaction line details or both as per our example below.
3ex.net allows the user to create multiple Transaction Reporting Templates to be created from the same basic set of information specified against the Transaction Reporting Rule. In the example below you can see that five Standard Report Templates exist for the Ad Hoc Reporting rule. On the 3ex.net standard system the following Reporting Templates are available:
The Transaction Reporting Templates are created easily using the Transaction Reporting Rules as the base. In the example below, the template is populated with the following:
Category options to include (The usages for these categories are defined within the Transaction Reporting Rules applied to this Reporting template) In the screen shot below the user can select the different channels orders were taken by to include in the data generation for the end report.
The flexibility of the reporting suite in 3ex.net allows the end user to create reporting rules and templates to those available on the standard system to meet their own specific reporting requirements. It is possible to attach specific rules and templates to menu options for ease of use if multiple reports are required to be run frequently by end users. The 3ex.net standard system Reporting module contains the standard reporting options that most companies would require on a daily basis, further details on the reporting options can be found in our reporting section in the resources library. Should the 3ex.net standard system rules and templates not cover your requirements then a Change Request can be raised to have a bespoke report created for you by our highly skilled team of 3ex.net consultants.
Once the user has selected their preferred template, it is a simple process to create and run 3ex.net reports. In the example below, we have simply selected the standard Ad-Hoc Reporting template and adjusted the criteria entered to cover a specified date range.
Each step of the wizard as the user progresses displays a summary for each of the consolidation steps. In the screen shot below; at the Product Consolidation step is displayed. These summary steps allow the end user to preview the data that is being generated before commencing with producing the reports.
At the final step of the wizard, the user is presented with a list of standard reporting layouts to choose from. The user simply populates the check boxes of those reports they wish to output.
Examples of the standard 3ex.net Reporting Layouts produced via this method follow:
Nett (Invoice-Credit) Consolidated Product Listing with drill down capability displaying Product, Description, No of Lines, Nett, Vat and Gross values.
Nett (Invoice-Credit) Consolidated Product Group Listing with drill down capability displaying Product Group (as specified within the transaction reporting rule), No of Lines, Nett, Vat and Gross values.
Nett (Invoice-Credit)Order listing report with drill down facility into the order references to view lines, displaying Reference, Stage, Date, Address, No. of Lines, Nett, Vat and Gross values.
Nett (Invoice-Credit) Consolidated Stage listing with drill down facility to view orders, displaying Stage, No. of orders, Nett, Vat and Gross values.
Nett (Invoice-Credit) Consolidated Address report with drill down facility to view orders, displaying Address, Name, No.of Orders, Nett, Vat and Gross values.
Nett (Invoice-Credit) Consolidated Category report with drill down facility to view orders, displaying Category (as specified within the Transaction Reporting Rules), No.of Orders, Nett, Vat and Gross values.
All standard 3ex.net reports, once viewed can be saved into different formats such as csv, pdf or in Excel as per the screen shot below for the user to refer to at a later date.