Commercial and in Confidence
The information contained in this document is confidential.  No part of this document may be reproduced, disclosed to any third party, or issued in any form or by any means without the express written permission of Intersoft Systems & Programming Ltd.

Contents
1 Document Controls
2 Table of Figures
3 Introduction
4 Un-Invoiced Shipment Report
4.1 Un Invoiced Shipment Report Fields
4.2 Un Invoiced Shipment Report Examples
5 Zero Priced Shipment Report
5.1 Zero Priced Shipment Report Fields
5.2 Zero Priced Shipment Report Examples
6 Re Price Shipments
6.1 Reprice Shipment Report Fields
6.2 Reprice Shipments Report Examples
7 Invoice Data Extract
7.1 Invoice Data Extract Report Fields
7.2 Invoice Data Extract File Example

Anchor
_Toc47101678 _Toc47101678

Table of Figures

Figure 1: Reporting - Un Invoiced Shipment Report
Figure 2: Un Invoiced Shipment Report Screen
Figure 3: Un Invoiced Shipment Report Parameters
Figure 4: Un Invoiced Shipment report - CSV report fields
Figure 5: Un Invoiced Shipment report - PDF report fields
Figure 6: Reporting - Zero Priced Shipment Report
Figure 7: Zero Priced Shipment Report screen
Figure 8: Zero Priced Shipment report parameters
Figure 9: Zero Priced Shipment report - CSV report fields
Figure 10: Zero Priced Shipment report - PDF report fields
Figure 11: Reporting - Repriced Shipment Report
Figure 12: Repriced Shipment Report screen
Figure 13: Reprice Shipment parameters
Figure 14: Reprice Shipment report - CSV report fields
Figure 15: Reprice Shipment report - PDF report fields
Figure 16: Invoice Data Extract fields

...

Anchor
_Toc47101679 _Toc47101679

Introduction

This user manual will guide System Administrator users through generating the below invoicing reports from Intelligent Shipper.
Un Invoiced Shipment Report: The report shows all the shipments that have not been already invoiced and Shipments that are not cancelled so that the customers can be invoiced for the shipments that have been created and not invoiced.
Zero Priced Shipment Report: This report will show shipments that are automatically priced and are 0 priced due to having no rate card.
Re Price Shipments: This is the process to reprice the shipments that had pricing errors and have not been invoiced, manually priced or cancelled.
Invoice Data Extract: The Invoice data extract file will include customer pricing for shipments that have been system closed out (export state 60) and not included in a previous billing extract.
These reports are accessible to System Administrator user roles and will use the rate cards set up in the customer rate card and agent rate card screens.

Anchor
_Toc47101680 _Toc47101680

Un-Invoiced Shipment Report

This report contains Shipments that have been closed out but have not yet been invoiced, are not cancelled and not included in a current invoice run.
To generate the Un-Invoiced Shipment report:

1. Select Reporting> Un Invoiced Shipment Report on Intelligent Shipper

1. Un Invoiced Shipment report screen is displayed.

The fields displayed on screen are:

1. Select a date from the Upto date field
2. Generate the report for all customers by leaving the customer field blank, or a select a specific customer. To select a customer either enter the Customer name and click search to find the specific Customer or leave the field blank and click search to select from the list of customers displayed.
3. If a customer has not been selected (and so the report is being generated for all customers) then select a Rate Card from the list.

If a customer account has been selected the Rate Card field will be disabled.

1. Leave the check box unchecked if the report needs to include all the Un-Invoiced shipments.
2. Select Check box if the report needs to Include only Zero Priced/held shipments.

Note: Where the Check box is selected the report will include the following shipments only:

• Shipment that do not have Tariff, i.e. shipments that that have not been correctly priced against a tariff or been manually priced at 0.
• Shipments placed on the invoice hold

Where the only Zero Priced/held shipments check box is unchecked then the report will include all the Un Invoiced shipments.

1. Select the report format.

Note: When a customer account is selected in the Customer field then the Report Format field will display PDF and CSV options. When a customer account is not selected in the Customer field then the Report Format field will only display CSV.

Anchor
_Toc47101681 _Toc47101681

Un Invoiced Shipment Report Fields

See the table below for the Un Invoiced Shipment Report fields and the data to be populated in the report fields.
Un-Invoiced Shipment report – CSV report fields:

Un-Invoiced Shipment report – PDF report fields:

Anchor
_Toc47101682 _Toc47101682

Un Invoiced Shipment Report Examples

Anchor
_Toc47101683 _Toc47101683

Zero Priced Shipment Report

This report displays shipments that are priced ad zero due to a pricing error, for an example the shipment not being assigned to a rate card.
The report will contain shipments that:

• Have Not been invoiced
• Have not been manually priced at 0.00
• Have not been priced correctly against a zero priced tariff

To generate Zero Priced Shipment report:

1. Select Reporting> Zero Priced Shipment Report

1. Select Zero Priced Shipment Report option

1. Select a date from the Up to date field

1. Select all customers or specific customer by either entering the Customer name and click search to find the specific Customer or leave the field blank and click search to select from the list of customers displayed.
2. Select a Rate Card from the list where all customers have been selected in the customers field above.

Note: By Default, and when a single customer account is selected, the Rate Card field is disabled.

1. Select Report format.

Note: Where the report is for a single customer account and a single customer is selected in the customer field then the Report format field will display a PDF & CSV format for the report to be generated. Where the report is for all customers then the Report Format field will display only CSV format for the report to be generated.

Anchor
_Toc47101684 _Toc47101684

Zero Priced Shipment Report Fields

Zero Priced Shipment Report Fields – CSV report:

Anchor
_Toc47101685 _Toc47101685

Zero Priced Shipment Report Examples

Anchor
_Toc47101686 _Toc47101686

Re Price Shipments

The Zero priced shipment report generated in section 5 contains shipments with pricing errors. A System Admin user will need to update the customer and/or agent rate cards to correct the pricing errors displayed in the zero priced shipments report. Once these errors are corrected, the Reprice Shipments process will reprice all the shipments that have been closed out, not invoiced, not manually priced and are not cancelled, and will update the pricing of these shipments.
To Reprice a shipment: On Intelligent Shipper, Select Reporting> Reprice Shipment Report.

1. Reporting page is displayed with Report options.

1. Select Reprice Shipments Report option
2. The Reprice Shipments Report page is displayed

1. Select Reprice From & Reprice to dates.
2. When the Reprice, button is selected then all shipments matching the following criteria are Repriced.

Note: The Reprice Shipments process will reprice all the shipments that have been closed out, not invoiced, not manually priced, and are not cancelled, and will update the pricing of these shipments.

1. Where the user checks the Produce Error Report check box then the Report Format field is enabled where user can select the report format PDF or CSV and select Reprice button. An error reports is generated as per the format selected.

Anchor
_Toc47101687 _Toc47101687

Reprice Shipment Report Fields

Reprice Shipment Report Fields – CSV report:

Reprice Shipment Report Fields – PDF report:

Anchor
_Toc47101688 _Toc47101688

Reprice Shipments Report Examples

Anchor
_Toc47101689 _Toc47101689

Invoice Data Extract

This process is to extract billing data for shipments that have been closed out and have not been extracted for billing before. This is configurable, and once configured runs automatically on a daily basis; the Invoice Data Extract is not generated from the GUI. The data extract is exported in CSV format to an SFTP location that will be provided by Intersoft.
The invoice data extract contains the total customer charge of the shipments included in the report. Once a shipment has been included in the invoice extract the pricing cannot be edited, but pricing service enhancements can be added. Any pricing service enhancements added to a shipment after it has already been invoiced will be included in the next invoice data extract. 

Anchor
_Toc47101691 _Toc47101691

Invoice Data Extract File Example

...