Reports

Transaction reporting

Transaction Reporting

Our software's Transaction Reporting enables you to perform reports based on the transactional information contained within our standard system.  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.

Transaction Reporting Rules

Our system's 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:

  • Drop down selection of Workflow to be reported on
  • Drop down selection Workflow Group/Stage for transactions to be reported on
  • Drop down selection of standard Address Category Usage

Transaction Reporting

  • Drop down selection of Transaction Category
  • Drop down selection of Transaction Lines Category usage.

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.

Transaction Reporting

  • Drop down selection of Product Group Usage
  • Drop down selection of Transaction Line Product Group Usages

Transaction Reporting

  • Drop down selection of Address Related Data
  • Drop down selection of Transaction Related Data. (Again these selection offer the user the ability to sort their chosen options.)

Transaction Reporting

The last step of the Transaction Rules step is to define how the 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.

Transaction Reporting

Transaction Reporting Templates

Our software 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 standard system the following Reporting Templates are available:

  • Ad-Hoc stage Selection (allows the user to specify a particular work flow stage for which the transaction data is generated)
  • Credits (Transaction data generated from Credit stages)
  • Invoiced Sales (Transaction data generated from Invoice stages)
  • Invoiced Sales-Credits (Nett transaction data generated from Invoice less Credit stages)
  • Open Sales (Transaction data generated from Non Invoice stages on the Sales Order Workflow)

Transaction Reporting

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:

  • Currency (The standard system only displays in Pound Sterling as the base currency)
  • Option to override Work flow group (This allows the end user to over write the work flow stages that are defined within the Template Rules.)
  • Radio button options to search on Top Level or Bottom Level Transaction Lines
  • Start and Finish Transaction Dates (Predefined date ranges can be selected as per the screen shot below)
  • Start and Finish Created Dates (Predefined date ranges can be selected)

Transaction Reporting

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.

Transaction Reporting

  • Drop down selection of Hold Reason (The user has the option to include orders that have a specific hold reason against them for example, finding transactions that are held based on a postcode region.)
  • Transaction Reserved Status (The user can define whether or not to include fully/partially or unallocated orders at a transaction header level)
  • Transaction Line Reserved Status (The user can define whether or not to include fully/partially or unallocated orders at a transaction line level)
  • Category Consolidation; (The user can specific within the template to consolidate transaction data on Transaction or Address category and specify the particular category)
  • Product Group Consolidation; (The user can specify within the template to consolidate transaction data on groups attached directly to products or groups attached to transaction lines and specify the group)

Transaction Reporting

The flexibility of the reporting suite in 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 software consultants.

Running Ad-Hoc Reporting

Once the user has selected their preferred template, it is a simple process to create and run our software 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.

Transaction Reporting

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.

Transaction Reporting

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.

Transaction Reporting

Examples of the standard  Reporting Layouts produced via this method follow:

Transaction Lines By Product Report

Nett (Invoice-Credit) Consolidated Product Listing with drill down capability displaying Product, Description, No of Lines, Nett, Vat and Gross values.

Transaction Reporting

Transaction Lines by Product Group Report

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.

Transaction Reporting

Transaction Lines Report

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.

Transaction Reporting

Transactions Report

Nett (Invoice-Credit) Consolidated Stage listing with drill down facility to view orders, displaying Stage, No. of orders, Nett, Vat and Gross values.

Transaction Reporting

Transaction by Address Report

Nett (Invoice-Credit) Consolidated Address report with drill down facility to view orders, displaying Address, Name, No.of Orders, Nett, Vat and Gross values.

Transaction Reporting

Transaction By Category Report

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.

Transaction Reporting

All of our software standard 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.

Transaction Reporting