Reports

How to view and understand BI Reports

There are many BI (Business Information) reports in Rtis. Each menu section within Rtis has a report section, below are two examples

Contract Management this is used to view the order book, showing what is still outstanding on the customers purchase order NOT called off

Despatch & Invoicing Reports Gives useful information helps managers see at a high-level area`s that need further investigation within despatch and invoicing, a few examples are.

    • Why has this not been invoiced

    • Why are there no individual costs to view?

    • Why is this showing as 100% margin


    Should you require information about other BI reports please log a request with rtissupport@nationaltimbergroup.com

    Contract Management

    1.

    From the menu section select contract management

    2.

    Select reports folder and select Sales orders

    3.

    From the drop-down arrow by the select report section select sales order review

    4.

    Select the Load data tab

    5.

    The order number shown here is the contract number NOT call off number

    6.

    Call off Value and value not on call off

    shows a true value of sales processed and what is still to be processed

    7.

    The grand totals are detailed here

    Despatch and invoicing reports

    1.

    Select the Despatch and invoice menu

    2.

    Select Reports console

    3.

    From drop down arrow next to the select report box select Sales potential

    4.

    Select date range required

    5.

    Select the load data tab

    6.

    Select site, from the manufacturing site tab and select OK this reduces the view to the site selected

    7.

    This report style has many features.

    1. By double clicking into cells a new window opens giving details of the call off, the example here shows a despatched but not yet invoiced call off
    2. Maximise the view of a and this reveals more data to view such as.
    3. Total cost
    4. Profit
    5. Margin
    6. Costs broken down
    7. Cost adjustments

    No of doors/frames/GO`s

    Continued image

    8.

    Another feature is to be able to drag and drop tabs into the report, example here.

    • Taken the purchasing status from section a
    • And dropped in section b
    • This information can now be viewed in c