6 months Free BI at year subscription TBlox-Ordering and Reporting.

BusinessIntelligence By Intramalls
 
 
Action: 6 months free BI to a year TBlox-Ordering and Reporting
minimum S package, and for Corporate Organizations minimum L package)

 

 

 

Info

InsFocus BI is a state-of-the-art business intelligence solution designed for high-performance, easy-to-use reporting and analysis. The application is now via TBlox available for any company
regardless industry and size. TBlox integrated the Business Intelligence application from InsFocus on the TBlox-SAAS platform™, enabling this tool to be operational within 24 hours.

TBlox connected InsFocus on its SAAS platform™, providing their clients with rich reporting and analysis capabilties. InsFocus BI has been integrated into TBlox data environment and operates as a hosted solution (SAAS).

InsFocus BI data warehouse model is easily adapatable to any ERP and procurement data structures and business processes. InsFocus BI provides ERP environment with the same level of deep analysis and reporting as insurance companies currently enjoy. With the system, companies can monitor their suppliers' performance, product inventories, stock movements, price variations, and other relevant KPIs.

Author, share, and use reports that draw on data across all enterprise sources for better business decisions via our TBlox-Connected BI solution. This Business Intelligence application can also be used in combination with other ERP-systems like Oracle™ and SAP™.

screenshot PO activiteit van de leverancier & maand

Visit Screenshots tab for example reports


Specifications

General

  • One-to-many reporting
  • Ideal for information delivery for wide distribution
  • Provide a point in time picture of performance to a budget or KPI
  • Monitor indicators
  • High level information with the capability to drilldown to understand details
  • Leverages different data sources
  • Flexible
  • Designed to get multiple perspectives from the same report
  • Large volume
  • Presentation quality formatting
  • Output to a number of different file types and users
  • Ease of use
  • Flexible
  • Optimized toolbar buttons
  • Defined set of reports
  • Create own reports

Improve your Spend Management

  • Deep analysis on spend per category, supplier,
  • period, department and more
  • Drill-down to user, project, cost center or group
  • Track price differences or view status of the order
  • Monitor indicators

Powerful reporting tool

  • Possibility to create different perspectives from
  • a single report
  • Suports different data sources
  • Suitable to process large files
  • Distribute your reports to different users on different locations

Easy to use

  • Only a few days training required
  • No setup costs, monthly subscription fee
  • Make use of standard reports or create your own reports
  • Make use of standard pre-defined templates from the library
  • Simple instructions to install BI application

Screenshots

Click the thumbnails to enlarge the image

screenshot PO activiteit van de leverancier & maand

More PO Reports

 screenshot OR activiteit door het project More Order Requests reports
screenshot Producten in voorraad More about Products in stock
screenshot Factuur overzicht van de leverancier More Invoice summary by supplier
screenshot Product catalogus More about Product catalogs
sscreenshot Leverancier overzicht More about Supplier overviews



Reports about Purchase Orders (PO)

Click the images to enlarge

screenshot PO activiteit van de leverancier & maand

1 - PO activity by supplier & month
PO activity overview by month, detailing top 12 suppliers, last 12 month.

screenshot PO 01 - PO activiteit van de leverancier

PO 01 - PO activity by supplier
Purchase order activity last 12 months for top 250 suppliers. Top 25 suppliers are shown, others are grouped. To see all suppliers, clear filter. Float with mouse over chart to display supplier name

screenshot PO 02 - PO activiteit per product

PO 02 - PO activity by product
Purchase order activity last 12 months for top 250 products. Top 25 products are shown, others are grouped. To see all products, clear filter. Float with mouse over chart to display product name.

screenshot PO 03 - PO activiteit per productgroep

PO 03 - PO activity by product group
Purchase order activity last 12 months by product groups. Float with mouse over chart to display product group name.

screenshot PO 04 - PO activiteit uitsplitsing per subgroep

PO 04 - PO activity breakdown by sub-group
Purchase order activity last 12 months, breakdown by product sub-groups in product group. Change product group in tabs to see sub-groups. Float with mouse over chart to display product sub-group name.

screenshot PO 05 - PO maandelijkse activiteit

PO 05 - PO monthly activity
Monthly purchase order activity, last 24 months. Values above one standard deviation are highlighted in table and charts.

screenshot PO 11 - Maandelijkse PO% ontvangen

PO 11 - Monthly PO % received
Ratio of PO amounts received to ordered for orders of the last 6 month.

screenshot PO 12 - PO% een top 10 leveranciers

PO 12 - PO % received top 10 suppliers
Ratio of PO amounts received to ordered for orders of the last 6 month, broken down by top

screenshot PO 13 - PO bedrag te ontvangen door de te verwachten levertijd

PO 13 - PO amount to receive by expected delivery
Distribution of PO amount ordered but not received by product group and expected delivery month. Shows both past and future months.

screenshot PO 21 - Levertijden top 100 leveranciers

pO 21 - Delivery times top 100 suppliers
Average days to delivery for top 100 suppliers, last 12 month. Suppliers sorted top-down by PO amount. Exceptional delivery delays are highlighted.

screenshot PO 22 - Aflevering vertragingen top 100 leveranciers

PO 22 - Delivery delays top 100 suppliers
Overdue PO lines ratio for worst 50 suppliers, showing overdue and on-time PO lines, overdue ratio and average days overdue, last 12 month.

screenshot PO 23 - Control lijst van achterstallige telersverenigingen

PO 23 - Control list of overdue POs
List of PO lines not received yet over 30 days (only POs from last 180 days), sorted by purchase date.

screenshot PO 24 - Control lijst van de PO's achterwege

PO 24 - Control list of undelivered POs
List of PO lines overdue, sorted by days overdue.

screenshot PO 31 - Lijst van de prijs afwijkingen in de PO's

PO 31 - List of price deviations in POs
Analyses unit prices of purchases made in last 12 months and returns those with normalized standard deviation > 0.5. Drill down to PO ID in order to see source of deviations.

screenshot PO 41 - Leveranciers rendementverhouding

PO 41 - Suppliers return ratio
Shows return ratio by supplier for top 1000 suppliers, goods purchased in last 12 months. Return ratio 1% and above is highlighted.

screenshot PO 42 - Producten rendementverhouding

PO 42 - Products return ratio
Shows products where goods were returned, purchased in the last 12 months. Return ratio 20% and above is highlighted.


Order Requests

screenshot OR activiteit door het project

OR activity by project
OR amount purchased by project, last 12 month. Switch to table view to see month-by-month.

screenshot OR 01 - of activiteit door gebruiker

OR 01 - OR activity by user
Number and amount of ORs by ordering user, last 12 month. Filtered to show top 20 users by OR amount.

screenshot OR 02 - of activiteit per maand

OR 02 - OR activity by month
Number and amount of ORs by ordering month, last 12 month.

screenshot OR 03 - of activiteit van de leverancier en gebruiker

OR 03 - OR activity by supplier & user
Number and amounts of ORs for 100 top suppliers and order above 100 euro, by ordering user, last 12 month. Sorted top-down by order amount, highlighting exceptional order amounts.

screenshot OR 04 - Top 10 projecten uitsplitsing per leverancier

OR 04 - Top 10 projects breakdown by supplier
Purchased OR amounts by supplier, for top 10 projects, showing top 80% per project.

screenshot OR 11 - Afwijzing verhouding door gebruiker

OR 11 - Rejection ratio by user
OR lines rejection ratio by user, showing users with more than 50 OR lines, last 12 month. Highlighted are rejection ratios above one normal standard deviation.

screenshot OR 12 - verworpen ratio trend

OR 12 - Rejected ratio trend
OR lines rejection ratio by month, showing trend and summmary, last 24 month.

screenshot OR 21 - Bevel tot aankoop malen met de goedkeuring van de gebruiker

OR 21 - Order to purchase times by approving user
Average days from OR submition to PO, by approving user, last 12 month, showing top 50 approving users. Highlighted are delays above half normal standard deviation.


Stock

screenshot Producten in voorraad

3 - Products in stock
Stock position - sorted top-down by product, showing type of packing. List filtered to show products making up 80% of stock value.

screenshot SK 01 - Producten in voorraad uitgebreid

SK 01 - Products in stock extended
Detailed list of products in stock, including locations, quantities, reordering, amounts and prices. Filtered to show top 1000 products by amount.

screenshot SK 02 - Stock waarde loop van de tijd door producten

SK 02 - Stock value over time by products
Stock position - sorted top-down by product, showing type of packing. Only products with a stock amount of more than 10 euros are shown.

screenshot SK 03 - Voorraad informatie in de tijd

SK 03 - Stock information over time
Stock monthly development, last 24 month. Shows stock amount position, stock age and number of products in stock.

screenshot SK 04 - Stock maand in het verbruik

SK 04 - Stock in consumption month
Stock position relative to average consumption - expressed in months consumption value of stock.

Insfocus Logo

SK 11 - Stock details for PO
Stock movement details for one product in a purchase order. Shows movements and positions in quantity and amount terms. Enter product code and Purchase Order ID in input pane.

Insfocus Logo

 

SK 12 - Stock movements last 7 days
Stock movement details for last 7 days, showing in & out quantities by product, supplier and project for each day.

 

Invoices

screenshot Factuur overzicht van de leverancier

4 - Invoice summary by supplier
Summary of invoices by supplier for the last 12 months. Filtered to show top 25 by amount.

screenshot INV 01 - Afgewezen facturen van de leverancier

INV 01 - Declined invoices by supplier
Invoices decline ratios by supplier, last 12 month.

screenshot INV 02 - Open facturen van de leverancier

INV 02 - Open invoices by supplier
PO lines # and amounts for POs delivered but not invoiced, by supplier. Shows POs from last 365 days, ignoring recent 30 days. Filtered to show top 80% in amounts.

Insfocus Logo

INV 03 - List of invoices by ledger number
List of invoices for specific GL numbers, last 12 month. Enter GL numbers, separated by commas, in step #6 of input pane.

screenshot INV 04 - Overhead ratio

INV 04 - Overhead ratio
Overhead ratio by supplier, last 12 month, showing invoices with overhead above Euro 1.0.

screenshot INV 11 - Lijst van de factuur prijs per eenheid verschillen

INV 11 - List of invoice unit price differences
List of invoices where the invoice unit price was different than the PO unit price stated, last 12 month. Filtered to show differences above +100 or below -100.

screenshot INV 12 - Lijst van factuurbedrag verschillen

INV 12 - List of invoice amount differences
List of invoices where the invoice amount was different than the PO amount stated, last 12 month. Filtered to show differences above +1000 or below -1000.

screenshot INV 21 - In het proces-facturen

INV 21 - In-process invoices
List of pending or "in-process" invoices with over 15 days from invoice date by user, last 12 month.

screenshot INV 22 - Lijst van de facturen geregistreerd in vertraging

INV 22 - List of invoices registered in delay
Lists invoices where invoice registration date is more than 30 days after invoice date, for invoices registered in the last 12 month, grouped by supplier.


Products

screenshot Product catalogus

5 - Product catalog
Shows the product catalog for specific suppliers. Please select supplier in input pane step #6.

screenshot PROD 01 - Product-kaart

PROD 01 - Product card
Shows product position and attributes. Enter product ID in input pane.

screenshot PROD 02 - Niet-bestelde producten van de leverancier

PROD 02 - Products not ordered by supplier
List by supplier of products in catalog where no PO has been made in the last 12 months. Products # is the number that were not ordered, and Product in stock # is the number that are still in stock. Drill-down into a supplier to see individual product entries.

screenshot PROD 03 - Toegevoegd producten

PROD 03 - Added products
List of products added to catalog in the last 30 days.

screenshot PROD 04 - PO naar de winkel prijs diff

PROD 04 - PO to catalog price diff
Shows products where absoluete relative PO price to catalog price (net) is more then 1%, last 60 days.

 

Suppliers

screenshot Leverancier overzicht

6 - Supplier overview
Report shows different metrics for selected suppliers. Use the 7. Define filter menu in the input pane to choose one or multiple suppliers. Only supplier with activity in the last year are shown.